Problems decoding single node json from web request for looping

Questions
1

I have created a web request and getting back a non conventional json.
N8N comes back with only 1 node called data
I need to loop through the items part in that json.
to eventually create a task in clickup where i need company name in the task description.
I tried multiple options but not able to achieve that.
Can you help?

{
“links”: [
{
“rel”: “self”,
“href”: “https://*******”
}
],
“count”: 2,
“hasMore”: false,
“items”: [
{
“links”: ,
“companyname”: “Anonymous Customer”,
“datecreated”: “10/06/2024”,
“id”: “4”
},
{
“links”: ,
“companyname”: “TEST”,
“datecreated”: “03/09/2024”,
“id”: “113”
}
],
“offset”: 0,
“totalResults”: 2
}

Information on your n8n setup

  • **n8n version: 1.65.2
  • **Running n8n via: cloud
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

@Menno
You can use ‘split out’ node and pass ‘Items’ to it. This would give you desired output and then you can loop around those items.

4

Hi,

Thanks for the response. Have tried this, but is not working.

image
image1686×355 48.3 KB

5

@Menno ,

You need parse it first since api response is in string.

Use code node after your https node as below example shows that it first parse the string.

6

Thanks for the help. That solved my problem.