Azure Functions for retriving data from SharePoint Online, Dynamics CRM, and Dynamics 365 Business Central using Azue AD App and Microsoft Graph API
This repository contains Azure Functions for retrieving data from a SharePoint list, Dynamics CRM, and Dynamics 365 Business Central. These functions can be used anonymously without additional authentication and requesting permissions from the end-user. For instance, they can be utilized in public web forms as data sources for choice fields, e.g. drop-downs, checkboxes, or radios. For more inforamtion on how to install and use them, read articles on retrieving data from SharePoint Online and Dynamics 365 Business Central.
- Sign in to your Office 365 tenant as tenant administator and navigate to Azure Active Directory admin center.
- Register an Azure AD app and add application permissions to read data from SharePoint sites via Microsoft Graph API (Sites.Read.All).
- Grant admin consent for your tenant.
- Sign in to Azure Portal, create function app and deploy FunctionApp project.
- Set up application settings for your function app:
| Name | Description |
|---|---|
| SharePoint:AzureApp:ClientId | Id of the Azure AD app |
| SharePoint:AzureApp:ClientSecret | Client Secret of the Azure AD app |
| SharePoint:AzureApp:Tenant | Office 365 tenant, ex.: contoso.onmicrosoft.com |
| SharePoint:ListData:SiteUrl | The absolute URL of the source site, ex: https://contoso.sharepoint.com/sites/mysite |
| SharePoint:ListData:ListName | The name of the source list |
- Sign in to your Office 365 tenant as tenant administator and navigate to Azure Active Directory admin center.
- Register an Azure AD app and add delegated permissions to Dynamics CRM: Dynamics CRM → user_impersanation.
- Sign in to Azure Portal, create function app and deploy FunctionApp project
- Copy URL of D365-CRM-Authorize function and add it to Authentication → Redirect URIs of the Azure AD app
- Set up application settings for your function app:
| Name | Description |
|---|---|
| Dynamics365.CRM:AzureApp:ClientId | Id of the Azure AD app |
| Dynamics365.CRM:AzureApp:ClientSecret | Client Secret of the Azure AD app |
| Dynamics365.CRM:AzureApp:Tenant | Office 365 tenant, ex.: contoso.onmicrosoft.com |
| Dynamics365.CRM:AzureApp:DynamicsUrl | URL of the Dynamics CRM, ex.: https://contoso.crm.dynamics.com |
- Copy URL of D365-CRM-Authorize, open it in your browser, and provide the app with the requested permissions. After that, all functions for Dynamics 365 CRM will perform on behalf of your account. The end-user will not be asked for permissions.
- Sign in to your Office 365 tenant as tenant administator and navigate to Azure Active Directory admin center.
- Register an Azure AD app and add delegated permissions to read/write financials data via Microsoft Graph API (Financials.ReadWrite.All).
- Sign in to Azure Portal, create function app and deploy FunctionApp project
- Copy URL of D365-BC-Authorize function and add it to Authentication → Redirect URIs of the Azure AD app
- Set up application settings for your function app:
| Name | Description |
|---|---|
| Dynamics365.BusinessCentral:AzureApp:ClientId | Id of the Azure AD app |
| Dynamics365.BusinessCentral:AzureApp:ClientSecret | Client Secret of the Azure AD app |
| Dynamics365.BusinessCentral:AzureApp:Tenant | Office 365 tenant, ex.: contoso.onmicrosoft.com |
| Dynamics365.BusinessCentral:Customers:Company | The name of the source company of customers |
| Dynamics365.BusinessCentral:Vendors:Company | The name of the source company of vendors |
| Dynamics365.BusinessCentral:Items:Company | The name of the source company of items |
- Copy URL of D365-BC-Authorize, open it in your browser, and provide the app with the requested permissions. After that, all functions for Business Central will perform on behalf of your account. The end-user will not be asked for permissions.
The MIT License (MIT)
Copyright (c) Plumsail