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

Get Raw Data

This endpoint returns data in columnar format for all columns (raw data). User can make partial request through this endpoint having provided all the dimension under filter to get aggregated data.
 
Input:
Name Type Description 
FilterobjectContains list of dimension details which are used as a filter.
  1. DimensionId: Id of the dimension
  2. Members: array of members
  3. DimensionName: Name of dimension
FrequencyChar Frequency of Data required( A= Annual ;S=SemiAnnually; Q=Quarterly; W=Weekly; D=Daily)
FoldDimensionstringName of the dimension which has fold applied on the members
DatasetstringUnique dataset identifier

Result:

Name Type Description 
columnsarray[columns]

Tuples describing each column.
consists
name: Name of the column
type: type of the column can be:

  • Date
  • Text
  • Number
  • Location
  • Currency

status: Status of column can be:

  • Date
  • Measure
  • Detail
  • Dimension

dimensionId: Id of the dimension
fieldId: field id or metadata id for the column with the status detail.

 

DataobjectHold raw data of each column which contains:
  • Value : contains the significand/mantissa of observation value. 
    Should be multiplied with scale for observation data.
  • Frequency: Interval of time between which observation data is recorded. Values can be 'A' -Annual ,'Q' -Quarterly, 'M' -Monthly ,'W' -Weekly
datasetNamestringName of the dataset

Example:

Post: http://data.gov.om/api/1.1/data/details

{
   "Filter": [
      {
         "DimensionId": "Time",
         "Members": [
            "2005"
         ],
         "DimensionName": "Time",
         "UiMode": "singleMember"
      },
      {
         "DimensionId": "indicator",
         "Members": [
            "1000010"
         ],
         "DimensionName": "Indicators"
      },
      {
         "DimensionId": "periodic-release",
         "Members": [
            "1000000"
         ],
         "DimensionName": "Periodic release"
      },
      {
         "DimensionId": "program-quality",
         "Members": [
            "1000000"
         ],
         "DimensionName": "Program quality"
      }
   ],
   "Frequencies": [
      "A"
   ],
   "FoldDimension": null,
   "Dataset": "OMINF2016"
}
 

Ouput

{
   "columns":[
      {
         "id":"date",
         "name":"Date",
         "type":"Date",
         "status":"Date",
         "dimensionId":null,
         "fieldId":null
      },
      {
         "id":"indicator",
         "name":"Indicators",
         "type":"Text",
         "status":"Dimension",
         "dimensionId":"indicator",
         "fieldId":null,
         "detailColumns":[
            {
               "id":"arabic-full-name",
               "name":"الاسم الكامل",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"u1575u1604u1575u1587u1605-u1575u1604u1603u1575u1605u1604"
            },
            {
               "id":"arabic-name",
               "name":"اسم",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"u1575u1587u1605"
            },
            {
               "id":"arabic-unit",
               "name":"الوحدة",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"u1575u1604u1608u1581u1583u1577"
            },
            {
               "id":"description",
               "name":"Description",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"description"
            },
            {
               "id":"frequencies",
               "name":"Frequencies",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"frequencies"
            },
            {
               "id":"full-name",
               "name":"Full Name",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"full-name"
            },
            {
               "id":"id",
               "name":"Id",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"id"
            },
            {
               "id":"methodology",
               "name":"Methodology",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"methodology"
            },
            {
               "id":"short-description",
               "name":"Short description",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"short-description"
            },
            {
               "id":"short-name",
               "name":"Short name",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"short-name"
            },
            {
               "id":"source-link",
               "name":"Source link",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"source-link"
            },
            {
               "id":"source-name",
               "name":"Source name",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"source-name"
            },
            {
               "id":"unit",
               "name":"Unit",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"unit"
            }
         ]
      },
      {
         "id":"periodic-release",
         "name":"Periodic release",
         "type":"Text",
         "status":"Dimension",
         "dimensionId":"periodic-release",
         "fieldId":null,
         "detailColumns":[
            {
               "id":"arabic-name",
               "name":"اسم",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"periodic-release",
               "fieldId":"u1575u1587u1605"
            },
            {
               "id":"id",
               "name":"Id",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"periodic-release",
               "fieldId":"id"
            },
            {
               "id":"اسم",
               "name":"اسم",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"periodic-release",
               "fieldId":"اسم"
            }
         ]
      },
      {
         "id":"program-quality",
         "name":"Program quality",
         "type":"Text",
         "status":"Dimension",
         "dimensionId":"program-quality",
         "fieldId":null,
         "detailColumns":[
            {
               "id":"arabic-name",
               "name":"اسم",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"program-quality",
               "fieldId":"u1575u1587u1605"
            },
            {
               "id":"id",
               "name":"Id",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"program-quality",
               "fieldId":"id"
            },
            {
               "id":"اسم",
               "name":"اسم",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"program-quality",
               "fieldId":"اسم"
            }
         ]
      },
      {
         "id":"region",
         "name":"Regions",
         "type":"Text",
         "status":"Dimension",
         "dimensionId":"region",
         "fieldId":null
      },
      {
         "id":"regionid",
         "name":"Regions",
         "type":"Text",
         "status":"Dimension",
         "dimensionId":"region",
         "fieldId":null,
         "detailColumns":[
            {
               "id":"arabic-name",
               "name":"اسم",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"region",
               "fieldId":"u1575u1587u1605"
            },
            {
               "id":"description",
               "name":"Description",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"region",
               "fieldId":"description"
            },
            {
               "id":"id",
               "name":"Id",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"region",
               "fieldId":"id"
            },
            {
               "id":"iso",
               "name":"ISO",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"region",
               "fieldId":"iso"
            }
         ]
      },
      {
         "id":"value",
         "name":"Value",
         "type":"Number",
         "status":"Measure",
         "dimensionId":null,
         "fieldId":null
      }
   ],
   "filter":[
 
   ],
   "datasetName":"Information",
   "data":[
      {
         "date":{
            "value":"01/01/2002",
            "frequency":"A"
         },
         "indicator":{
            "arabic-full-name":"التلفزيون و الاذاعة ( حكومي )\اجمالي ساعات الارسال التلفزيوني والاذاعي اليومي- عدد",
            "arabic-name":"اجمالي ساعات الارسال التلفزيوني والاذاعي اليومي- عدد",
            "arabic-unit":"عدد",
            "description":"",
            "frequencies":"",
            "full-name":"Television & Radio (Governmental)\Grand Total - Transmission & Broadcasting Hours :Daily - No.",
            "id":"17166863",
            "methodology":"",
            "name":"Grand Total - Transmission & Broadcasting Hours :Daily - No",
            "short-description":"",
            "short-name":"",
            "source-link":"",
            "source-name":"",
            "unit":"Number"
         },
         "periodic-release":{
            "arabic-name":"الاجمالي",
            "id":"17166693",
            "name":"Total",
            "اسم":null
         },
         "program-quality":{
            "arabic-name":"الاجمالي",
            "id":"17166783",
            "name":"Total",
            "اسم":null
         },
         "region":"Oman",
         "regionid":{
            "arabic-name":"عمان",
            "description":"",
            "id":"1",
            "iso":"OM",
            "name":"Oman"
         },
         "value":65
      },
      {
         "date":{
            "value":"01/01/2003",
            "frequency":"A"
         },
         "indicator":{
            "arabic-full-name":"التلفزيون و الاذاعة ( حكومي )\اجمالي ساعات الارسال التلفزيوني والاذاعي اليومي- عدد",
            "arabic-name":"اجمالي ساعات الارسال التلفزيوني والاذاعي اليومي- عدد",
            "arabic-unit":"عدد",
            "description":"",
            "frequencies":"",
            "full-name":"Television & Radio (Governmental)\Grand Total - Transmission & Broadcasting Hours :Daily - No.",
            "id":"17166863",
            "methodology":"",
            "name":"Grand Total - Transmission & Broadcasting Hours :Daily - No",
            "short-description":"",
            "short-name":"",
            "source-link":"",
            "source-name":"",
            "unit":"Number"
         },
         "periodic-release":{
            "arabic-name":"الاجمالي",
            "id":"17166693",
            "name":"Total",
            "اسم":null
         },
         "program-quality":{
            "arabic-name":"الاجمالي",
            "id":"17166783",
            "name":"Total",
            "اسم":null
         },
         "region":"Oman",
         "regionid":{
            "arabic-name":"عمان",
            "description":"",
            "id":"1",
            "iso":"OM",
            "name":"Oman"
         },
         "value":80
      },
...
      {
         "date":{
            "value":"01/01/2004",
            "frequency":"A"
         },
         "indicator":{
            "arabic-full-name":"التلفزيون و الاذاعة ( حكومي )\اجمالي ساعات الارسال التلفزيوني والاذاعي اليومي- عدد",
            "arabic-name":"اجمالي ساعات الارسال التلفزيوني والاذاعي اليومي- عدد",
            "arabic-unit":"عدد",
            "description":"",
            "frequencies":"",
            "full-name":"Television & Radio (Governmental)\Grand Total - Transmission & Broadcasting Hours :Daily - No.",
            "id":"17166863",
            "methodology":"",
            "name":"Grand Total - Transmission & Broadcasting Hours :Daily - No",
            "short-description":"",
            "short-name":"",
            "source-link":"",
            "source-name":"",
            "unit":"Number"
         },
         "periodic-release":{
            "arabic-name":"الاجمالي",
            "id":"17166693",
            "name":"Total",
            "اسم":null
         },
         "program-quality":{
            "arabic-name":"الاجمالي",
            "id":"17166783",
            "name":"Total",
            "اسم":null
         },
         "region":"Oman",
         "regionid":{
            "arabic-name":"عمان",
            "description":"",
            "id":"1",
            "iso":"OM",
            "name":"Oman"
         },
         "value":85
      },
      "periodic-release":{
         "arabic-name":"الاجمالي",
         "id":"17166693",
         "name":"Total",
         "اسم":null
      },
      "program-quality":{
         "arabic-name":"الاجمالي",
         "id":"17166783",
         "name":"Total",
         "اسم":null
      },
      "region":"Oman",
      "regionid":{
         "arabic-name":"عمان",
         "description":"",
         "id":"1",
         "iso":"OM",
         "name":"Oman"
      },
      "value":0
   }
]
}