Hi,
I’ve build a small example and attached it.
First of all, the commas after “idBoard”:"…" have to be removed so that it’s valid. Next we take a JSON to Table Node and create a table. The settings of this node are important in this case:
Under Arrays we select ‘Expand to columns (max generate many)’. Next under ‘Children Expansion’ we set ‘Only up to level 1’.
These settings allows you to split up your original JSON column into three JSON columns (for each row one). Afterwards the Transpose Node is used to transpose these columns into rows. Then again, the JSON to Table Node is used with its default settings and the end result is your needed table.
Cheers,
Moritz
JSON_EXAMPLE.knwf (5.5 KB)