Forum Discussion

LP2803's avatar
LP2803
Responsive Resident
5 years ago

How to fetch data page by page from API

Hi Team,   Im very new to power query and API and unable to figure a way out from this fetching data from API which returns 10 rows per call.   Below is how my code looks like which i got it from...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi LP2803 

In the image you provided the URL shows query parameters like $count and $top  but query parameters should be preceded by an & so the url should look like 

 

?meetingType=meeting&from=2019-01-22T04:00:00Z&to=2020-12-31T04:00:00Z&count=true&top=0

 

In the code you provied you also have another query parameter $skip but this should be &skip.

Wherever you are using $ in your query parameters change it to & 

Regards

Phil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

  • LP2803's avatar
    LP2803
    Responsive Resident
    5 years ago

    Hi Philip,

     

    Thanks a lot for lending me a helping hand.

     

    I did change $ to & and now i have the below error. Kindly help what this error is and how to resolve it.

     

    • LP2803's avatar
      LP2803
      Responsive Resident
      5 years ago

      PhilipTreacy  Kindly help. Im really in need of help here.

      • mahoneypat's avatar
        mahoneypat
        Microsoft Employee
        5 years ago

        I looked at their documentation.  Note that you can return 100 records per call instead of the default 10.  Use &max=100 in your url.  Also, i don't see mention of "top", so you may need to use "max" in place of that in your web calls.  Also, why are you using top/max in your count call?

         

        Regards,

        Pat