Stuck in iteration

Describe the issue/error/question

I would like to iterate through pages of this api.

What is the error message (if any)?

I´m stuck at page 1 with the iterator node, even though manually I´m able to call page 2 etc

Please share the workflow

Share the output returned by the last node

Information on your n8n setup

  • **n8n version:latest Desktop 199
  • **Database you’re using (default: SQLite):Sqlite
  • Running n8n with the execution process [own(default), main]:
  • Running n8n via [npm, desktop app]:

Hi @Kool_Baudrillard, the Iterator node isn’t a default n8n node but a community node built by @BramKn. Perhaps he can help with this?

1 Like

Hi @Kool_Baudrillard

It can be a bit annoying to set the node correctly, sorry for that.
Can you please post the config of your iterator node? I cannot see it here and when I copy the node it doesn’t seem right vs what you say you are trying to do.

@MutedJam thanks for the headsup

Hi,

this is the setup of the node:

{
“meta”: {
“instanceId”: “64dda5562bd7e58f894c2bb89ee15d008ed95b9ec3f22bf3c5f3c7983878f35d”
},
“nodes”: [
{
“parameters”: {
“incrementStart”: 1,
“options”: {
“expectedItemCount”: 1000
}
},
“id”: “e24eb19c-73fc-4566-bbbe-5be7b58a7850”,
“name”: “Iterator”,
“type”: “n8n-nodes-iterator.iterator”,
“typeVersion”: 1,
“position”: [
220,
180
]
}
],
“connections”: {}
}

yeah thats what I saw. Can you give a screenshot?

1 Like

Hi this is how it basically looks



Hi @Kool_Baudrillard

Ok so this is an easy one.
Your pages are set to a size 10.
And you set the incrementor to expect 10k records.
So it thinks the looping is done because 10 < 10k :wink:

yes, but after the second iteration it stops, even if I set it too 100 = 100.



Thats because the iterator only receives 1 item. You need to split the items to show the iterator how many you received.
Or simply place the MYSQL after the iterator. As I see you are doing a HTTP and insert. This is causing the issue with the items.

can also set it to expect 1 item, but that would give ya an infinite loop.

If the API in that HTTP can return some kind of flag that shows you if there is items left you can use that as well. but you’ll need to check if that is an option.

3 Likes

:smiley: it works! Thx, more a brain bug than a software bug :smiley:

2 Likes