External Systems are used for having an incremental changelog for configured tables and fields. This is useful in integrations through Web Services or the Integration Queue
The external systems feature is used when Dynamics 365 Business Central is integrated with other systems. The main purpose of the module is to keep other systems synchronized with Dynamics 365 Business Central by creating log entries. These log entries are then retrieved by the external system via Web Services. Once the log entries are fetched the external system performs a read call on the appropriate Web Service to refresh the data in the external system.
It is possible to log and retrieve logged records from any table in Dynamics 365 Business Central, but it is not recommended to log tables that are intensively updated with a high number of new or changed records, as it can cause tables to lock and performance deterioration. The Web Services in Spider can be used to read data from specific tables and fields. If there is a need to publish other pages or codeunits within Dynamics 365 Business Central, see information on how to publish web services on Microsoft Docs
Flow External Systems API
The flow needs to be repeated frequently, possibly with a scheduler.
- External system calls
spiderExternalSystemAPI.GetChangedRecords()with an empty
fetchIdasking if there are changed records.
spiderExternalSystemAPI.GetChangedRecords()checks the Unsynchronized list for changed records.
spiderExternalSystemAPI.GetChangedRecords()does not find changes
fetchIdwill be returned empty and the External System knows there are no changed records and the call will end.
spiderExternalSystemAPI.GetChangedRecords()does find changes
fetchIdwill be given a GUID to pack the changes and returns the
fetchIdand key of changed records.
- External system calls relevant Web service to get the changes
- External system calls
fetchIdand asks if there are changed records. Step 3 to 6 will repeat until there are no changed records.
To create a new External System manually
- Choose the search icon, enter External Systems, and then choose the related link.
- On the External Systems list, choose the New action.
- A new External Systems card opens. Proceed to fill the fields on the External systems card as necessary.
- Navigate to Table Setup to add tables and fields, with or without filters.
To create a new External System with a guide
- Choose the search icon, enter External Systems Setup Guide, and then choose the related link.