I have to say, this has been a challenging process over the last couple of weeks, and I have lurked behind the scenes consuming everything I can from historical posts. At this point I am on the edge of moving on from this solution, so I figured I would put my issue out to the community to see if the masses could help solve this.
Premise:
- HTTP Block: Obtain a Token
- HTTP Block (Inside Do-Until): Utilize single Token and download multiple REST API pages
- Append Pages: Gather pages and compose an array or string
- Massage & Push: Utilize various blocks outside the main HTTP block clean up the data and push the final output to Power BI
Workflow:
- Process Final Output:
- Consume the string from the "Append to string" block
- Process string and convert to an array or select block, etc.
- KEY PROBLEM:
- Unfortunately, the Append String doesn't append the pages (3 for this example)
- If I click through the pages in the "Do Until" block, the Append String changes with each click
- Any feedback on how to accumulate the paginated data in the Append block would be much appreciated!
Thanks in advance for any help you may be able to provide!
