JSON to Table

Questions
1

Hi, i have here an output as json, but i like to have these entries 31753713ā€¦ (Example) like a table to make further requests.

grafik
grafik305Ɨ537 3.97 KB

Any idea ?

Thanks,
Stefan

2

Sorry do not really understand. There is just JSON in n8n not really any table. The table view just displays the first level of the JSON as a table.

So I guess what you mean is that you want to transfer the data to something like this?

[
  {
    "key": "31753713",
    "index: "0"
  },
  {
    "key": "3209482",
    "index: "1"
  },
...
]
3

I would make a http request with each of the entry.

4

The following should do the trick:

Have fun!

5

Jan, it works but i must set in the data node
Explicit Array !

6

Sorry do not understand what you mean.

7

is there a way we can dump this exact view as a html table for example without having to go outside of the platform.

Would be cool to take that exact view and simply use it for posting in the next node to a webpage etc.

8

is there a way we can dump this exact view as a html table for example without having to go outside of the platform.

The spreadsheet file node can create a HTML table based on this data.

1 Like
9

ooh ok cool will have a look thanks

10

it works as expected so thats good.

do you know how to make it make a table for each row in a table?
think Iā€™m going to have to function node this one :wink:

11

Yeah, if you want a single HTML file with multiple tables (instead of one table with multiple rows) I think the Function node would be the way to go.

12

no im looking for each row on a table, to be a one row table in separate files

13

In this case you could try using Split in Batches with a batch size of 1 before your Spreadsheet file node.

1 Like
14

ah clever, yeah that would make sense, not sure why i didnt think of that an automatically went the hard route, lol