Exhibit JSON format in JSON data source

I am trying to make use of a json published here:
https://www.eea.europa.eu/data-and-maps/daviz/sds/transport-energy-consumption-eea-5/download.exhibit

I can connect and fetch the data like:
url: https://www.eea.europa.eu/data-and-maps/daviz/sds/transport-energy-consumption-eea-5/download.exhibit
fields:

However, when i try to set the fields parameter, nothing in selected.
I.e. url: https://www.eea.europa.eu/data-and-maps/daviz/sds/transport-energy-consumption-eea-5/download.exhibit
fields: [annotation_line]

Can you help me out?
I have compiled redash from master, running into docker.

Best!
M

Do you only need the objects in the items array? If so, you can use the path parameter:

url: https://www.eea.europa.eu/data-and-maps/daviz/sds/transport-energy-consumption-eea-5/download.exhibit
path: items

Results (with many columns cropped out):

You’d use fields if you wanted to filter which fields from the object you want included in the results, e.g.:

url: https://www.eea.europa.eu/data-and-maps/daviz/sds/transport-energy-consumption-eea-5/download.exhibit
path: items
fields: [date, total, rail_diesel_gas_oil]

Results:

More info:
https://redash.io/help/data-sources/setup/json

1 Like

brilliant, thanks! :smile:

1 Like