Hello,
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
1 Like
Can someone help me with this?
ScottF
November 2, 2018, 2:44pm
3
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.
1 Like
Hello Scott,
This is my latest attempt to create the nested JSON. What I want is:
object
datapoint
value
value
value
datapoint
value
object
etc.
InputJson.xlsx (5.8 KB)
JSON2(2).knwf (12.0 KB)
Hi @havi1970
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.
Cheers,
MartenJSON2(2).knwf (27.8 KB)
3 Likes
Hi Marten,
Thanks, this is what i am looking for!
Cheers,
Peter
system
Closed
November 10, 2018, 8:36am
7
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.