Append .csv files from API

[Anonymous]

Hi all, 

I am looking into appending a daily-updated set of .csv files from an API provided by one of our suppliers. These .csv files our named by the date they are reporting data for in the below highlighted format. Is it possible to automatically get these files and append them at the same time without any extra effort for linking separate files daily?

Zdroj = Csv.Document(Web.Contents("https://website/api/v2/export/power-bi/date/" & "2020-05-23" & ".csv"

Thanks,

Vit

[camargos88 · Accepted solution]

Hi @Anonymous ,

If you have a table with dates,  you can add a column and call this function inside it, like:

Csv.Document(Web.Contents("https://website/api/v2/export/power-bi/date/" & " Date.ToText([COLUMN], "yyyy-MM-dd") " & ".csv".

After that, just expand them and handle the headers, if necessary.

Also, you can create a function and call it inside the new custom column.