Tech Labs | 14 Jun 2022

API Databank – Key Response Dictionaries

Technology Team

Oxford Economics

Note that for the purpose of describing these dictionaries, the ( and ) characters indicate a choice and should be omitted in practice. For example, format: (“csv”, “excel”) indicates a choice between the strings csv and excel, so in practice this might look like format: “csv” or format: “excel”.

In contrast, the [ and ] characters indicate an array and must not be omitted.

Download

[ 
 {
  DatabankCode: string,
  ProducTypeCode: string,
  LocationCode: string,
  VariableCode: string,
  MeasureCode: see measure codes,
  AnnualData:
  {
    YYYY: float,
    YYYY: float,
    YYYY: float,
    …
  },
  QuarterlyData:
  {
    YYYYQQ: float,
    YYYYQQ: float,
    YYYYQQ: float,
    …
  }
 }
]

Selection

This is the same as the selection dictionary in the request body. However, the response version always includes fields that are otherwise optional in the request. These include: LastUpdate, ContactId, ShareCodeId, and IsDataFeed.

User

{
  ContactId: string,
  CompanyId: string,
  UserName: string,
  ApiKey: string,
  Email: string,
  Title: string,
  LastName: string,
  FirstName: string,
  CompanyName: string,
  IsTrialist: string,
  IsLockedOut: string,
  Roles: [string],
  SavedSelections:
  [ {
   Id: string,
   Name: string,
   Url: string
  } ]
 }

Measure codes

Several of these request and response objects have a MeasureCode field. This value describes how the annual data is represented. The available options are:

Related Services

Post

From opportunity to impact – Assessing the economic, societal, and cultural benefits of YouTube in Finland

This study assesses YouTube's contribution to GDP and employment in Finland, and its broader impact on society and culture.

Find Out More

Post

Mahdollisuuksista vaikuttavuuteen – Arviointi YouTuben taloudellisista, yhteiskunnallisista ja kulttuurisista hyödyistä Suomessa

Tässä tutkimuksessa arvioidaan YouTuben vaikutusta Suomen bruttokansantuotteeseen ja työllisyyteen sekä sen laajempaa vaikutusta yhteiskuntaan ja kulttuuriin.

Find Out More

Post

Economic Impacts of The Umbrella Academy Season Two in Ontario

In 2019, production of Season Two of “The Umbrella Academy” resulted in total spending in Ontario of over C$77.3 million.

Find Out More