Forum Discussion
Backfill Row Values to 0
Hi all, I'm pulling some data out of an API that retrieves data in 100 row pages. Using this technique I've been able to loop through all the pages and retrieve all the data in a single table, wh...
If you drill down on your shown step to get the totalpages value, you can just use = {0..totalpages-1} to make that list, convert it to a table, make it a text column and concatenate it into your API call.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
If you drill down on your shown step to get the totalpages value, you can just use = {0..totalpages-1} to make that list, convert it to a table, make it a text column and concatenate it into your API call.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Perfect, exactly what I was after. Many thanks!