Forum Discussion

jpt1228's avatar
jpt1228
Responsive Resident
5 years ago

Scheduling dynamic anonymous API Refresh in Power BI service

Hello, I have an API call which I can refresh in the desktop fine. When I publish to the service I am unable to schedule refresh due to error:  I have been successful using http://blog.datains...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi jpt1228 ,

 

Try this:

pageRange = {0..Number.RoundUp(totalItems / 250)-1}
pages = List.Transform(pageRange, each ufnCallAPI(_*250+1)),

You can take a look at the following document about the help functions about processing pagination api if it meet your requirement:

Helper functions for M extensions for Power Query connectors | Microsoft Docs

Solved: Power Query M function in Paginate API - Microsoft Power BI Community

Solved: Paginate Rest API via Offset and Limit method - Microsoft Power BI Community

Iterate over dynamic Web API Pages with Power Query - How to resolve Cursor-Based Pagination - DataChant

Revisiting Dynamic Web.Contents()

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • jpt1228's avatar
    jpt1228
    Responsive Resident
    5 years ago

    Hello Anonymous Thanks for your reply. If I put all this together in one query is this the correct query string?

     

    (Page as text) =>

    let
    Source = Json.Document(Web.Contents("https://harvest.greenhouse.io/v1/jobs?", [Headers=[AUTHORIZATION="Basic xxxxxxxxxxxxxxxxxxxxxx="]])),

    pageRange = {0..Number.RoundUp(totalItems / 250)-1}
    pages = List.Transform(pageRange, each Page(_*250+1)),

     

    • jpt1228's avatar
      jpt1228
      Responsive Resident
      5 years ago

      Hello Anonymous I wanted to follow up on your response. Where do I put your suggested modifications? Does it replace the "Query="? If you could help with the complete API call it would be much appreciated.

       

      Thanks