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.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.
The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…
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.