Forum Discussion
Implement paging in API
Hey guys!
hope everyone is well!
I'm trying to create a paginated API code below is ok, but it doesn't return all the records of the pages. How could I implement pagination in code?
I've already checked in other posts with solutions, but I couldn't implement it in my code.
Can anybody help me?
let
body =
Json.FromValue
([
call = "ListadeClientes",
appkey = appkey,
appsecret = appsecret,
param = {[
pagina = 1
registros_por_pagina = 100,
apenas_importado_api = "N"
]}
]),
header =
[
#"Content-Type" = "application/json"
],
request = Json.Document(
Web.Contents(
"https://app.fakedata.com/",
[
RelativePath = "api/v1/v2/v3/",
Headers = header,
Content = body
]
)
,
1252
)
in
request
- Anonymous3 years ago
Hi kafreitass ,
Please review the following links which has the same requirements, hope they can help you achieve it.
How to get paginated data from API in Power BI
Handling Paginated REST API Results with Power Query
How to do Pagination on a REST API in Power Query
Best Regards
4 Replies
- amitchandakSuper User
kafreitass , Refer if this can help
https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78
- kafreitassHelper I
hi amitchandak
I tried to implement using the tutorial but I couldn't
- AnonymousNot applicable
Hi kafreitass ,
Please review the following links which has the same requirements, hope they can help you achieve it.
How to get paginated data from API in Power BI
Handling Paginated REST API Results with Power Query
How to do Pagination on a REST API in Power Query
Best Regards
- kafreitassHelper I
Anonymous this works perfectly.
Thank you so much