Dynamic URL Change with Date

[Alex87]

Hi together,

I want to automate the query for the API URL from Coingecko. I have a Column in Excel where i want to load in the Date and on the Output must be the Price. It works for one Column but not for the complete row. How can I do this dynamic for several Dates in a row?

let

Year = Number.ToText(Date.Year(Date.From(Excel.CurrentWorkbook(){[Name="history_date_Abfrage_Kurstag"]}[Content]{0}[Datum]))),
  Month = Number.ToText(Date.Month(Date.From(Excel.CurrentWorkbook(){[Name="history_date_Abfrage_Kurstag"]}[Content]{0}[Datum]))),
Day = Number.ToText(Date.Day(Date.From(Excel.CurrentWorkbook(){[Name="history_date_Abfrage_Kurstag"]}[Content]{0}[Datum]))),
D=Text.Combine({Day, Month, Year}, "-"),
    Quelle = Json.Document(Web.Contents("https://api.coingecko.com/api/v3/coins/litecoin/history?date="&D)),
    market_data = Quelle[market_data],
    current_price = market_data[current_price],
    #"In Tabelle konvertiert" = Record.ToTable(current_price),
    #"Gefilterte Zeilen" = Table.SelectRows(#"In Tabelle konvertiert", each ([Name] = "eur"))
in
    #"Gefilterte Zeilen"

Thank you so much!