API Append rather than replace

[Anonymous]

SO WHAT:
Does Power Query have a way to append data called through a web API rather than replacing it with every call?

Background:

I'm using a web API to get data from a 3rd party server on a scheduled frequency. The API configuration, unfortunately, only allows me to call 30 days of historical data on a rolling basis. This is problematic because I often need more than 30 days of historical data for specific analyses. I'm hoping Power Queary has a way of getting the data from the web API and adding to the existing data rather than replacing it with each call.

I would greatly appreciate it if someone could give me some guidance on this, please?

Thanks!

[v-yanjiang-msft]

Hi @Anonymous ,

You can use the Web.Contents function to call the API, please refer to this documnet for the detailed steps:

Call a Web Service for each Row in Power Query | Power Query How-To | Nellis Consulting, LLC 

Hope it helps!

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.