Is there a way to automate my data refresh ? Help please...

[cccarv82]

Hi! I have my data gathered from an API where i needed to create two functions to be able to get all the data that ai need.

I have an function to get the data from the API and then in this results i have a field with a string to get the next page of results. So i have another function to perform the request using the "next_page" value and get the next page of results. In the end i sumarize everything into a list and then i have a table with all results sumarized.

My function where i use the "next_field" value to perform the next page requests receive an parameter with this value.

function to generate the list:

= List.Generate(
	() => [offset = 0, listQtd = getItemNextPage("/api/v3/search/stories?query=created%3A2022-01-01..*+is%3Astory&page_size=25")],
	each [offset] <= 727/25,
	each [offset = [offset] + 1, listQtd = getItemNextPage([listQtd][next])]

)

function getItemNextPage where i use the "next_page" value

= (page as text) =>
let
    Fonte = Json.Document(Web.Contents("https://api.something.com"&page, [Headers=[#"Content-Type"="application/json", #"Some-Token"="123-456"]]))

in
    Fonte

Ok... so now i have my table populated with all the results that i need but i`m unable to schedule the update of that table...

I get this:

So is there a way to schedule this update ???

[v-chenwuz-msft]

Hi @cccarv82 ,

I don't think it's possible to do that. Maybe you can try python script to do that. And only personal gateway support python script refresh.

Best Regards

Community Support Team _ chenwu zhu