An error occured. Details Hide
You have unsaved pages. Restore Cancel

Simple get dataset endpoint

This endpoint returns dataset's data in pivot table format.

Input

DatasetId is unique identifier for dataset, dimensionId - unique identifier for dataset dimension and key1,key2,key3 - array of dimension members.
Time is the optional parameter, if it's missing, the result will contain the rows between 2000 year till current date.

NameType Description
DatasetId String Unique identifier for dataset.
DimensionId String Unique Identifier for dimension.

Result

The output of this endpoint is array of tuples. For each header/stub dimension there will be corresponding tuple field and also value field. Stub fields will be included in the order of their definition in request followed by header fields in the order of their definition in request. Tuples will follow the value order defined in request, i.e. tuples for values listed first will be followed by tuples for values listed later.

Name Type Description
Dataset string Unique dataset id
Header object Dimension details and members of header
Contains array of
  • Dimension: Dimension id
  • Members: Distinct sorted values of dimension members
Stub Object Dimension details and members of stub
Contains array of
  • Dimension: Dimension id
  • Members: Distinct sorted values of dimension members
Filter Object Dimension details of members which are used as a filter. This can
contain only one member.
Data object Tuples describing each data point.
consists
  • Time: Date of observation
  • Value : contains the significand/mantissa of observation value.
    Should be multiplied with scale for observation data.
  • Unit: Unit associated with value
  • Scale: Value's multiplication factor.

Example

GET http://knoema.com/api/1.0/data/AEF2011OCT?Source=1000000&Country=1000000,1000010,1000020,1000030&Indicator=1000010
&Measure=1000000
  
{
    "Dataset": "AEF2011OCT",
    "DatasetName": "Accuracy of Economic Forecasts, October 2011",
    "Header": [
        {
            "DimensionId": "Time",
            "Members": [
                "2003",
                "2004",
                "2005",
                "2006",
                "2007",
                "2008",
                "2009",
                "2010",
                "2011",
                "2012"
        ]}
    ],
    "Stub": [
        {
            "DimensionId": "Source",
            "Members": [
                "IMF World Economic Outlook"
                ]
        },
        {
            "DimensionId": "Country",
            "Members": [
                "Afghanistan",
                "Albania",
                "Algeria",
                "Angola"]
        },
        {
            "DimensionId": "Indicator",
            "Members": [
                "Gross domestic product, constant prices (Percent change)"]
        },
        {
            "DimensionId": "Measure",
            "Members": [
            "Latest figures"]
        }],
    "Filter": [],
    "Data": [
        {
            "Time": "/Date(1041379200000)/",
            "Measure": "Latest figures",
            "Indicator": "Gross domestic product, constant prices (Percent change)",
            "Country": "Afghanistan",
            "Source": "IMF World Economic Outlook",
            "Value": 8.445,
            "Unit": "Percent change",
            "Scale": 1,
            "Frequency": "A"
        },
        {
            "Time": "/Date(1072915200000)/",
            "Measure": "Latest figures",
            "Indicator": "Gross domestic product, constant prices (Percent change)",
            "Country": "Afghanistan",
            "Source": "IMF World Economic Outlook",
            "Value": 1.055,
            "Unit": "Percent change",
            "Scale": 1,
            "Frequency": "A"
        },
        ...
        {
            "Time": "/Date(1325376000000)/",
            "Measure": "Latest figures",
            "Indicator": "Gross domestic product, constant prices (Percent change)",
            "Country": "Angola",
            "Source": "IMF World Economic Outlook",
            "Value": 10.815,
            "Unit": "Percent change",
            "Scale": 1,
            "Frequency": "A"
        }],
    "Regions": null
}