Forum Discussion
Configure Web Api Connection Several Request
- 6 years ago
Hello Holguinmora
saw that you opened this topic twice...
as you passed me your credentials, I was able to develop something for your. I've tested it and it should work. Here the code
let Final = List.Generate ( ()=> [ Result= Json.Document(Web.Contents("https://api.repsly.com/v3/export/clients/0", [Headers=[Accept="application/json"]])), TotalCount = 1 ], each [TotalCount]>0, each [ Result= Json.Document(Web.Contents("https://api.repsly.com/v3/export/clients/" & Text.From([Result][MetaCollectionResult][LastTimeStamp]), [Headers=[Accept="application/json"]])) , TotalCount = [Result][MetaCollectionResult][TotalCount] ], each [Result][Clients] ), FinalTable = Table.FromRecords(List.Combine(Final)) in FinalTableCopy paste this code to the advanced editor to see how the solution works
Give it a test and let us know
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy
Hi Holguinmore,
I am not clear about your requirement, did you mean "a loop for fetching paginated data from a REST API"? If so, you could try to refer to this post and How To Do Pagination In Power Query for details.
By the way, I am not professional in API, you also could ask ImkeF for more suggestions.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Zoe hi
I just sent @ImkeF a private mail, hope to get news from him
Do you j¡know if Microsof has some kind of service that I can pay and get help with this things? I contact many partners in Colombia, I got so many different answers and prices that is very hard to know if all this guys know a solution...