OECD Web Service




  • The OECD Authentication service


Add here some known implementation details

  • The OECD data we are interested in

    • Dataset : SSIS_BSC - Structural Statistics of Industry and Services - Business by Size Class
    • Dimensionsare (example of a query is given in Table 2 below)
      • COU - Country
      • VAR - Variable: the following variables are relevant for the UNIDO database.

        • ENTR - Number of enterprises
        • ESTB - Number of establishments
        • WASE - Wages & Salaries of employees
        • EMPE - Number of employees
        • EMPN - Total employment (number engaged)
        • EMPF - Number of female employees
        • VAFC - Value added at factor costs
        • VALU - Value added
        • PROD - Production
        • GITG - Gross investment

NOTE 1:
- ENTR and ESTB are alternatives - some countries report number of enterprises and others number of establishments.
- EPME and EMPN are alternatives - some countries report number of employees and others number of persons engaged.
- VAFC and VALU are alternatives - some countries report Value added at factor costs and others Value added.

Compare with UNIDO consolidated and unconsolidated tables.

NOTE 2:
The demo mode of the web service (when not logged in) provide only ENTR and ESTB (number of establishments)
      • ISIC3 - all ISICs at 2-, 3- and 4-digit level. The limited access rights provide only ISIC 3 at 2-digit level.

Example: ISIC Query (selective)
        <Or>
            <Dimension id="ISIC3">15_37</Dimension>
            <Dimension id="ISIC3">15</Dimension>
            <Dimension id="ISIC3">16</Dimension>
        </Or>
 
      • SRC - Source: BSC - Business by Size Class
      • SCL - Size class: TOTAL - Total
    • Time - Annual - all available years (see Table 1 for list of countries and coverage).
Example: Time query
         <Attribute id="TIME_FORMAT">P1Y</Attribute>
         <Time>
              <StartTime>1990</StartTime>
              <EndTime>2006</EndTime>
         </Time>
 
Example 1: SDMX Query for Generic Data

Example 2: Working example for the old OECD Web Service. The query in this example will retrieve all variables (we are interested in) and ISICs 15 to 16 at 2-, 3- and 4-digit level (if you are logged in and have the necessary rights). I do not know how one can authenticate with the new OECD web service, so this example is for the old one.

Example 3: Complete SDMX Message: SDMX Query for Generic Data. This query will retrieve the complete data set SSIS_BSC for Country=Austria (all available years,all variables, als ISIC codes). The result will be a file with size about 1.8MB.

Example 4: Complete SDMX Message: SDMX Query for Generic Data. This query is similar to the previous one but uses wild card for the variables (there is no list of variables). The result will be a file with size about 14MB.

Example 5: Complete SDMX Message: SDMX Query for Generic Data. This query is similar to the previous ones but it lists all the ISIC codes. The result will be a file with size about 1.1MB.

  • Retrieve data (replaced/deleted) after a certain date

The following examples show how to retrieve incrementaly data. There are two commands: DataAction=Replace or DataAction=Delete, which specify what data to be retrieved.

To retrieve data which was REPLACED after a certain dat, add the following to lines in the Header of the message:
    <message:Header>
        ...
        <message:DataSetAction>Replace</message:DataSetAction>
        <message:ReportingBegin>2009-03-01T00:00:00</message:ReportingBegin>
        ...
    </message:Header>
 

To retrieve data which was DELETED after a certain dat, add the following to lines in the Header of the message:
    <message:Header>
        ...
        <message:DataSetAction>Delete</message:DataSetAction>
        <message:ReportingBegin>2009-03-01T00:00:00</message:ReportingBegin>
        ...
    </message:Header>
 


Example 6: Complete SDMX Message: SDMX Query for Generic Data - REPLACED with ReportingBegin date. This query will retrieve all data (as specified in the WHERE clause) which were updated=Replaced after a given date. The result will be a file with size about 14MB if the date is before 1.3.2009 (the complete set for Austria was updated around this time). The result will be empty if the date is later. [this test was performed 12.06.2009]

Example 7: Complete SDMX Message: SDMX Query for Generic Data - DELETED with ReportingBegin date. This query will retrieve all data (as specified in the WHERE clause) which were updated=DELETED after a given date. The result will be a file with size about 2MB if the date is say 1.1.2005 (only the data set for Turkey was deleted (and not replaced) up to now). The result will be empty set with later date. [this test was performed 12.06.2009]



  • Additional Issues


  1. Using wild cards in SDMX query, i.e. retrieve all ISICs instead of enumerating all of them. This is possible only with the new Web Services.
Example
  1. Quering for MetadataStructureDefinition: not yet funcional.
  2. Quering for Metadata: seems that it is not yet funcional too - I could not retrieve anything, but may be we have to leave the metadata aside for the time being.