Getting Lists
Having current lists of vendors, account codes, and other accounting related list elements from the ERP is critical for bidirectional data flows. Each object must be retrieved separately. Depending on the number of objects that need synchronization, and the schedule at which that synchronization needs to happen, retrieving lists from Business Central may be done in one or more workflows.
NOTE: When using the CRON Import node, any saved workflow may have ONLY one import node on the design surface. If you need to set multiple schedules for different objects, a different workflow must be used.
Steps
Use the Dynamics 365 node to pull an objects data into a table field.
The response body for all requests is automatically mapped to fields with matching names in the table. Ensure your table fields are setup to retrieve the data or interest by inspecting the documented response objects from Microsoft’s documentation.
Use the List Update node to set the list values from the previous step. This will result in rows of data from the table being used to update or set lists in GlobalCapture. You may overwrite or append to lists, but the GlobalCapture API will prevent insertion of duplicates in either case.
WARNING: If you perform numerous list updates in a single step, be sure to check the “Clear Table Field Before Request” option. This will ensure data from a previous request in the flow is not included with list data from the current request.