Skip to content

Azure Functions for retrieving data from SharePoint Online and Dynamics 365 Business Central with Azure AD app and Microsoft Graph API

Notifications You must be signed in to change notification settings

rocjoe12/data-source-functions

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

18 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Azure Functions for retriving data from SharePoint Online 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 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.

Installation

SharePoint

  1. Sign into your Office 365 tenant as tenant administator and navigate to Azure Active Directory admin center.
  2. Register an Azure AD app and add application permissions to read data from SharePoint sites via Microsoft Graph API (Sites.Read.All).
  3. Grant admin consent for your tenant.
  4. Sign into Azure Portal, create function app and deploy FunctionApp project.
  5. 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

Dynamics 365 Business Central

  1. Sign into your Office 365 tenant as tenant administator and navigate to Azure Active Directory admin center.
  2. Register an Azure AD app and add delegated permissions to read/write financials data via Microsoft Graph API (Financials.ReadWrite.All).
  3. Sign into Azure Portal, create function app and deploy FunctionApp project
  4. Copy URL of D365-BC-Authorize function and add it to Authentication -> Redirect URIs of the Azure AD app
  5. 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
  1. Open D365-BC-Authorize by its URL in your browser and provide app with the required permissions. After that, all functions will request data from Dynamics 365 on behalf of your account. The end-user will not be asked for permissions.

License

The MIT License (MIT)

Copyright (c) Plumsail

About

Azure Functions for retrieving data from SharePoint Online and Dynamics 365 Business Central with Azure AD app and Microsoft Graph API

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages

  • C# 100.0%