BBoliviaDB
ENES
← Back to documentation

Excel

Refreshable data without copy and paste.

Use Power Query to consume JSON or download CSV from each series page.

Power Query M
let
    Source = Json.Document(
        Web.Contents(
            "https://boliviadb.com/api/series/reserves/observations"
        )
    ),
    Data = Source[data],
    Table = Table.FromRecords(Data),
    Typed = Table.TransformColumnTypes(
        Table,
        {{"period", type date}, {"value", type number}}
    )
in
    Typed
1

Data → Get Data → From Other Sources → Blank Query

2

Open Advanced Editor and paste the code.

3

Load the table and configure refresh frequency.