Overview
Our standard integration against D365 F&O is designed to get you up and running with AGR quickly, powered with data from D365 F&O.
This guide provides instructions on setting up Recurring Integrations for F&O (Cloud) with the necessary data that AGR requires. Recurring Integrations builds on data entities and the Data management framework and enables the data transfer between F&O and third-party services or applications.
It uses secure REST application programming interfaces (APIs) and authorization mechanisms to receive data from, and send data back to, integration systems.
The integration REST API uses the same OAuth 2.0 authentication model as the other service endpoints. Before the integrating client application can consume this endpoint, you must create an application in Microsoft Entra ID (Azure AD) and give it appropriate permission to the application. You will need the application ID when you create and enable a recurring job. The application ID will go into the System admin -> azure active directory screen and on the recurring job.
Data Mapping
In the article AGR x D365 F&O Data Entities, you will find the complete list of Dynamics 365 Finance & Operations data entities and their corresponding fields needed by the AGR.
The standard mapping of D365 F&O data into the AGR Data Interface can be found in the AGR Data Interface - F&O Data Mapping.
If you need customizations to the data mapping to fit your needs, this can often be accommodated at a cost.
Instructions
Create a Data Project
From the main F&O dashboard, navigate to Workspaces and select Data management.
Choose Export to create a new data export project.
Choose a descriptive job name, and ensure the data source corresponds to the entities and fields detailed in AGR x D365 F&O Data Entities.
Upload a data file for the entities. Make sure that each entity is added, and that no errors occur.
Create a Recurring Data Job
Open Data management, locate your project, and select Create recurring data job.
Enter a job name and a description.
In Setup authorization policy, enter the Application (client) ID from Azure AD (created in the Overview)
In Advanced Options choose files.
The job should run daily at end of business day.
Give AGR Access to the Imported Files
In Manage -> Manage recurring data jobs, note the job’s unique ID, AGR needs it.
AGR needs the URL. https://<base URL>/api/connector/enqueue/<ID>?
AGR needs application id, secret value and tenant id of the app created in Overview.
AGR needs the resource or F&O base URL (e.g.,
https://company.operations.dynamics.com).