MuleSoft Connector for Dynamics 365

Build 21.0.8137

Batch Processing

Use the Bulk Execute operation to combine multiple statements of the same data manipulation operation into one statement. When the Bulk Execute operation is invoked, the connector builds one API request for each type of operation.

Configuring Bulk Ops in the Visual Editor

To configure the operation in the Visual Editor, select the connector inside your flow and specify the following connector properties.

  • Connector Configuration: Select a connection you created. See Establishing a Connection for more information.
  • Operation: Choose Bulk Execute.
  • SQL Query: Enter one or more SQL statements. See the following examples. The statements can also contain expressions.

Bulk Insert

The following examples combine multiple inserts into a single Dynamics 365 request:

SQL

INSERT INTO GoalHeadings (GoalHeadingId) VALUES ('Jon Doe'); INSERT INTO GoalHeadings (GoalHeadingId) VALUES ('John');
XML
<cdata-dynamics365bulk-execute config-ref="CData_Dynamics365_Configuration" query="INSERT INTO GoalHeadings (GoalHeadingId) VALUES ('Jon Doe'); INSERT INTO GoalHeadings (GoalHeadingId) VALUES ('John');" doc:name="CData Dynamics365"/>

Bulk Update

The following examples combine multiple updates into a single Dynamics 365 request:

SQL

UPDATE GoalHeadings SET GoalHeadingId='Jon Doe' WHERE GoalHeadingId = 'MyGoalHeadingId1';UPDATE GoalHeadings SET GoalHeadingId='John' WHERE GoalHeadingId = 'MyGoalHeadingId2';
XML
<cdata-dynamics365bulk-execute config-ref="CData_Dynamics365_Configuration" query="UPDATE GoalHeadings SET GoalHeadingId='Jon Doe' WHERE GoalHeadingId = 'MyGoalHeadingId1';UPDATE GoalHeadings SET GoalHeadingId='John' WHERE GoalHeadingId = 'MyGoalHeadingId2';" doc:name="CData Dynamics365"/>

Bulk Delete

The following examples combine multiple deletes into a single Dynamics 365 request:

SQL

DELETE FROM GoalHeadings WHERE GoalHeadingId = 'MyGoalHeadingId1'; DELETE FROM GoalHeadings WHERE GoalHeadingId = 'MyGoalHeadingId2'; 
XML
<cdata-dynamics365bulk-execute config-ref="CData_Dynamics365_Configuration" query="DELETE FROM GoalHeadings WHERE GoalHeadingId = 'MyGoalHeadingId1'; DELETE FROM GoalHeadings WHERE GoalHeadingId = 'MyGoalHeadingId2'; " doc:name="CData Dynamics365"/>

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137