Parsing Json with dynamic Keys

[armingrudd]

Hi @sudheerkopparapu,

First of all, the JSON file you have provided has an extra comma at line 189.

There was a similar topic like this, where some manipulation on an XML was needed to transform keys (element names) to values:

Creating column names with XPATH Node

Here I have an alternative solution which is a bit tricky: First, use a String Manipulation node to modify your XML file to make the element names be values. E.g.: If this is the XML: <?xml version='1.0' encoding='UTF-8'?> <root> <item> <id>0001</id> <idBoard>0001</idBoard> </item> <item> <id>0001</id> <idBoard>0001</idBoard> </item> <item> <id>0001</id> <idBoard>0001</idBoard> </item> </root> Use this expression: rege…

So I followed the same idea to manipulate the JSON using the String Manipulation node and this expression:

regexReplace(regexReplace($json$, "\"(\\d[^\"]+)\"", "\"item\":\"$1\",\n\"item2\""), "([-\\d.]+)", "$1")

And then by using 3 JSON Path nodes, I extracted each level separately passing the sub-level as json to the next JSON Path node.
Here is the workflow:
22342-1-1.knwf (45.3 KB)