Forum Discussion
Connecting Eurostat Json File
Dear all,
I want to get the daily exchange rates from the eurostat website. Unfortunatly they changed the web adress...
Before I used this code:
let
#"Entfernte obere Zeilen" = Table.Skip(#"Höher gestufte Header", 6),
#"Transponierte Tabelle" = Table.Transpose(#"Entfernte obere Zeilen"),
#"Entfernte obere Zeilen 1" = Table.Skip(#"Transponierte Tabelle", 1),
#"Umbenannte Spalten" = Table.RenameColumns(#"Entfernte obere Zeilen 1", {{"Column1", "Date"}}),
#"Höher gestufte Header 1" = Table.PromoteHeaders(#"Ersetzter Wert", [PromoteAllScalars = true]),
#"Entfernte obere Zeilen 2" = Table.Skip(#"Höher gestufte Header 1", 1),
....
The new link to get the new json file from the query builder is this one:
Is there anyone who is able to include the json file in the first steps?