Forum Discussion
Paginated Report API - Not a lot to work with! :-)
Super UserWhen you call it the first time does it tell you the total number of records? If it does then you can do the pagination more easily.
- first call, get number of records
- generate a list with the required number of pages
- generate the URL for each page and fetch the page content into a table column
- expand the table column which will automatically union all results.
Hey - no it doesn't - it basically gives you the link to the first and link to the next - the api instructions say that when the next page is null the next link will be blank.
O. Previous projects like you said it's always told you how many records to iterate through - it's just very badly drawn out I think this api
- lbendlin
Yes, that is unfortunate. it forces you to use list.accumulate or even a recursive function where you have to lug the received data around with each loop. Or you could harvest only the URLs and hope that your browser cache helps when you then call them again to collect the data.
Yes - Can you help me with the code i have written to do it the best way? I have proper hit a brick wall now 😞
- lbendlin
unfortunately helping in these scenarios is very difficult without access to the API.
Practice using List.Accumulate. Read about recursive functions. Try stuff out.