This walkthrough provides an overview of how to export data from Microsoft Dynamics 365 Business Central. In the following example, you export item data in fixed-length format.
Prerequisites
Template | Description | Sample file |
|---|---|---|
TI_CS_ITEM.OUT | STAEDEAN Template: Export Items (TXT Format) | N/A |
Story
This connection uses a Timer Event to trigger the pipeline based on a time interval in Microsoft Dynamics 365 Business Central. Once the pipeline triggers, the XML Generator activity creates an XML file based on an internal document and filtered set of data. The XML to Text Translator converts the XML to a text document. The File Writer writes the text document to the specified location.
Setup
Import the Connectivity Studio Connection-TI_CS_ITEM.OUT.zip configuration package.
Open the TI_CS_ITEM.OUT connection. On the Connection page, edit the File Writer settings and enter the folder name.
Process
Process the connection.
Check the output folder location.
A text file with the item details is created. In this scenario, the item details are exported based on the following filter: Item: No.=>1000&<1200. You can change this in the Timer Event settings.
Result
This exports items in fixed-length format based on the internal document structure and a filtered set specified in the Timer Event.