Set up external documents - File based

Prev Next

Use an external file-based document to define the data model of the external source or target with which you want to exchange data.

The available file-based external document types are:  

Document type

Description

XML

Use an XML document to exchange data in XML format without the need to code. With a document of type XML, you can read data from or write data to an XML file.

JSON

Use a JSON document to exchange data with an application that uses data-object notation. With a document of type JSON, you can read data from or write data to a JSON file.

Text

Use a Text document to read data from or write data to a file with field and line separators. For example, a CSV file.

Fixed text

Use a Fixed text document to read data from or write data to a file with defined start positions and lengths for fields.

EDI

Use an EDI document to read data from or write data to a file if you use EDIFACT or ANSI X12 for your EDI.

Microsoft Excel

Use a Microsoft Excel document to read data from or write data to a Microsoft Excel file (XLSX).

Microsoft Word

Use a Microsoft Word document to write data to Microsoft Word document (DOCX) using a template.

Flow diagram