About This Integration

Overview of the integration

Microsoft Bookings is a solution for planning and managing business customer appointments using a shared calendar.

This integration enables you to access calendar data via Microsoft Power Automate. It provides two examples on how to list appointments and create new ones.

Note: The Microsoft Power Automate workflow accesses data using the Microsoft Graph gateway as there is no Microsoft Bookings connector in Microsoft Power Automate.
 

Preview of the tools used in this integration

• The Microsoft Bookings API provides several types of resources for accessing Microsoft Bookings data, i.e. information on businesses, customers, staff members, services and calendars.
   

Integration Data Feed (direction)		Authentication Type		Integration Connector Options
		Depending on the third-party service used (authentication managed by Logic Apps) Basic Authentication for the Service Manager REST API		Service Manager:    Workflows    Business rules MS Power Automate:    Connector: When a HTTP request is received (Service Manager trigger => Logic Apps)

Available versions
	SaaS-based	On-premises
Service Manager
Third-Party Product		N/A

Microsoft Bookings API - Definitions

API methods are accessed using a URL in the following format.

Objects used by the Microsoft Bookings API

• bookingBusiness object: Top level object in the API representing a business and containing business information on customers, teams, etc. as well as appointments.

• bookingBusinesses: All information on businesses. You access a specific business using its unique ID.

• bookingAppointment: All business appointments. An appointment is made up of a start time and an end time.

• bookingCustomer: All business customers.

• bookingCService: All services provided by a business.

• bookingStaffMember: All staff members providing services in a business.

Step-by-Step Integration Process

Prerequisites

• You must have an Azure subscription. If this is not the case, you can create a free account, or you can buy an Azure Pay-As-You-Go subscription.  See the procedure.
• You must have the relevant accounts and access rights to the services interfacing with Logic Apps.
• You must have a subscription to Office 365 Business Premium.

• You must have created the Microsoft Graph gateway for accessing Microsoft Bookings data.  See the pocedure.
• You must have the IDs provided by Microsoft Azure: Tenant (Directory) ID, Application (client) ID, Client secret.

Description of the workflow

Enable the Microsoft Graph gateway in Microsoft Power Automate

Step 1: Go to the Microsoft Power Automate start page.

1. Log in to the Microsoft Power Automate website using your account login.

Step 2: Create a flow for retrieving the Azure AD application information.

Note: The flow below will run automatically. You can use any type of trigger.

1. Select + Create in the left pane and click Instant flow.

2. Select the trigger method for Manually trigger a flow.

3. Click Create.

4. Store the Azure AD application information by creating the Initialize variable actions shown below.

5. Encode the client secret and password by creating two Compose actions.

Note: The {variables} instructions will automatically be replaced by the dynamic variables you previously created.

Step 3: Request an access token to the Microsoft Graph API.

1. Create a HTTP action.

2. Click  in the title bar and rename the action, HTTP POST Microsoft Graph.

3. Specify the information on the action.

Note: The {variables} and {outputs} instructions will automatically be replaced by the dynamic variables you previously created.

• Method: Select the POST value.
• URI: Enter the URL below.

  https://login.microsoftonline.com/@{variables('Tenant')}/oauth2/v2.0/token

• Headers: Specify the following values.
  • Key: content-type  
  • Value: application/x-www-form-urlencoded

• Body: Enter the following code.

  client_id=@{variables('App ID')}&scope=https://graph.microsoft.com/.default&grant_type=password&client_secret=@{outputs('Compose')}&username=@{variables('Email')}&password=@{outputs('Compose_2')}

4. Split the access token properties.

• Create a Parse JSON action.
           

• Specify the information on the action.
  • Content: Select the dynamic variable called Body from the HTTP Microsoft Graph action.
  • Schema: Enter the following JSON code.
    {
       "type": "object",
       "properties": {
           "token_type": {
               "type": "string"
            },
           "scope": {
               "type": "string"
            },
           "expires_in": {
               "type": "integer"
            },
           "ext_expires_in": {
               "type": "integer"
            },
           "access_token": {
               "type": "string"
            }
        }
    }

The values of the access token's properties will automatically be stored in dedicated variables.
 

Step 4: Retrieve a business ID in the calendar.

1. Retrieve all businesses in the calendar.

• Create a HTTP action.
           

• Click  in the title bar and rename the action, HTTP GET Microsoft Bookings.

• Specify the information on the action.
  • Method: Select the GET value.
  • URI: Enter the URL below.
    Note: You can filter businesses by adding the criteria you want in the URL.

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

  • Headers: Create the two following lines.
    • Key: content-type  
    • Value: application/json
       
    • Key: Authorization
    • Value: Bearer @{body('Parse_JSON')?['access_token']}
       

2. Retrieve the business ID you want by creating the Initialize variable actions shown below.

Note: The {variables} instructions will automatically be replaced by the dynamic variables you previously created.

The business ID will be stored in the ID Final without double quote variable. It enables you to access Microsoft Bookings resources for the business you want.

Examples of integration

List all business appointments

1. Create a HTTP action.

2. Click  in the title bar and rename the action, HTTP GET Microsoft Bookings Appointment.

3. Specify the information on the action.

Note: The business ID is called using the ID Final without double quote variable initialized when the gateway was enabled.

• Method: Select the GET value.
• URI: Enter the URL below.

  concat(concat('https://graph.microsoft.com/beta/bookingBusinesses/',@{variables('ID Final without double quote')}),'/appointments')

• Headers: Create the two following lines.
  • Key: content-type  
  • Value: application/json
     
  • Key: Authorization
  • Value: Bearer @{body('Parse_JSON')?['access_token']}

Create a new business appointment

1. Specify the information on the appointment by creating an Initialize variable action.

2. Save the appointment in the calendar.

• Create a HTTP action.
           

• Click  in the title bar and rename the action, HTTP POST Microsoft Bookings Appointment.

• Specify the information on the action.
  Note: The {variables} instructions will automatically be replaced by the dynamic variables you previously created when the gateway was enabled.

  • Method: Select the POST value.
  • URI: Enter the URL below.

    concat(concat('https://graph.microsoft.com/beta/bookingBusinesses/',@{variables('ID Final without double quote')}),'/appointments')

  • Headers: Create the two following lines.
    • Key: content-type  
    • Value: application/json
       
    • Key: Authorization
    • Value: Bearer @{body('Parse_JSON')?['access_token']}
       
  • Body: Enter the instruction below.

    json(@{variables('Json for creating appointment')})

The new appointment will be added to the business calendar.

AccountFreeCreation