Implement paging in API

[kafreitass]

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

[v-yiruan-msft · Accepted solution]

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

[kafreitass]

@v-yiruan-msft this works perfectly. 

Thank you so much

[amitchandak]

@kafreitass , Refer if this can help

https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78

[kafreitass]

hi @amitchandak 

I tried to implement using the tutorial but I couldn't