Versions Compared

Old Version 2

changes.mady.by.user Michelle Coelho de Oliveira

Saved on

compared with

New Version Current

changes.mady.by.user Genevieve.bourgeois (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table of Contents

...

Bookings visualization

If you don’t see any appointments or some appointments are not showing in the calendar, verify your filter option.

...

Configuration time zone

...

Configuration for Terminals

Using Booking Tools (user-friendly)

...

Introduction

https://www.microsoft.com/en-ca/microsoft-365/business/scheduling-and-booking-app

Business Process

...

Security

https://docs.microsoft.com/en-us/microsoft-365/bookings/addbookings-stafffaq?view=o365-worldwide).

The e-mail default will be: terminal + number + region + @tc.gc.ca

like: terminal1pnr@tc.gc.ca, terminal2pnr@tc.gc.ca

  1. Go to Settings > Staff > Add new staff

    Image Removed

  2. Add a name > Select the option Use this name

    Image Removed

  3. Add the e-mail and save changes.

    Image Removed

...

-worldwide#where-is-bookings-data-stored-

“…meaning all data is stored within the Microsoft 365 platform and in Exchange.”

It is in exchange and our tenant according to them. Microsoft 365 platform is in Canada server.

Connection with Microsoft Graph (technical side)

  1. Open Microsoft Graph Explorer

  2. Connect with your TC Account and select the “beta” option
    For the Booking Tools API, here is the reference https://docs.microsoft.com/en-us/graph/api/resources/booking-api-overview?view=graph-rest-beta

    Image RemovedImage Added

    1. You will need to give consent for the Graph Explorer to access the Bookings API on your behalf. To do so, click the ellipses near your name, and click “Select Permissions”

      1. Image Added

    2. From the flyout on the right, choose “Bookings” and add the appropriate permissions you need.

      1. Image Added

  3. Find your business id. Run the query below and in Microsoft graph response find your booking name

    Code Block
    https://graph.microsoft.com/beta/bookingBusinesses

Using Microsoft Graph (technical side)

  1. To select all members, you can use the query below and run it

    Code Block
    https://graph.microsoft.com/beta/bookingBusinesses/PNRCivilAviationExamBooking@034gc.onmicrosoft.com/staffMembers

  2. To create a new staff, you can take information from an existing one.

    1. You need to remove id and add @odata.type, change the field “displayName” and “emailAddress”
      Reference: https://docs.microsoft.com/en-us/graph/api/bookingbusiness-post-staffmembers?view=graph-rest-beta&tabs=http

      Code Block
      {
    
      "@odata.type":"#microsoft.graph.bookingStaffMember",
    "displayName": "Terminal 2",
    
      "
      displayName
      emailAddress": "
      Terminal 2
      terminal2pnr@tc.gc.ca",
    "availabilityIsAffectedByPersonalCalendar": false,
    "colorIndex": 8,
    "
      emailAddress
      role": "
      terminal2pnr@tc.gc.ca
      externalGuest",
    "useBusinessHours": false,
    
      "
      availabilityIsAffectedByPersonalCalendar
      workingHours":
      false,
       [
        {
            "
      colorIndex
      day":
      8
      "monday",
            "
      role
      timeSlots":
      "externalGuest",
      []
        },
        {
      "useBusinessHours
             "day":
      false
      "tuesday",
            "
      workingHours
      timeSlots": [
                {
                    "
      day
      start": "
      monday
      08:15:00.0000000",
                    "
      timeSlots
      end":
      []
      "12:30:00.0000000"
                }
      ,
      
            ]
      {
      },
        {
            "day": "
      tuesday
      wednesday",
            
      "timeSlots": [
                
      {
      
                    
      "start": "08:15:00.0000000",
                    
      "end": "12:30:00.0000000"
                }
      }
           ]
        },
      ]
        {
      }
      "day": "thursday",
            "timeSlots": [
      {
                    
      {
      "day":
      "wednesday", 
                      
      "
      timeSlots
      start":
      [
      "08:15:00.0000000",
                    "end": "12:30:00.0000000"
      {
                    }
            ]
      "start":
      "08:15:00.0000000",
            },
        
      {
            "
      end
      day": "
      12:30:00.0000000"
      friday",
            
      "timeSlots": []
        },
        {
      ]
       "day": "saturday",
            "timeSlots": []
      },
              },
        {
      
            
      "day": "
      thursday
      sunday",
      
            
      "timeSlots": []
        }
    ]
}

    2. Change the action to POST and click on Run Query

      Image Added

Information

At the end of this configuration, maybe will receive a message like that:

...

This is not worrying as this staff will only be used for assigned automatically appointments

Configuration for services

Using Booking Tools (user-friendly)

  1. Go to Settings > Services > Add new service

    Image Added

  2. For a new service, you have some configuration to add, so it is important to take a time to fill in each available option.

    Note: the option Maximum number of attendees, if you choose 1 attendee(s) and you have 2 staffs like Guess, please pay attention because in this service you can have 2 appointments at the same time, one for the first staff (like terminal 1) and another for the second staff (like terminal 2).
    This setting was desired by the members of this booking.

    Image Added

  3. After fill out all options desired, click on Save changes to create the service.

Using Microsoft Graph (technical side)

  1. To select all services, you can use the query below and run it.

    Code Block
    https://graph.microsoft.com/beta/bookingBusinesses/PNRCivilAviationExamBooking@034gc.onmicrosoft.com/services

    Image Added

  2. To create a new service, you can take information from an existing one.

    1. You need to remove id and add @odata.type and change others fields as you want.
      Reference: https://docs.microsoft.com/en-us/graph/api/bookingbusiness-post-services?view=graph-rest-beta&tabs=http

      Code Block
      {
    "@odata.type":"#microsoft.graph.bookingService",
      { 
      "displayName": "AIRAF - INSTRUCTOR RATING CLASS 4 AEROPLANE",
    "defaultDuration": "PT3H30M",
    "defaultPrice": 35,
    "defaultPriceType": "fixedPrice",
    "
      start
      description": "
      08:15:00.0000000", 
      Exam duration - 3 hoursRequirements:Government issued ID (i. e. passport, Aviation Document Booklet, drivers license)Category 1 MedicalFlight Training Unit Letter of recommendation if applicable or proof of 15 hours instructor flight training and all",
    "
      end
      isHiddenFromCustomers": false,
    "notes"
      12:30:00.0000000"
      : "",
    "additionalInformation": "",
    "preBuffer": "PT0S",
    "postBuffer": "PT0S",
    "staffMemberIds": [],
      }
         "isLocationOnline": false,
    "schedulingPolicy": null,
    "defaultLocation": {
      ]
          "displayName": "344 Edmonton St",
        "locationEmailAddress":
      }
      null,
        "locationUri": "",
      {
        "locationType": null,
        "uniqueId": null,
        "
      day
      uniqueIdType":
      "friday"
      null,
        "address": {
            "
      timeSlots
      type":
      []
      "home",
            "postOfficeBox": "",
      },
              "street": "344 Edmonton St",
      {
             "city": "Winnipeg",
            "
      day
      state": "
      saturday
      Manitoba",
            "countryOrRegion": "Canada",
      "timeSlots":
      []
           "postalCode": "R3C 
      0P6"
        },
        "coordinates": {
      {
            
      "altitude": null,
            "
      day
      latitude":
      "sunday"
      null,
            "longitude": null,
      "timeSlots":
      []
         "accuracy": null,
      }
      "altitudeAccuracy": null
        }
      ]
        },
    "defaultReminders": []
}

    2. Change the action to POST and click on Run Query

      Image Removed

Information

At the end of this configuration, maybe will receive a message like that:

...

This is not worrying as this staff will only be used for assigned automatically appointments

Configuration for services

Using Booking Tools (user-friendly)

  1. Go to Settings > Services > Add new service

    Image Removed

  2. For a new service, you have some configuration to add, so it is important to take a time to fill in each available option.

    Note: the option Maximum number of attendees, if you choose 1 attendee(s) and you have 2 staffs like Guess, please pay attention because in this service you can have 2 appointments at the same time, one for the first staff (like terminal 1) and another for the second staff (like terminal 2).
    This setting was desired by the members of this booking.

    Image Removed

  3. After fill out all options desired, click on Save changes to create the service.

Using Microsoft Graph (technical side)

Power BI

...

    1. Image Added

    2. Result

      Image Added

Custom fields

I didn’t find any reference in the Booking Tools API to create/add custom fields by Microsoft Graph.

Power BI

  1. Open Power BI Desktop. If you don’t have installed this software in your machine, you can open Microsoft Store

    Image Added

  2. Search Power BI Desktop and install it.

    Image Added

  3. Click on Get Data

    Image Added

  4. Select Online Services > Microsoft Exchange Online and click on Connect

    Image Added

  5. Add your booking page address and click OK.

    Image Added

    Note: If you don’t know your booking address click on Booking Page and copy the address from the Booking Page Status.

    Image Added

  6. Select Microsoft account > Sign in

    Image Added

  7. Click on Connect

    Image Added

  8. Select Calendar > Load

    Image Added

Dashboard

...