I am trying to create a flow that is basically will do a page scrape of a website.
For example:
I can do a single page without issues using the following:
It goes simply to the web page via HTTP Request (Directory) and then change the last number to get different page
Trying to do it in a loop.
So far I did the setup using for sure SplitInBatch + Excel sheet for the numbering
It does the loop, however it outputs only the same page, not sure what is missing to get the counter of the page working in the loop of the HTTP Request.
I tried the {{json["id"]}} instead, still didn’t work.
I tried without the SplitInBatches, and it kept looping!
What I noticed that the SplitInBatches is working fine, and the counter is working as you can see from the left side in the screenshot, result 3 shows Id 3 and so on.
Hey ansred,
glad to hear it worked. When you are in the expression editor both methods, clicking incoming data on the left menu or typing expressions manually, should work. I can’t really tell why it did not work for you.
Now that you aren’t using SplitInBatches anymore I think you can remove your loop. The Http Request node should go through all incoming Google Sheets items.