shlogg · Early preview
Judy @esproc_spl

Converting Multilevel JSON To 2D CSV With EsProc

Converting multilevel JSON to 2D CSV: use esProc script p1.dfx to split & promote identities fields, export as json.csv. See SPL source & integration guide.

Problem description & analysis
Below is data in JSON file json.json:
To convert the multilevel JSON file into a two-dimensional structure while splitting the two subfields under identities field and promoting them to the parent level, and store data as a CSV file as follows:

Solution:
We write the following script p1.dfx in esProc:

Code description:
A1   Read data of the JSON file as a string.
A2  Parse the string into a multilevel table sequence according to the original structure while splitting and promoting identities.signInType and identities.issuerAssignedId to their parent level with...