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