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
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...
Hi Holguinmora,
I am sorry , I am not professional in this part, I suggest you also could open a ticket for this problem(https://powerbi.microsoft.com/en-us/support/), which is not for free.
Thanks for your understanding and support.
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.