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.Name | Responsible | Description | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Set up document - JSON |
Application Consultant |
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. For more information JSON, refer to Introducing JSON. |
||||||||||||||||||||||
Initialize document records and fields |
Application Consultant |
For documents of type XML or JSON, you can initialize the records based on an input file. To initialize records and fields for:
On initializing records, also the fields that are defined in the input file, are initialized. If you initialize based on:
When the initialization is finished, review and complete the properties of the initialized records and fields. Usually, during review, you do not add records or fields. However, you can remove the not needed record and fields. |
||||||||||||||||||||||
Add document records - JSON |
Application Consultant |
To each document, add the data records to be exchanged. For external file-based documents, set up the records in line with how the data is structured and named in the file. This topic explains how to add records to a JSON document. If records are already initialized for the document, you can review and complete the setup for these records. To do so, instead of adding a record, select the desired record. |
||||||||||||||||||||||
Manage document record setup - External documents |
Application Consultant |
You have several options to manage the document record setup for external file-based documents. You can:
|
||||||||||||||||||||||
Select fields |
Application Consultant |
You can add a selection of table fields to a record. You can select fields from the D365 FO table that is defined in the Record table field. This is mainly applicable to internal documents. However, you can also use this to quickly set up fields for external file-based documents. When the field selection is added to the record, review and complete the properties of the added fields. |
||||||||||||||||||||||
Copy fields |
Application Consultant |
You can copy fields from a record of another document. You can use this, for example, to save setup time if you use a specific record in several documents. You can only copy fields:
|
||||||||||||||||||||||
Add document record field - JSON |
Application Consultant |
To each document record, add the data fields which values must be exchanged. For external file-based documents, set up the fields in line with naming in the file. For JSON documents, fields are always of type string, to enable type conversions. This topic explains how to add record fields to a JSON document. If fields are already initialized for the document, selected for the record, or copied to the record, you can review and complete the setup for these fields. To do so, skip step 6. |
||||||||||||||||||||||
Manage document record field setup - Internal documents |
Application Consultant |
You have several options to manage the document record field setup for internal documents. You can:
|
||||||||||||||||||||||
Validate connectivity setup |
Application Consultant |
If you open a form or save (changes to) the setup of a key element in Connectivity studio, the setup is validated automatically. If errors are found in the setup, an error icon is shown. You can click the icon to show the related error messages. You can also manually start an automated test to check for errors in the setup. As a result, the found errors are shown. Also, the error icons are shown where applicable.
When errors are found, you can try to fix these errors automatically.
You can check and auto-fix errors for these key elements in Connectivity studio:
In this flow, in the activity steps, as an example, the validation is done for documents.
|
Name | Responsible | Description | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Set up document - JSON |
Application Consultant |
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. For more information JSON, refer to Introducing JSON. |
||||||||||||||||||||||
Initialize document records and fields |
Application Consultant |
For documents of type XML or JSON, you can initialize the records based on an input file. To initialize records and fields for:
On initializing records, also the fields that are defined in the input file, are initialized. If you initialize based on:
When the initialization is finished, review and complete the properties of the initialized records and fields. Usually, during review, you do not add records or fields. However, you can remove the not needed record and fields. |
||||||||||||||||||||||
Add document records - JSON |
Application Consultant |
To each document, add the data records to be exchanged. For external file-based documents, set up the records in line with how the data is structured and named in the file. This topic explains how to add records to a JSON document. If records are already initialized for the document, you can review and complete the setup for these records. To do so, instead of adding a record, select the desired record. |
||||||||||||||||||||||
Manage document record setup - External documents |
Application Consultant |
You have several options to manage the document record setup for external file-based documents. You can:
|
||||||||||||||||||||||
Select fields |
Application Consultant |
You can add a selection of table fields to a record. You can select fields from the D365 FO table that is defined in the Record table field. This is mainly applicable to internal documents. However, you can also use this to quickly set up fields for external file-based documents. When the field selection is added to the record, review and complete the properties of the added fields. |
||||||||||||||||||||||
Copy fields |
Application Consultant |
You can copy fields from a record of another document. You can use this, for example, to save setup time if you use a specific record in several documents. You can only copy fields:
|
||||||||||||||||||||||
Add document record field - JSON |
Application Consultant |
To each document record, add the data fields which values must be exchanged. For external file-based documents, set up the fields in line with naming in the file. For JSON documents, fields are always of type string, to enable type conversions. This topic explains how to add record fields to a JSON document. If fields are already initialized for the document, selected for the record, or copied to the record, you can review and complete the setup for these fields. To do so, skip step 6. |
||||||||||||||||||||||
Manage document record field setup - Internal documents |
Application Consultant |
You have several options to manage the document record field setup for internal documents. You can:
|
||||||||||||||||||||||
Validate connectivity setup |
Application Consultant |
If you open a form or save (changes to) the setup of a key element in Connectivity studio, the setup is validated automatically. If errors are found in the setup, an error icon is shown. You can click the icon to show the related error messages. You can also manually start an automated test to check for errors in the setup. As a result, the found errors are shown. Also, the error icons are shown where applicable.
When errors are found, you can try to fix these errors automatically.
You can check and auto-fix errors for these key elements in Connectivity studio:
In this flow, in the activity steps, as an example, the validation is done for documents.
|
Related to | Notes |
---|---|
Set up JSON document |
  |
Set up JSON document |
  |