SDMX-JSON Data

Overview

The SDMX-JSON Data format is an official SDMX format. It is a based on the JSON Specification,

SDMX-JSON was introduced in version 2.1 of the SDMX Specification to satisfy the use case of web disemination. Other then the syntax differences, SDMX-JSON differs from the ML formats (SDMX-ML Generic Data, SDMX-ML Structure Specific Data) because it transmists both the classification identifiers with the labels. This has the advantage of packaging all the information required to display a dataset in a single dataset, as oppose to the ML formats which require access to the Structural Metadata in order to decode the data.

SDMX-JSON data can be used as both an import and export format for the Fusion Registry, and an export format for the Fusion Edge Server and Fusion Data Browser.

Formatting Using Query Parameters

The following URL parameters can be used in a RESTful query for to get Generic data.

• format = sdmx-json

Example https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI..?format=sdmx-json

Note: The same formatting can be applied using HTTP Accept Headers as opposed to query parameters.

Example Output

https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI..?format=sdmx-json

The output below shows the full dataset in SDMX-EDI format

		"dataSets": [
			{
				"links": [
					{
						"rel": "dataflow",
						"urn": "urn:sdmx:org.sdmx.infomodel.datastructure.Dataflow=WB:GCI(1.0)",
						"uri": "https://raw.githubusercontent.com/sdmx-twg/sdmx-json/develop/structure-message/tools/schemas/1.0/sdmx-json-structure-schema.json"
					}
				],
				"action": "Information",
				"series": {
					"0:0:0:0": {
						"attributes": [
						],
						"observations": {
							"0": [
								"102"
							],
							"1": [
								"114"
							],
							
......

		"structure": {
			"links": [
				{
					"rel": "dataflow",
					"urn": "urn:sdmx:org.sdmx.infomodel.datastructure.Dataflow=WB:GCI(1.0)",
					"uri": "https://raw.githubusercontent.com/sdmx-twg/sdmx-json/develop/structure-message/tools/schemas/1.0/sdmx-json-structure-schema.json"
				},
				{
					"rel": "datastructure",
					"urn": "urn:sdmx:org.sdmx.infomodel.datastructure.DataStructure=WB:GCI(1.0)",
					"uri": "https://raw.githubusercontent.com/sdmx-twg/sdmx-json/develop/structure-message/tools/schemas/1.0/sdmx-json-structure-schema.json"
				}
			],
			"name": "Global Competitiveness Index",
			"names": {
				"en": "Global Competitiveness Index"
			},
			"description": "Global Competitiveness Index",
			"descriptions": {
				"en": "Global Competitiveness Index"
			},
			"dimensions": {
				"dataset": [
				],
				"series": [
					{
						"id": "REF_AREA",
						"name": "Reference Area",
						"keyPosition": 0,
						"role": null,
						"values": [
							{
								"id": "GHA",
								"name": "Ghana"
							}
						]
					},

An example dataset with the returned detail set to series keys only - fewer columns are written to the response.
https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI..?format=sdmx-edi&detail=serieskeysonly

The output below shows the full dataset in SDMX-EDI format

UNA:+.? '
UNB+UNOC:3+Unknown+ANONYMOUS+200330:1256+IREF729733++SDMX-EDI'
UNH+MREF000001+GESMES:2:1:E6'
BGM+74'
NAD+Z02+WB'
NAD+MR+ANONYMOUS'
NAD+MS+Unknown'
DSI+GCI'
STS+3+7'
DTM+242:202003301256:203'
IDE+5+GCI'
GIS+AR3'
GIS+1:::-'
ARR++GHA:GCI:RANK:A'
ARR++GHA:GCI:VALUE:A'
UNT+14+MREF000001'
UNZ+1+IREF729733'