Differences to consider
Transitioning from Eurostat Bulk Download to API introduces some structural and data changes in the TSV and SDMX file formats.
They are presented in detail in the following documents:
For TSV: Migrating_to_API_TSV.pdf
For SDMX: Migrating_to_API_SDMX.pdf
Two more files are available to help in the transition:
Where_to_find_information_in_new_applications.pdf provides information about the move of data from Legacy to RENOV API.
Migrating_to_API_data_constraints.pdf explains how to get similar information as the metabase.txt file.
Change of URL for data download
Bulk download URLs could be either
- https://ec.europa.eu/eurostat/estat-navtree-portlet-prod/BulkDownloadListing?sort=1&file=data%2Fbop_eu6_m.tsv.gz
- https://ec.europa.eu/eurostat/estat-navtree-portlet-prod/BulkDownloadListing?sort=1&downfile=data%2Fbop_eu6_m.tsv.gz
In API SDMX 2.1, it is simplified to
Example of a REST request to download the full TSV data file of the "BOP_EU6_M" dataset
Submit in a web client (for example, a browser) a valid HTTP call with the name of the dataset and the relevant format:
https://ec.europa.eu/eurostat/api/dissemination/sdmx/2.1/data/BOP_EU6_M?format=TSV&compressed=true
The API returns the dataset data file: BOP_EU6_M.tsv.gz
Manual data download using Data Browser
New interface is documented in the following page : How to perform mass download operations
Example: How to download a TSV file?
Go to the Data Browser: https://ec.europa.eu/eurostat/databrowser/bulk?lang=en:
Navigate to the relevant dataset by code, e.g. "European Union and euro area balance of payments - monthly data (BPM6) (BOP_EU6_M)".
Enter the code in the filter input
Select the download format “TSV” from the Download Operations drop-down
click on Apply to start the process