Forum Discussion

Yash48's avatar
Yash48
Frequent Visitor
4 years ago
Solved

How to solve a schedule refresh problem for getting data from API?

Hi guys, I am using the below power query code for getting the data from an API. I am using a loop to get the data for many rows as the API can provide onpy 5000 rows for a call. But I am not able to...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    Sorry I hadn't read your post correctly.  What you need is a base URL that actually exists on the service.

     

    https://api.genscape.com/ is not valid (the server refuses to serve that page). 

     

    Select "skip test"  and ignore the error.

lbendlin's avatar
lbendlin
Super User
4 years ago

"But I am not able to apply data refresh"

 

Please elaborate. What error message did you get?

  • Yash48's avatar
    Yash48
    Frequent Visitor
    4 years ago

    Hi lbendlin,

     

    I am getting the below error message.

     

     

    Thank you,

    Yash

     

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      Sorry I hadn't read your post correctly.  What you need is a base URL that actually exists on the service.

       

      https://api.genscape.com/ is not valid (the server refuses to serve that page). 

       

      Select "skip test"  and ignore the error.

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      Can you successfully fetch a single page? The first ten records? The error message indicates that the URL is incorrect.

      • Yash48's avatar
        Yash48
        Frequent Visitor
        4 years ago

        Yes, I can fetch a single page when I use the below way to load data instead of using query to load many pages using loop.