Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic Parameter of column value

Hi,

 

I would like to update the source files of my report directly via web source. 

= Csv.Document(Web.Contents("https://www.covid19.admin.ch/api/data/20210426-73ottdu4/sources/COVID19Cases_geoRegion.csv"),[Delimiter=",", Columns=50, Encoding=1252, QuoteStyle=QuoteStyle.None])

 

Therefore I have addes a web source. One part of the url will change daily (see red marked). Thats why it must be dynamically.

Is it possible to get the value of the field dataVersion into parameter? So this part of the url will change dynamically?

 
Thanks a lot