Forum Discussion

jpt1228's avatar
jpt1228
Icon for Responsive Resident rankResponsive 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
jpt1228's avatar
jpt1228
Icon for Responsive Resident rankResponsive 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
Icon for Responsive Resident rankResponsive 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