Sorting data when writing a JSON File
When writing a JSON file, data can be sorted with the use of sort keys.
This offers the possibility to order easily the data that is written in the JSON file with, if needed, multiple sort keys.
Add new comment
Due to some maintenance operations, stambia.org will be switched to read-only mode during the 13th November. It will be possible to read and download, but impossible to post on the forums or create new accounts. For any question please contact the support team.
When writing a JSON file, data can be sorted with the use of sort keys.
This offers the possibility to order easily the data that is written in the JSON file with, if needed, multiple sort keys.
When multiple JSON files have the same structure, it is possible to process them all at the same time seamlessly.
The JSON Metadata and technology in Stambia offers the possibility to use 'Property Fields'.
A Property field is an internal field that can be added to the JSON Metadata and that allows to retrieve information such as the file name, path or size at read.
This functionality also permits to define dynamically the JSON nodes' name when writing a JSON file.
This is particularly useful when the name of the node is containing dynamic data information.
Sometimes, the name of a JSON node can contains itself data information.
In this case, the name of the node will vary on each file, on each occurrence or execution.
The Stambia's JSON technology offers the possibility to read easily this kind of nodes by specifying a name pattern in the JSON Metadata.
Stambia Data Integration allows to work with JSON files to produce fully customized Integration Processes.
The JSON structure can be entirely reversed in Metadata and then used in Mappings and Processes to design and adapt the business rules to meet the user's requirements.