Using Cursor Paginiation - Help required

Anonymous — Fri, 20 Dec 2019 10:35:02 GMT

I have an API data source that returns 1 record and it uses cursor pagination. But I am new to Power BI and can't figure out how to do a response call to look up the next record and so on if more.

Can someone assist, have tried multiple options but none seem to work

Re: Using Cursor Paginiation - Help required

Anonymous — Thu, 02 Jan 2020 09:10:45 GMT

HI @Anonymous ,

I think query paginated should suitable for your requirements. You can check at the following document or write a custom function with an iterator to merge each result and invoke web API with next cursor key:

Power query Handling Paging

Sample:

let GetListByCurrsor=(rootpath as text,apikey as text, size as number,optional _currsor as text, optional resultList as list) as list=> let Source=if _currsor<>null then Json.Document(Web.Contents(rootpath&"&"&_currsor,[Header=[#"XXX-Api-Key"=apikey]])) else Json.Document(Web.Contents(rootpath,[Header=[#"XXX-Api-Key"=apikey]])), Result=if resultList<> null then if List.Count(resultList)<size then @GetListByCurrsor(rootpath,apikey,size,Source[currsor], List.Combine({resultList,Source[events]})) else resultList else @GetListByCurrsor(rootpath,apikey,size,Source[currsor],Source[events]) in Result in GetListByCurrsor

Comment: rootpath is API URL, apikey is the header optional parameter, size is the max size of the result, _cursor is cursor key, resultList is the list store and merge result.

Regards,

Xiaoxin Sheng

topic Using Cursor Paginiation - Help required in Developer

Using Cursor Paginiation - Help required

Re: Using Cursor Paginiation - Help required