Forum Discussion

Asalk's avatar
Asalk
Frequent Visitor
4 years ago

How do I convert dynamic source with paginated REST API that uses offset to a static source?

I found an article that helped me paginate the REST API, however i'm not sure how to use Web.Content() to make the source static while using offset.  This is the code i'm using :   let ...
Need Help
Asalk's avatar
Asalk
Frequent Visitor
4 years ago

Hey amitchandak ,

I checked the two articles you mentioned, unfortunately I have already checked these before. My main problem is with offset

    GetPage = (Index) =>
        let 
			offset  = "&offset=" & Text.From(Index * EntitiesPerPage), 
            Url   = Web.Contents(Url,[RelativePath="/resources/11.13.18.05/workers",Query =[limit="500",totalResults="true",offset=Number.From(Index * EntitiesPerPage)]]),
            Json  = GetJson(Url),
            Value = Json[#"items"]
        in  
			Value,



i'm trying to wrap my head around it. this is my first time using REST API as we just have moved to Oracle Cloud, and it seems this is the only way to connect Power BI to SaaS.

Thanks.