Forum Discussion
How to append data point to a table upon every API query refresh?
Hello, I am using a Query to extract data from a web API. What I end up with is a table of my data that refreshes every minute. However, I need to keep a time-history of the data. Every time the ...
Do that first time and return the table into sheet, let say query name (thus table as well) is GetData. After that modify it - query itself, i.e. GetData table and append to data returned from web. That shall be done within ONE query, now as couple of separate ones. Script will be like
let
Source = Web.Content(), // if other steps append below the final one
// query resulting table
GetData = Excel.CurrentWorkbook(){[Name="GetData"]}[Content],
AppendNextPortion = Table.Combine({GetData, Source})
in
AppendNextPortion