I am trying to create a nested JSON file from a database file. I’ve created this JSON file but two things are missing:
- Object is not showing, only the key;
- Datapoint key is not showing only the value “coord_lat”
Can somenone help me with this
Can someone help me with this?
Hi @havi1970 -
Would it be possible for you to post an example workflow? It would help to see the configuration options you’re using. Maybe then we can narrow down the problem.
This is my latest attempt to create the nested JSON. What I want is:
InputJson.xlsx (5.8 KB)
JSON2(2).knwf (12.0 KB)
you were almost there:
- Instead of the Group Loop Start node you can directly start putting your values in JSON structure.
- Group by ObjectID, ObjectConnector and DatapointID
The rest works fine. This way you’ll get a nicely nested JSON. For clarification I attached the modified workflow for you.
MartenJSON2(2).knwf (27.8 KB)
Thanks, this is what i am looking for!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.