1. Data Management
  2. Connectivity Studio
  3. Activities

Initialize document records and fields
Application task

For documents of type XML or JSON, you can initialize the records based on an input file. 
To initialize records and fields for:
  • An XML document, you can use an input file of type XML or XSD.
  • A JSON document, use an input file of type JSON.
On initializing records, also the fields that are defined in the input file, are initialized. If you initialize based on:
  • An XML file, only the field names are known and added to the relevant document records.
  • An XSD file, besides the field names, also the field properties can be defined and added to the relevant document records.
  • A JSON file, only the field names are known and added to the relevant document records.
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.


Standard procedure

1. Click Connectivity studio Integration Design.
2. Click the Documents tab.
3. In the list, find and select the desired document of type XML or JSON.
4. Click Edit.
5. In the Record section, click Initialize.
6.

To initialize, you can only use a connector of one these types:

  • Azure file storage
  • Azure Blob storage
  • SharePoint
  On the dialog, in the Connector field, enter or select the desired connector of type Azure file storage
7. Select the input file for the initialization.
If the document type is:
- XML, select a file of type XML or XSD.
- JSON, select a file of type JSON.
  In the File name field, enter or select a value.
 

Note: The default filter is defined by the Read filename field on the document header.
8. Click OK.
9. A dialog is shown with these options:
- Yes: all existing records and fields in the document are deleted and new records and fields are added based on the selected XML or XSD file content.
- No: New records and fields are added based on the selected XML or XSD file content. Existing records and fields are kept in the document.
- Cancel: The initialization is stopped before adding records and fields to the document.
  Click Yes.
 

Note: This dialog is only shown for XML documents.
10. Close the page.
Related to Notes

Set up XML document

 		 

Set up JSON document

 		 

Provide feedback