Good Afternoon all, I am wanting to use the Wonde API to extract data from sims into excel. the one bit that seems to be stumping me is Pagination and how to pull for example all pupil records at once or is this not possible. i have managed to pull the page 1 through with this = Json.Document(Web.Contents("https://api.wonde.com/v1.0/schools/A12345678910/students?include=registration,year,contact_details,extended_details&per_page=200&page=1")) but is there a way in the syntax that will do all pages or is there a way of indexing how many pages and parsing through?
any thoughts would be appreciated.