How to use Microsoft Graph API Adapter ?

Introduction #

• The Microsoft Graph API Adapter is a powerful tool that enables seamless integration between Microsoft’s suite of applications and external systems. Leveraging the capabilities of the SKYVVA Integration App, users can efficiently connect, manage, and automate data exchange with Microsoft Graph API. This guide provides a straightforward approach to using the Microsoft Graph API Adapter in conjunction with the Skyvva platform, ensuring streamlined processes and enhanced productivity.
• SKYVVA  is a leading integration app renowned for its user-friendly interface and robust capabilities. It simplifies complex integrations by eliminating the need for extensive coding, allowing users to focus on business logic. The Microsoft Graph API Adapter extends this functionality, providing a gateway to interact with Microsoft services such as Outlook, SharePoint, Teams, and OneDrive.
• To begin, you need to set up the SKYVVA Integration App and configure the Microsoft Graph API Adapter. This involves registering an application, obtaining client credentials, and granting the necessary permissions for the required Microsoft services. These credentials are then linked to the adapter within SKYVVA, establishing a secure connection.
• Once the connection is established, the user can define integration scenarios within the SKYVVA platform. These scenarios enable you to map data fields, transform data formats, and automate workflows between Microsoft services and your target systems. For instance, users can synchronize calendar events, automate email notifications, or manage files in OneDrive.
• The adapter’s user-friendly interface ensures that even non-technical users can create and manage integrations with ease. Additionally, SKYVVA offers monitoring and error-handling features to ensure reliable operations.

The Microsoft Graph API Adapter, when used with the SKYVVA Integration App, empowers businesses to unlock the full potential of Microsoft’s ecosystem. By following this guide, you can establish seamless integrations, optimize workflows, and drive efficiency across your organization.

Pre-Requisite #

To successfully use the Microsoft Graph API Adapter with the SKYVVA Integration App, several prerequisites must be met to ensure a seamless configuration and execution. Below are the steps and requirements that must be fulfilled before diving into the integration:

1. Skyvva Integration App Setup #

• Install and configure the SKYVVA Integration App within your Salesforce environment. Ensure it is correctly deployed and operational.
• Verify that the SKYVVA Integration App supports the Microsoft Graph API Adapter in your version.

2. Microsoft Graph API Adapter Configuration #

• Obtain and install the Microsoft Graph API Adapter within the SKYVVA Integration App.
• Configure the adapter with the client ID, and client secret.

3. Technical Knowledge #

• Familiarize yourself with the Microsoft Graph API endpoints you intend to use and the associated data models. Also, understand the SKYVVA Integration App’s user interface and functionality.
• Once these prerequisites are met, you are ready to begin creating and testing your integration flows with the Microsoft Graph API Adapter.

https://developer.microsoft.com/en-us/graph/graph-explorer

Get Authorization code API:

Get Access and Refresh Token API:

Get Access Token using Refresh Token API:

 

Get Profile Info API:

 

Microsoft Graph API Adapter

1. Microsoft Control Board:

• Go to Integration Ex: Microsoft_Graph_API_Integration
• Click on Microsoft Control Board

• Click on the Adapter tab.

 

• Click on the New button.

 

       Adapter Name: Microsoft_Graph_Get_Profile_OB

• Configure the adapter based on your Microsoft credentials.
• I use Authorization: Auth2.0 and the authorization code technique to generate access and refresh tokens.
• Then we can access Microsoft graph APIs using an access token.
• Direction: Outbound
• Type: Microsoft Graph API

• Click on the Test button, which will redirect to a new screen
• Test the connection and also test the adapter with dynamic path, query, header, and body parameters.

• Click on the Test Connection button.

[su_box title=”Note” box_color=”#2a8af0″ title_color=”#000000″]Also, you can save your dynamic path, query, header, and body parameters.[/su_box]

REST Template

• Go to metadata: Microsoft_Graph_API_Metadata
• Go to Repository: Microsoft_Graph_API_Repo

2. Create Message Type Structure:

1.1 Request message type structure:

1.2 Response Message Type Structure:

• Message Type Field Entry is known as fields of the response JSON and it will generate automatically when you create a message type using your API definition files like open API and swagger etc.

3. Create an outbound interface for request:

3.1 Create outbound interface: Microsoft_Graph_Get_Profile_OB

3.2 Mapping for a single node: Here we are using Get API so we are not using dynamic body, dynamic path, query, and header features but we can use them based on different requirements.

4. Create an inbound interface for response:

4.1 Create interface for response: Microsoft_Graph_Get_Profile_IB

4.2 Mapping for a single node:

5. Connecting Adapter to request interface:

Connecting Response interface to request interface:

8. Run the callout script:

skyvvasolutions.CallOutControl c = new skyvvasolutions.CallOutControl();
c.returnJSONComplete=true;
c.actionDoIntegrate=true;
c.isCreateMessage=true;
//String [] ids= new String []{'0019b00000Z60gKAAR'};
List<CalloutResponse> result = skyvvasolutions.Iservices.invokeCalloutV3('Microsoft_Graph_API_Integration','Microsoft_Graph_Get_Profile_OB',null,'SYNC',c);

[su_box title=”Note” box_color=”#2a8af0″ title_color=”#000000″]You can able to pass a list of record IDs as a third argument so it will check record is exit in Salesforce database using external id field if it is not then it will create new records otherwise it will update the existing record with same external id.[/su_box]

9. Check Result in Message Monitoring:

Response log in Inbound Message:

Result in Developer Console using SOQL:

SELECT Id, Name, Phone, Website, CreatedDate, LastModifiedDate FROM Account

Summary #

Now users understand how to integrate the Skyvva app with Microsoft Control Board APIs, ensure: Skyvva Configuration: Install the app and set up custom links for API calls. Credentials: Securely store client ID and secret. Understand OAuth 2.0: Familiarize yourself with the authorization flow. These steps ensure seamless API integration.