Hi,
I'm trying to pull a data from an API using power query. My request is successful, but problem is that there is a limit on the number of objects to be returned per request (50 rows). So every time I refresh my data I get the latest 50 rows and all the previous data is deleted. How can I modify my request in PwQ to aggregate the data (latest information added to previously loaded)?
let
url = "https://api.samplewebpage.com/api/v1/transactions?offset=1&limit=50",
Source = Json.Document(Web.Contents(url,[Headers = [#"X-Api-Token"="sdfkjslkjvsivjsoifvjdfvdfljsl"] ] ))
in
Source
