From table to nested JSON file

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

Knipsel

1 Like

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.

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:

  1. Instead of the Group Loop Start node you can directly start putting your values in JSON structure.
  2. 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

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.