Forum Discussion

kafreitass's avatar
kafreitass
Helper I
3 years ago
Solved

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

4 Replies