Export Sets | JSON Format | Is there an ability to split records onto their own line?

George Cutrell
Tera Expert

When a JSON format export set is created, the entire contents of the export is on a single line.  For large exports, especially at table that has a lot of fields, the single line will be quite large and causes issues with downstream processes trying to consume the export file.  If each record were on its own line, there would not be an issue.

 

Currently, an export file looks like the following.

{"records":[{"id": 1},{"id": 2},{"id": 3},.....{"id": 4000000}]}

 

Is there any way to get each record onto its own line like the following?

{"records":[
{"id": 1},
{"id": 2},
{"id": 3},
...
{"id": 4000000}
]}

5 REPLIES 5

then this json should be manually by using a code editor or programatically should be pretty printed to a new file