JSON to Table

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

Any idea ?

Thanks,
Stefan

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"
  },
...
]

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

The following should do the trick:

{
  "nodes": [
    {
      "parameters": {
        "functionCode": "return [\n  {\n    json: {\n      \"search-result\": {\n        entry: [\n          {\n            key: ['a'],\n            index: ['0']\n          },\n          {\n            key: ['b'],\n            index: ['1']\n          }\n        ]\n      }\n    }\n  }\n];"
      },
      "name": "Mock Data",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        450,
        300
      ]
    },
    {
      "parameters": {
        "functionCode": "return items[0].json['search-result']['entry'].map( entry => {\n    const returnItem = {};\n    for (const keyName of Object.keys(entry)) {\n      returnItem[keyName] = entry[keyName][0];\n    }\n  \n    return {\n      json: returnItem\n    };\n});"
      },
      "name": "Convert-Function",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        650,
        300
      ]
    }
  ],
  "connections": {
    "Mock Data": {
      "main": [
        [
          {
            "node": "Convert-Function",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Have fun!

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

Sorry do not understand what you mean.