Integrate with Microsoft Dynamics Sales CRM using the Microsoft Dataverse SDK.
0.0.0.1 - Initial release.
0.0.0.3 - Template changes.
0.0.0.7 - Node name correction.
| Parameter |
Type |
Description |
Instance URL |
String |
Entra ID tenant identifier (or common for multi-tenant). |
Client Id |
String |
Application (client) ID registered in Entra ID. |
Client Secret |
Masked |
Client secret generated for the app registration. |
- Register an application in Entra ID (Azure AD) with application permissions under
Dynamics CRM: user_impersonation and Dynamics ERP: Connector.FullAccess.
- Grant admin consent for the selected permissions or ensure the signed-in user has consented.
- Configure the connection with
Tenant Id, Client Id and Client Secret.
Once you have an app registration, you need to add it to your Dynamics Sales CRM environment.
In your Sales instance (https://{your business unit code}.crm4.dynamics.com/):
- Click the Settings icon (gear icon) in the top-right pane to open the Settings pane.
- Click
Advanced Settings. This opens a new tab.
- In the new tab, under Business Management on the left pane and the System heading, click
Security (Preview).
- In the center pane for Security (Preview), click
Application users, which opens another new tab.
- In the Application users tab, click
+ New app user at the top left to open the Create a new app user pop-up window.
- Click
+ Add an app, then search for and select the registered application you created in Entra. Click the green Add button at the bottom.
- In the Business Unit text box, enter your business unit code. You can find this in the URL of your Dynamics Sales site, for example
https://orge18596b7.crm4.dynamics.com/, where the business unit is orge18596b7.
- Set the Security Roles by clicking the pencil button on the right of Security Roles.
- From the list that opens, choose the following: Basic User, Dataverse Search Role, and System Administrator. Then click
Save.
- Click
Create at the bottom of the Create a new app user panel.
Ensure the connection is properly set up in Flowgear by testing the connection in the connection settings.
| Parameter |
Type |
Notes |
Connection |
Connection |
The connection for the Dataverse environment. |
Request |
Object |
Query definition containing entity, select, filter, and order clauses. |
| Return |
Type |
Notes |
Response |
Array |
Result of the query. |
| Parameter |
Type |
Notes |
Connection |
Connection |
The connection for the Dataverse environment. |
Request |
Array |
Payload describing the entity and attributes to write. |
BatchSize |
Integer |
Number of items to include per batch when sending requests. Defaults to 20. |
| Return |
Type |
Notes |
Response |
Array |
Result of the create operation. |
| Parameter |
Type |
Notes |
Connection |
Connection |
The connection for the Dataverse environment. |
Request |
Array |
Payload describing the entity, Id, and attributes to update. |
BatchSize |
Integer |
Number of items to include per batch when sending requests. Defaults to 20. |
| Return |
Type |
Notes |
Response |
Array |
Result of the update operation. |