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

How to retrieve data

Knoema platform supports data retrieval in Compact SDMX format (SDMX 2.0) and Structure Specific Data format (SDMX 2.1). To retrieve data from specific dataset HTTP GET request should be made to http://dptest.ncsi.gov.om/api/1.0/sdmx/{sdmxVersion}/get endpoint. This endpoint supports the following parameters:

Parameter Description Status
id Id of dataset Mandatory
{dimension}={key1,key2}

This query string is constructed from the list of dimension and it's members included in request for the dataset. For every dimension there should be its members included into request listed and separated by "," characted. Frequency is represented by "freq" parameter. 

Optional

 

SDMX 2.1 - Response will contain data in StructureSpecificData SDMX format encapsulate into Structure message

GET http://dptest.ncsi.gov.om/api/1.0/sdmx/2.1/get?id=OECDEO90&Location=1000020%2C1000030%2C1000040&Variable=1000050&freq=A
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
<?xml version="1.0" encoding="utf-8"?>
    <Header>
        <ID>none</ID>
        <Test>false</Test>
        <Prepared>2017-04-25T11:16:54</Prepared>
        <Sender id="Knoema" />
        <Receiver id="unknown" />
        <Structure structureID="Knoema_OECDEO90_1_0" dimensionAtObservation="TIME_PERIOD" namespace="urn:sdmx:org.sdmx.infomodel.datastructure.DataStructure=Knoema:OECDEO90(1.0):ObsLevelDim:TIME_PERIOD">
            <common:Structure xmlns:common="http://www.sdmx.org/resources/sdmxml/schemas/v2_1/common">
                <Ref agencyID="Knoema" id="OECDEO90" version="1.0" />
            </common:Structure>
        </Structure>
    </Header>
    <DataSet>
        <Series LOCATION="BEL" VARIABLE="CTGSVD" FREQ="A">
            <Obs TIME_PERIOD="1970" OBS_VALUE="0.28783" />
            <Obs TIME_PERIOD="1971" OBS_VALUE="0.14184" />
            <Obs TIME_PERIOD="1972" OBS_VALUE="0.35378" />
            <Obs TIME_PERIOD="1973" OBS_VALUE="0.5707" />
            <Obs TIME_PERIOD="1974" OBS_VALUE="0.14865" />
            <Obs TIME_PERIOD="1975" OBS_VALUE="-0.31527" />
            <Obs TIME_PERIOD="1976" OBS_VALUE="0.44015" />
            <Obs TIME_PERIOD="1977" OBS_VALUE="0.12328" />
            <Obs TIME_PERIOD="1978" OBS_VALUE="0.08743" />
            <Obs TIME_PERIOD="1979" OBS_VALUE="0.27399" />
            <Obs TIME_PERIOD="1980" OBS_VALUE="-0.0365" />
            <Obs TIME_PERIOD="1981" OBS_VALUE="0.02261" />
            <Obs TIME_PERIOD="1982" OBS_VALUE="0.06696" />
            <Obs TIME_PERIOD="1983" OBS_VALUE="0.02429" />
            <Obs TIME_PERIOD="1984" OBS_VALUE="0.21219" />
            <Obs TIME_PERIOD="1985" OBS_VALUE="0.01179" />
            <Obs TIME_PERIOD="1986" OBS_VALUE="0.11205" />
            <Obs TIME_PERIOD="1987" OBS_VALUE="0.17979" />
            <Obs TIME_PERIOD="1988" OBS_VALUE="0.30929" />
            <Obs TIME_PERIOD="1989" OBS_VALUE="0.27933" />
            <Obs TIME_PERIOD="1990" OBS_VALUE="0.14903" />
            <Obs TIME_PERIOD="1991" OBS_VALUE="0.09201" />
            <Obs TIME_PERIOD="1992" OBS_VALUE="0.11922" />
            <Obs TIME_PERIOD="1993" OBS_VALUE="-0.01214" />
            <Obs TIME_PERIOD="1994" OBS_VALUE="0.22798" />
            <Obs TIME_PERIOD="1995" OBS_VALUE="0.13974" />
            <Obs TIME_PERIOD="1996" OBS_VALUE="0.10351" />
            <Obs TIME_PERIOD="1997" OBS_VALUE="0.25841" />
            <Obs TIME_PERIOD="1998" OBS_VALUE="0.13749" />
            <Obs TIME_PERIOD="1999" OBS_VALUE="0.09726" />
            <Obs TIME_PERIOD="2000" OBS_VALUE="0.3199" />
            <Obs TIME_PERIOD="2001" OBS_VALUE="0.00962" />
            <Obs TIME_PERIOD="2002" OBS_VALUE="0.04276" />
            <Obs TIME_PERIOD="2003" OBS_VALUE="0.01261" />
            <Obs TIME_PERIOD="2004" OBS_VALUE="0.14882" />
            <Obs TIME_PERIOD="2005" OBS_VALUE="0.10871" />
            <Obs TIME_PERIOD="2006" OBS_VALUE="0.11852" />
            <Obs TIME_PERIOD="2007" OBS_VALUE="0.11279" />
            <Obs TIME_PERIOD="2008" OBS_VALUE="0.04929" />
            <Obs TIME_PERIOD="2009" OBS_VALUE="-0.23007" />
            <Obs TIME_PERIOD="2010" OBS_VALUE="0.19584" />
            <Obs TIME_PERIOD="2011" OBS_VALUE="0.12879" />
            <Obs TIME_PERIOD="2012" OBS_VALUE="0.06358" />
            <Obs TIME_PERIOD="2013" OBS_VALUE="0.11158" />
        </Series>
        <Series LOCATION="CAN" VARIABLE="CTGSVD" FREQ="A">
            <Obs TIME_PERIOD="1970" OBS_VALUE="0.18026" />
            <Obs TIME_PERIOD="1971" OBS_VALUE="0.21875" />
            <Obs TIME_PERIOD="1972" OBS_VALUE="0.44316" />
            <Obs TIME_PERIOD="1973" OBS_VALUE="0.49219" />
            <Obs TIME_PERIOD="1974" OBS_VALUE="0.09352" />
            <Obs TIME_PERIOD="1975" OBS_VALUE="-0.22834" />
            <Obs TIME_PERIOD="1976" OBS_VALUE="0.27856" />
            <Obs TIME_PERIOD="1977" OBS_VALUE="0.11247" />
            <Obs TIME_PERIOD="1978" OBS_VALUE="0.24845" />
            <Obs TIME_PERIOD="1979" OBS_VALUE="0.20095" />
            <Obs TIME_PERIOD="1980" OBS_VALUE="-0.03921" />
            <Obs TIME_PERIOD="1981" OBS_VALUE="0.07771" />
            <Obs TIME_PERIOD="1982" OBS_VALUE="-0.30356" />
            <Obs TIME_PERIOD="1983" OBS_VALUE="0.25457" />
            <Obs TIME_PERIOD="1984" OBS_VALUE="0.62539" />
            <Obs TIME_PERIOD="1985" OBS_VALUE="0.24016" />
            <Obs TIME_PERIOD="1986" OBS_VALUE="0.21601" />
            <Obs TIME_PERIOD="1987" OBS_VALUE="0.158" />
            <Obs TIME_PERIOD="1988" OBS_VALUE="0.42561" />
            <Obs TIME_PERIOD="1989" OBS_VALUE="0.13027" />
            <Obs TIME_PERIOD="1990" OBS_VALUE="0.1282" />
            <Obs TIME_PERIOD="1991" OBS_VALUE="0.07811" />
            <Obs TIME_PERIOD="1992" OBS_VALUE="0.21452" />
            <Obs TIME_PERIOD="1993" OBS_VALUE="0.33196" />
            <Obs TIME_PERIOD="1994" OBS_VALUE="0.40342" />
            <Obs TIME_PERIOD="1995" OBS_VALUE="0.2818" />
            <Obs TIME_PERIOD="1996" OBS_VALUE="0.20502" />
            <Obs TIME_PERIOD="1997" OBS_VALUE="0.41197" />
            <Obs TIME_PERIOD="1998" OBS_VALUE="0.27477" />
            <Obs TIME_PERIOD="1999" OBS_VALUE="0.36305" />
            <Obs TIME_PERIOD="2000" OBS_VALUE="0.34309" />
            <Obs TIME_PERIOD="2001" OBS_VALUE="-0.15183" />
            <Obs TIME_PERIOD="2002" OBS_VALUE="0.05248" />
            <Obs TIME_PERIOD="2003" OBS_VALUE="0.01974" />
            <Obs TIME_PERIOD="2004" OBS_VALUE="0.21926" />
            <Obs TIME_PERIOD="2005" OBS_VALUE="0.14284" />
            <Obs TIME_PERIOD="2006" OBS_VALUE="0.08444" />
            <Obs TIME_PERIOD="2007" OBS_VALUE="0.10456" />
            <Obs TIME_PERIOD="2008" OBS_VALUE="-0.04708" />
            <Obs TIME_PERIOD="2009" OBS_VALUE="-0.37212" />
            <Obs TIME_PERIOD="2010" OBS_VALUE="0.26111" />
            <Obs TIME_PERIOD="2011" OBS_VALUE="0.15814" />
            <Obs TIME_PERIOD="2012" OBS_VALUE="0.13338" />
            <Obs TIME_PERIOD="2013" OBS_VALUE="0.16281" />
        </Series>
        <Series LOCATION="CHL" VARIABLE="CTGSVD" FREQ="A">
            <Obs TIME_PERIOD="1996" OBS_VALUE="0.03758" />
            <Obs TIME_PERIOD="1997" OBS_VALUE="0.04004" />
            <Obs TIME_PERIOD="1998" OBS_VALUE="0.01987" />
            <Obs TIME_PERIOD="1999" OBS_VALUE="0.00016" />
            <Obs TIME_PERIOD="2000" OBS_VALUE="0.02272" />
            <Obs TIME_PERIOD="2001" OBS_VALUE="0.01839" />
            <Obs TIME_PERIOD="2002" OBS_VALUE="0.00603" />
            <Obs TIME_PERIOD="2003" OBS_VALUE="0.02473" />
            <Obs TIME_PERIOD="2004" OBS_VALUE="0.05" />
            <Obs TIME_PERIOD="2005" OBS_VALUE="0.0327" />
            <Obs TIME_PERIOD="2006" OBS_VALUE="0.02591" />
            <Obs TIME_PERIOD="2007" OBS_VALUE="0.03622" />
            <Obs TIME_PERIOD="2008" OBS_VALUE="0.02642" />
            <Obs TIME_PERIOD="2009" OBS_VALUE="-0.0377" />
            <Obs TIME_PERIOD="2010" OBS_VALUE="0.05381" />
            <Obs TIME_PERIOD="2011" OBS_VALUE="0.04272" />
            <Obs TIME_PERIOD="2012" OBS_VALUE="0.0282" />
            <Obs TIME_PERIOD="2013" OBS_VALUE="0.02826" />
        </Series>
    </DataSet>
</StructureSpecificData>

 

SDMX 2.0 - Response will contain data in Compact SDMX format encapsulated into Structure message.

GET http://dptest.ncsi.gov.om/api/1.0/sdmx/2.0/get?id=OECDEO90&Location=1000020%2C1000030%2C1000040&Variable=1000050&freq=A 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
<?xml version="1.0" encoding="utf-8"?>
    <Header>
        <ID>none</ID>
        <Test>false</Test>
        <Truncated>false</Truncated>
        <Prepared>2017-04-25T11:25:05</Prepared>
        <Sender id="Knoema">
            <Name xml:lang="en">Knoema</Name>
        </Sender>
    </Header>
        <Series LOCATION="BEL" VARIABLE="CTGSVD" UNIT_MEASURE="8" UNIT_MULT="0" FREQ="A" TIME_FORMAT="P1Y">
            <Obs TIME_PERIOD="1970" OBS_VALUE="0.28783" />
            <Obs TIME_PERIOD="1971" OBS_VALUE="0.14184" />
            <Obs TIME_PERIOD="1972" OBS_VALUE="0.35378" />
            <Obs TIME_PERIOD="1973" OBS_VALUE="0.5707" />
            <Obs TIME_PERIOD="1974" OBS_VALUE="0.14865" />
            <Obs TIME_PERIOD="1975" OBS_VALUE="-0.31527" />
            <Obs TIME_PERIOD="1976" OBS_VALUE="0.44015" />
            <Obs TIME_PERIOD="1977" OBS_VALUE="0.12328" />
            <Obs TIME_PERIOD="1978" OBS_VALUE="0.08743" />
            <Obs TIME_PERIOD="1979" OBS_VALUE="0.27399" />
            <Obs TIME_PERIOD="1980" OBS_VALUE="-0.0365" />
            <Obs TIME_PERIOD="1981" OBS_VALUE="0.02261" />
            <Obs TIME_PERIOD="1982" OBS_VALUE="0.06696" />
            <Obs TIME_PERIOD="1983" OBS_VALUE="0.02429" />
            <Obs TIME_PERIOD="1984" OBS_VALUE="0.21219" />
            <Obs TIME_PERIOD="1985" OBS_VALUE="0.01179" />
            <Obs TIME_PERIOD="1986" OBS_VALUE="0.11205" />
            <Obs TIME_PERIOD="1987" OBS_VALUE="0.17979" />
            <Obs TIME_PERIOD="1988" OBS_VALUE="0.30929" />
            <Obs TIME_PERIOD="1989" OBS_VALUE="0.27933" />
            <Obs TIME_PERIOD="1990" OBS_VALUE="0.14903" />
            <Obs TIME_PERIOD="1991" OBS_VALUE="0.09201" />
            <Obs TIME_PERIOD="1992" OBS_VALUE="0.11922" />
            <Obs TIME_PERIOD="1993" OBS_VALUE="-0.01214" />
            <Obs TIME_PERIOD="1994" OBS_VALUE="0.22798" />
            <Obs TIME_PERIOD="1995" OBS_VALUE="0.13974" />
            <Obs TIME_PERIOD="1996" OBS_VALUE="0.10351" />
            <Obs TIME_PERIOD="1997" OBS_VALUE="0.25841" />
            <Obs TIME_PERIOD="1998" OBS_VALUE="0.13749" />
            <Obs TIME_PERIOD="1999" OBS_VALUE="0.09726" />
            <Obs TIME_PERIOD="2000" OBS_VALUE="0.3199" />
            <Obs TIME_PERIOD="2001" OBS_VALUE="0.00962" />
            <Obs TIME_PERIOD="2002" OBS_VALUE="0.04276" />
            <Obs TIME_PERIOD="2003" OBS_VALUE="0.01261" />
            <Obs TIME_PERIOD="2004" OBS_VALUE="0.14882" />
            <Obs TIME_PERIOD="2005" OBS_VALUE="0.10871" />
            <Obs TIME_PERIOD="2006" OBS_VALUE="0.11852" />
            <Obs TIME_PERIOD="2007" OBS_VALUE="0.11279" />
            <Obs TIME_PERIOD="2008" OBS_VALUE="0.04929" />
            <Obs TIME_PERIOD="2009" OBS_VALUE="-0.23007" />
            <Obs TIME_PERIOD="2010" OBS_VALUE="0.19584" />
            <Obs TIME_PERIOD="2011" OBS_VALUE="0.12879" />
            <Obs TIME_PERIOD="2012" OBS_VALUE="0.06358" />
            <Obs TIME_PERIOD="2013" OBS_VALUE="0.11158" />
        </Series>
        <Series LOCATION="CAN" VARIABLE="CTGSVD" UNIT_MEASURE="8" UNIT_MULT="0" FREQ="A" TIME_FORMAT="P1Y">
            <Obs TIME_PERIOD="1970" OBS_VALUE="0.18026" />
            <Obs TIME_PERIOD="1971" OBS_VALUE="0.21875" />
            <Obs TIME_PERIOD="1972" OBS_VALUE="0.44316" />
            <Obs TIME_PERIOD="1973" OBS_VALUE="0.49219" />
            <Obs TIME_PERIOD="1974" OBS_VALUE="0.09352" />
            <Obs TIME_PERIOD="1975" OBS_VALUE="-0.22834" />
            <Obs TIME_PERIOD="1976" OBS_VALUE="0.27856" />
            <Obs TIME_PERIOD="1977" OBS_VALUE="0.11247" />
            <Obs TIME_PERIOD="1978" OBS_VALUE="0.24845" />
            <Obs TIME_PERIOD="1979" OBS_VALUE="0.20095" />
            <Obs TIME_PERIOD="1980" OBS_VALUE="-0.03921" />
            <Obs TIME_PERIOD="1981" OBS_VALUE="0.07771" />
            <Obs TIME_PERIOD="1982" OBS_VALUE="-0.30356" />
            <Obs TIME_PERIOD="1983" OBS_VALUE="0.25457" />
            <Obs TIME_PERIOD="1984" OBS_VALUE="0.62539" />
            <Obs TIME_PERIOD="1985" OBS_VALUE="0.24016" />
            <Obs TIME_PERIOD="1986" OBS_VALUE="0.21601" />
            <Obs TIME_PERIOD="1987" OBS_VALUE="0.158" />
            <Obs TIME_PERIOD="1988" OBS_VALUE="0.42561" />
            <Obs TIME_PERIOD="1989" OBS_VALUE="0.13027" />
            <Obs TIME_PERIOD="1990" OBS_VALUE="0.1282" />
            <Obs TIME_PERIOD="1991" OBS_VALUE="0.07811" />
            <Obs TIME_PERIOD="1992" OBS_VALUE="0.21452" />
            <Obs TIME_PERIOD="1993" OBS_VALUE="0.33196" />
            <Obs TIME_PERIOD="1994" OBS_VALUE="0.40342" />
            <Obs TIME_PERIOD="1995" OBS_VALUE="0.2818" />
            <Obs TIME_PERIOD="1996" OBS_VALUE="0.20502" />
            <Obs TIME_PERIOD="1997" OBS_VALUE="0.41197" />
            <Obs TIME_PERIOD="1998" OBS_VALUE="0.27477" />
            <Obs TIME_PERIOD="1999" OBS_VALUE="0.36305" />
            <Obs TIME_PERIOD="2000" OBS_VALUE="0.34309" />
            <Obs TIME_PERIOD="2001" OBS_VALUE="-0.15183" />
            <Obs TIME_PERIOD="2002" OBS_VALUE="0.05248" />
            <Obs TIME_PERIOD="2003" OBS_VALUE="0.01974" />
            <Obs TIME_PERIOD="2004" OBS_VALUE="0.21926" />
            <Obs TIME_PERIOD="2005" OBS_VALUE="0.14284" />
            <Obs TIME_PERIOD="2006" OBS_VALUE="0.08444" />
            <Obs TIME_PERIOD="2007" OBS_VALUE="0.10456" />
            <Obs TIME_PERIOD="2008" OBS_VALUE="-0.04708" />
            <Obs TIME_PERIOD="2009" OBS_VALUE="-0.37212" />
            <Obs TIME_PERIOD="2010" OBS_VALUE="0.26111" />
            <Obs TIME_PERIOD="2011" OBS_VALUE="0.15814" />
            <Obs TIME_PERIOD="2012" OBS_VALUE="0.13338" />
            <Obs TIME_PERIOD="2013" OBS_VALUE="0.16281" />
        </Series>
        <Series LOCATION="CHL" VARIABLE="CTGSVD" UNIT_MEASURE="8" UNIT_MULT="0" FREQ="A" TIME_FORMAT="P1Y">
            <Obs TIME_PERIOD="1996" OBS_VALUE="0.03758" />
            <Obs TIME_PERIOD="1997" OBS_VALUE="0.04004" />
            <Obs TIME_PERIOD="1998" OBS_VALUE="0.01987" />
            <Obs TIME_PERIOD="1999" OBS_VALUE="0.00016" />
            <Obs TIME_PERIOD="2000" OBS_VALUE="0.02272" />
            <Obs TIME_PERIOD="2001" OBS_VALUE="0.01839" />
            <Obs TIME_PERIOD="2002" OBS_VALUE="0.00603" />
            <Obs TIME_PERIOD="2003" OBS_VALUE="0.02473" />
            <Obs TIME_PERIOD="2004" OBS_VALUE="0.05" />
            <Obs TIME_PERIOD="2005" OBS_VALUE="0.0327" />
            <Obs TIME_PERIOD="2006" OBS_VALUE="0.02591" />
            <Obs TIME_PERIOD="2007" OBS_VALUE="0.03622" />
            <Obs TIME_PERIOD="2008" OBS_VALUE="0.02642" />
            <Obs TIME_PERIOD="2009" OBS_VALUE="-0.0377" />
            <Obs TIME_PERIOD="2010" OBS_VALUE="0.05381" />
            <Obs TIME_PERIOD="2011" OBS_VALUE="0.04272" />
            <Obs TIME_PERIOD="2012" OBS_VALUE="0.0282" />
            <Obs TIME_PERIOD="2013" OBS_VALUE="0.02826" />
        </Series>
    </DataSet>
</CompactData>