sdmx-dl
GitHub Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage

Usage

By default, all commands print the result on the standard output.
Most commands produce RFC4180 compliant CSV content.

Command arguments are composed of options and positional parameters. Options have a name, positional parameters are usually the values that follow the options, but they may be mixed. The general pattern is:

sdmx-dl fetch data ECB EXR M.CHF.EUR.SP00.A -o chf.csv
         command         parameters          options

All commands share the following options:

Commands summary

The commands follow a verb+noun hierarchy.

%%{init:{'themeVariables': {'textColor': '#fdf6e3', 'fontSize': '12px'},'flowchart':{'nodeSpacing': 5, 'rankSpacing': 30}}}%%
flowchart TB
    r{{sdmx-dl}}
    r --- f([fetch]) --- data & meta & keys
    r --- l([list]) --- sources & flows & dimensions & attributes & codes & availability & features & drivers
    r --- c([check]) --- status & access & config
    r --- s([setup]) --- completion & launcher

    classDef default fill:#93a1a1,stroke-width:0px 
    linkStyle default stroke:#93a1a1
 
    classDef fx fill:#dc322f
    class f,data,meta,keys fx;
    click f "#fetch" "fetch command"
    click data "#fetch-data" "fetch data command"
    click meta "#fetch-meta" "fetch meta command"
    click keys "#fetch-keys" "fetch keys command"
   
    classDef lx fill:#859900
    class l,sources,flows,dimensions,attributes,codes,availability,features,drivers lx;
    click l "#list" "list command"
    click sources "#list-sources" "list sources command"
    click flows "#list-flows" "list flows command"
    click dimensions "#list-dimensions" "list dimensions command"
    click attributes "#list-attributes" "list attributes command"
    click codes "#list-codes" "list codes command"
    click availability "#list-availability" "list availability command"
    click features "#list-features" "list features command"
    click drivers "#list-drivers" "list drivers command"
   
    classDef cx fill:#268bd2
    class c,status,access,config cx;
    click c "#check" "check command"
    click status "#check-status" "check status command"
    click access "#check-access" "check access command"
    click config "#check-config" "check config command"
    
    classDef sx fill:#b58900
    class s,completion,launcher sx;
    click s "#setup" "setup command"
    click completion "#setup-completion" "setup completion command"
    click launcher "#setup-launcher" "setup launcher command"

Download time series.

Subcommands: data, meta, keys

Examples

List resources and structural metadata.

Subcommands: sources, flows, dimensions, attributes, codes, availability, features, drivers

Examples

Check resources and services.

Subcommands: status, access, config

Setup sdmx-dl.

Subcommands: completion, launcher

Commands details

Download time series observations.

Example: sdmx-dl fetch data ECB EXR M.USD+CHF.EUR.SP00.A

Parameters:

  • source - Data source name.
  • flow - Data flow reference.
  • key - Data key.

Main options:

Other options: CSV, Network

Output format: [ Series:key, ObsAttributes:map, ObsPeriod:datetime, ObsValue:number ]

Series ObsAttributes ObsPeriod ObsValue
M.CHF.EUR.SP00.A OBS_STATUS=A 1999-01-01T00:00:00 1.605495
M.CHF.EUR.SP00.A OBS_STATUS=A 1999-02-01T00:00:00 1.59785
M.CHF.EUR.SP00.A OBS_STATUS=A 1999-03-01T00:00:00 1.595430434782609
M.CHF.EUR.SP00.A OBS_STATUS=A 1999-04-01T00:00:00 1.601531818181818

Download time series metadata.

Example: sdmx-dl fetch meta ECB EXR M.USD+CHF.EUR.SP00.A

Parameters:

  • source - Data source name.
  • flow - Data flow reference.
  • key - Data key.

Main options:

Other options: CSV, Network

Output format: [ Series:key, Concept:string, Value:string ]

Series Concept Value
M.CHF.EUR.SP00.A COLLECTION A
M.CHF.EUR.SP00.A UNIT CHF
M.CHF.EUR.SP00.A DECIMALS 4
M.CHF.EUR.SP00.A SOURCE_AGENCY 4F0
M.CHF.EUR.SP00.A UNIT_MULT 0
M.CHF.EUR.SP00.A TITLE Swiss franc/Euro

Download time series keys.

Example: sdmx-dl fetch keys ECB EXR .USD+CHF.EUR.SP00.A

Parameters:

  • source - Data source name.
  • flow - Data flow reference.
  • key - Data key.

Main options:

Other options: CSV, Network

Output format: [ Series:key ]

Series
A.CHF.EUR.SP00.A
D.CHF.EUR.SP00.A
H.CHF.EUR.SP00.A
M.CHF.EUR.SP00.A

List data source names and properties.

Example: sdmx-dl list sources

Main options:

Other options: CSV

Output format: [ Name:source, Description:string, Aliases:list, Driver:string, Dialect:string, Endpoint:uri, Properties:map, Website:url, Monitor:uri, MonitorWebsite:url, Languages:list ]

Name Description Aliases Driver Dialect Endpoint Properties Website Monitor MonitorWebsite Languages
ABS Australian Bureau of Statistics ri:abs https://stat.data.abs.gov.au/restsdmx/sdmx.ashx https://stat.data.abs.gov.au upptime:/nbbrd/sdmx-upptime/ABS https://nbbrd.github.io/sdmx-upptime/history/abs en
ECB European Central Bank ri:sdmx21 ECB2020 https://sdw-wsrest.ecb.europa.eu/service detailSupported=true https://sdw.ecb.europa.eu upptime:/nbbrd/sdmx-upptime/ECB https://nbbrd.github.io/sdmx-upptime/history/ecb en
ESTAT Eurostat EUROSTAT connectors:eurostat https://ec.europa.eu/eurostat/SDMX/diss-web/rest https://ec.europa.eu/eurostat/data/database upptime:/nbbrd/sdmx-upptime/ESTAT https://nbbrd.github.io/sdmx-upptime/history/estat en,de,fr

List data flows.

Example: sdmx-dl list flows ECB

Parameters:

Main options:

Other options: CSV, Network

Output format: [ Ref:flow, Label:string ]

Ref Label
ECB:AME(1.0) AMECO
ECB:BKN(1.0) Banknotes statistics
ECB:BLS(1.0) Bank Lending Survey Statistics

List data flow dimensions.

Example: sdmx-dl list dimensions ECB EXR

Parameters:

  • source - Data source name.
  • flow - Data flow reference.

Main options:

Other options: CSV, Network

Output format: [ Name:string, Label:string, Coded:bool, Index:int ]

Name Label Coded Index
FREQ Frequency true 0
CURRENCY Currency true 1
CURRENCY_DENOM Currency denominator true 2
EXR_TYPE Exchange rate type true 3
EXR_SUFFIX Series variation - EXR context true 4

List data flow attributes.

Example: sdmx-dl list attributes ECB EXR

Parameters:

  • source - Data source name.
  • flow - Data flow reference.

Main options:

Other options: CSV, Network

Output format: [ Name:string, Label:string, Coded:bool, Relationship:enum ]

Concept Label Coded Relationship
TIME_FORMAT Time format code false SERIES
OBS_STATUS Observation status true OBSERVATION
DECIMALS Decimals true GROUP

List codes from data flow concept.

Example: sdmx-dl list codes ECB EXR FREQ

Parameters:

Main options:

Other options: CSV, Network

Output format: [ Code:string, Label:string ]

Code Label
A Annual
Q Quarterly
B Daily - businessweek

List available dimension codes.

Example: sdmx-dl list availability ECB EXR M.CHF... 4

Parameters:

  • source - Data source name.
  • flow - Data flow reference.
  • key - Data key.
  • index - Zero-based index of key dimension.

Main options:

Other options: CSV, Network

Output format: [ Code:string ]

Code
A
E

List supported features of a data source.

Example: sdmx-dl list features ECB

Parameters:

Main options:

Other options: CSV, Network

Output format: [ SupportedFeature:enum ]

SupportedFeature
SERIES_KEYS_ONLY

List driver names and properties.

Example: sdmx-dl list drivers

Main options:

Other options: CSV

Output format: [ SupportedFeature:enum ]

Name SupportedProperties
ri:dotstat connectTimeout,readTimeout,maxRedirects,preemptiveAuthentication
ri:nbb connectTimeout,readTimeout,maxRedirects,preemptiveAuthentication
ri:sdmx21 connectTimeout,readTimeout,maxRedirects,preemptiveAuthentication,detailSupported,trailingSlashRequired

Check service availability.

Example: sdmx-dl check status ECB

Parameters:

Main options:

Other options: CSV, Network

Output format: [ Source:source, State:enum, UptimeRatio:double, AverageResponseTime:double, ErrorMessage:string ]

Source State UptimeRatio AverageResponseTime ErrorMessage
ECB UP 99.691

Check service accessibility.

Example: sdmx-dl check access ECB

Parameters:

Main options:

Other options: CSV, Network

Output format: [ Source:source, Accessible:enum, DurationInMillis:int, ErrorMessage:string ]

Source Accessible DurationInMillis ErrorMessage
ECB YES 726

Check sdmx-dl configuration.

Example: sdmx-dl check config

Other options: CSV

Output format: [ Scope:enum, PropertyKey:string, PropertyValue:string, Category:enum ]

Scope PropertyKey PropertyValue Category
SYSTEM sources C:\temp\some-sources.xml WIDE_OPTION
SYSTEM org.fusesource.jansi.Ansi.disable true OTHER
GLOBAL sources C:\Users\ABC\other-sources.xml WIDE_OPTION
LOCAL sdmx-dl.check.status.verbose true NARROW_OPTION