Logic App Integration with D365 F&O
Azure Logic Apps is a cloud service that helps you schedule, automate, and orchestrate tasks, business processes, and workflows. It’s ideal for when you need to integrate apps, data, systems, and services across enterprises or organizations. Logic Apps simplifies how you design and build scalable solutions for app integration, data integration, system integration, enterprise application integration (EAI), and business-to-business (B2B) communication — whether in the cloud, on premises, or both.
Integrate data bet. This example covers an integration solution for Dynamics 365 for Finance & Operations (F&O).This process uses Odata Rest API to post data to Dynamics 365 F&O from Azure blob storage. Uploading a package can be an automated process with Power shell command and “Microsoft Azure Storage AzCopy tool.”
Prerequisites
- Import Project setup in D365
- Azure Subscription
- Sample Package
- Manifest.xml
- PackageHeader.xml
- Data File [Data.csv] –
Make sure the data file name and file name from Manifest.xml file name tag value match to execute the package successfully.
D365 F&O Import Project Package
- Open import project from work space=> Data management Option => Data Project List
- Click on Download to get the package
Register Active Directory APP
- Login to Azure Portal [ https://portal.azure.com/]
- Select Azure Active Directory Menu
- Click on App registrations
Setup Active Directory APP Keys
- Select the App created
- Click on Certificates & Secrets
- Add new entry
Make sure you copy the new client secret value. You won’t be able to retrieve it after you perform another operation or leave this blade.
Setup Blob Storage
- Click on Create Resource from main menu
- Click on Storage
- Click on Storage Account
- Fill all required details
- Set Access tier to “Hot”
Setup Containers in Blob Storage
Create Logic App
- Click on Create Resource link from main menu
- Click on Integration
- Select Logic App
- Enter all required details and click on Ok
Configure Logic App
Step 1
Select template [Blob Storage To Dynamics 365 Import]
Step 2
Connect Blob Storage
Step 3
Connect Office 365 [This needs an Office 365 license]
This connection is used to send notifications. There are lots of other connectors available to send notifications.
Step 4
Set Recurrence (Schedule) to trigger Logic App
This is the time when Logic App will check to see if any files are dropped in Blob Storage. Azure only charges for triggered transactions.
Step 5
Initiate Package
All authentication data should copy from Azure Active Directory App
Step 6
Execute Import Project on D365
Verify Data
- Upload package on Blob Storage Container “storage 1”
- Once the Logic App successfully completes, login to D365 F&O
- Click on Work Space=> Data management Option
- Select Import Project from Data Project List