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.
Prerequisites:
- Stambia DI Designer S18.3.1 or higher
- Stambia DI Runtime S17.4.1 or higher
Metadata Configuration
The first step is to open the JSON Metadata to add the fields that will next be used in the Mappings to sort data.
For this simply add as many 'sortKey' Property Fields as required under the node that you want to sort.
The sort keys are applied in the order they are defined in the Metadata.
Mapping Configuration
The Metadata being configured, you can now simply map these fields in the Mapping to sort your data.
Ascending / descending order
By default, the keys specified are sorting data in the ascending order
This behavior can be changed by adding one of the following tags on the sort key.
- SORT_ASC
- SORT_DESC
