Power Query Pagination - Stripe REST API

[Brite]

Hello, my goal is to get all data from the dataset that is being called from Stripe. I am currently only getting 100 (maximum number of datasets pulled from Stripe). Stripe rest API URL parameter uses starting_after=[id number]. Is there a power query loop or return code that can replace the [id number] in the API URL parameter for every 100th id? My goal is to get all data from the dataset.   

Note: Stripe uses bearer token

This is what I have at the moment:

This is the table that id is located in:

base URL: https://api.stripe.com/v1/charges?limit=100&starting_after=ch_1234567910

Tried this pagination power query code from GitHub but did not work.

https://gist.github.com/MarkTiedemann/f667c75cc3d054b9b2bce25ea08bc631

Any help is very appreciated :)!

[mahoneypat · Accepted solution]

Please see this video for how to do this.

Power BI - Tales From The Front - REST APIs - YouTube

Pat