Problems decoding single node json from web request for looping

[Menno]

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

[n8n]

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:

[aditya_gaur]

@Menno

{
“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
}

@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.

[Menno]

Hi,

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

[aditya_gaur]

@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.

[Menno]

Thanks for the help. That solved my problem.