Forum Discussion

trevorgermain's avatar
trevorgermain
Advocate I
8 years ago
Solved

Too many requests in Web.Contents. Can I share a request?

Hi,   I am querying a web api using Web.Contents in a loop to get paged data. The Api has a throttled request limit of 300 requests per 10 minutes.     { "results": { "timesheets": {...
Need Help
  • trevorgermain's avatar
    trevorgermain
    8 years ago

    I ended up writing a web api as an intermediary that caches responses in a Redis cache. It seems to work really well for this scenario.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello trevorgermain,

 

I am struggling with the same, but my API endpoint throws back a 500 response for some reason, and that kills my refresh. Could you share the code as well? Is this solution working with scheduled refresh in the Service?

 

Br, 

Szabolcs

trevorgermain's avatar
trevorgermain
Advocate I
8 years ago

As it turns out, this didn't work in the service at all. I don't think the service supports Web Api very well. It works in Desktop, though. I've actually pulled this out of Power BI and moved it to Excel with Power Query / Pivot Tables to get the desired result. Frankly, I didn't want the customer to have to use Power BI desktop. It's a SharePoint hosted solution that would have been really slick with the Power BI web part, but it won't work with the Web Api.

 

As for your 500 error, try running Fiddler while making the request, you might be able to see more information about what the actual error is. If it seems to be a legitimate error on the Api, you may have to contact your Api provider for support.