OECD.Stat SDMX web service
This service gives access to OECD.Stat data and tries to be fully SDMX 2.0 compliant. However, the following additional rules are applied:
(1) The OECD provides currently only annual, semi-annual, quarterly, monthly and non-time-series data. The time formats to be used for all time periods are as follow: 'yyyy', 'yyyy-mm' or 'yyyy-mm-dd' with y=year digits, m=month digits and d=day digits, e.g. '2005-09-01'.
Independently on the presence of a FREQUENCY dimension, the requested time frequency should be specified using the TIME_FORMAT attribute as in this example:
<And>
<Attribute name="TIME_FORMAT">P1M</Attribute>
<Time>
<StartTime>1960-01</StartTime>
<EndTime>2005-10</EndTime>
</Time>
</And>
The TIME_FORMAT attribute should have the following value: 'P1Y' for annual, 'P6M' for semi-annual, 'P3M' for quarterly and 'P1M' for monthly data. This attribute is then also present in the resulting generic data message at the Series level of time-series data.
For non-time-series data, the TIME_PERIOD attribute and the 'Time' node should be omitted in the query message. In this case, the response messages use '9999' for the obligatory time periods.
(2) In the OECD data warehouse OECD.Stat each dataset (multidimensional cube) has its own Data Structure Definition.
(3) For simplification reasons in this web service, the returned message headers only contain required information. As the 'message:ID' field is not (yet) used, its content is filled with a placeholder to conform to the standard.
(4) The maximum size of the resulting generic data message is 5 MB. The message is truncated if necessary. Please split your requests if this limit is exceeded.
Want to test it? Have a look at our SDMX web service interface
The following operations are supported. For a formal definition, please review the Service Description.
-
GetDataStructureDefinition
Use this method to retrieve the Data Structure Definitions (as well as Code lists and Concepts) from an .Stat dataset.
Note: As the requested input parameter is an xml document, you can not try the method using this webservice presentation page.
Input: SDMX QueryMessage (in SDMX-ML format)
Output: SDMX StructureMessage (in SDMX-ML format)
When authenticated access is needed, then previously do the following steps:
Step n° 1: Get the current .Stat public encryption key:
../OECDStatWS_Authentication/OECDStatWS_Authentication.asmx?op=GetPublicKey
Step n° 2: RSA-encrypt your password using the public encryption key and authenticate yourself:
../OECDStatWS_Authentication/OECDStatWS_Authentication.asmx?op=Authenticate
The 'Authenticate' method returns a session ID. Provide this session ID, your user name and the domain as URL options 'sessionid', 'login' and 'domain' to the GetDataStructureDefinition method.
Note: You can reuse the same session ID for several SDMX requests within a certain timeout. The authentication procedure might be modified in the future.
-
GetGenericData
Use this method to retrieve data in Generic format from an .Stat dataset.
Note: As the requested input parameter is an xml document, you can not try the method using this webservice presentation page.
Input: SDMX QueryMessage (in SDMX-ML format)
Output: SDMX GenericDataMessage (in SDMX-ML format)
When authenticated access is needed, then previously do the following steps:
Step n° 1: Get the current .Stat public encryption key:
../OECDStatWS_Authentication/OECDStatWS_Authentication.asmx?op=GetPublicKey
Step n° 2: RSA-encrypt your password using the public encryption key and authenticate yourself:
../OECDStatWS_Authentication/OECDStatWS_Authentication.asmx?op=Authenticate
The 'Authenticate' method returns a session ID. Provide this session ID, your user name and the domain as URL options 'sessionid', 'login' and 'domain' to the GetGenericData method.
Note: You can reuse the same session ID for several SDMX requests within a certain timeout. The authentication procedure might be modified in the future.