SDMX-ML Structure Specific Data - Revision history

Vmurrell: /* Overview */

2022-08-25T12:48:06Z

‎Overview

Vmurrell: /* Overview */

2021-03-27T11:02:47Z

‎Overview

Glenn at 16:00, 18 March 2021

2021-03-18T16:00:45Z

Glenn at 15:55, 18 March 2021

2021-03-18T15:55:12Z

Mnelson at 09:07, 10 August 2020

2020-08-10T09:07:26Z

Mnelson: /* Overview */

2020-03-30T13:04:42Z

‎Overview

Mnelson: Created page with "Category:SdmxDataFormat =Overview= The Structure Specific data format (formally known as Compact format) is an official SDMX format. It is known as one of the SDMX-ML fo..."

2020-03-30T12:54:25Z

Created page with "Category:SdmxDataFormat =Overview= The Structure Specific data format (formally known as Compact format) is an official SDMX format. It is known as one of the SDMX-ML fo..."

New page

[[Category:SdmxDataFormat]]

=Overview=
The Structure Specific data format (formally known as Compact format) is an official SDMX format. It is known as one of the SDMX-ML formats, in that it is SDMX whose representation is in [https://www.w3.org/XML/ XML].

Unlike the [[SDMX-ML_Generic_Data|SDMX-ML Generic data format]], the XML Elements and XML Attributes are the based on the [[Data_Structure_Definition|Data Structure Definition]] that the data is being transmitted for, this provides two main benefits:
# It is possible to validate that the dataset is reporting the correct values using a SDMX Schema
# The dataset is more compact, in terms of the volume of information used to transmit the dataset.

The SDMX-ML Structure Specific format was introduced in version 1.0 of the SDMX Specification, and exists in all subsequent releases, up to the current release of version 2.1. In releases prior to 2.1 the data format was called 'Compact' data.

=Formatting Using Query Parameters=
The following URL parameters can be used in a RESTful query for to get Generic data.
* format = sdmx-compact-2.1
* format = sdmx-compact-2.0
* format = sdmx-compact-1.0

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

Note: The same formatting can be applied using [[Data_Formats|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-compact-2.1

The output below shows a snippet of the XML - displaying two series definition with their respective observation values
<pre>
<Series REF_AREA="GHA" INDICATOR="GCI" SUB_INDICATOR="RANK" FREQ="A">
<Obs TIME_PERIOD="2008" OBS_VALUE="102"/>
<Obs TIME_PERIOD="2009" OBS_VALUE="114"/>
<Obs TIME_PERIOD="2010" OBS_VALUE="114"/>
<Obs TIME_PERIOD="2011" OBS_VALUE="114"/>
<Obs TIME_PERIOD="2012" OBS_VALUE="103"/>
<Obs TIME_PERIOD="2013" OBS_VALUE="114"/>
<Obs TIME_PERIOD="2014" OBS_VALUE="111"/>
<Obs TIME_PERIOD="2015" OBS_VALUE="119"/>
<Obs TIME_PERIOD="2016" OBS_VALUE="114"/>
<Obs TIME_PERIOD="2017" OBS_VALUE="111"/>
</Series>
<Series REF_AREA="GHA" INDICATOR="GCI" SUB_INDICATOR="VALUE" FREQ="A">
<Obs TIME_PERIOD="2008" OBS_VALUE="3.616139933"/>
<Obs TIME_PERIOD="2009" OBS_VALUE="3.448062477"/>
<Obs TIME_PERIOD="2010" OBS_VALUE="3.55568976"/>
<Obs TIME_PERIOD="2011" OBS_VALUE="3.64915433"/>
<Obs TIME_PERIOD="2012" OBS_VALUE="3.792629136"/>
<Obs TIME_PERIOD="2013" OBS_VALUE="3.693773108"/>
<Obs TIME_PERIOD="2014" OBS_VALUE="3.713529283"/>
<Obs TIME_PERIOD="2015" OBS_VALUE="3.582722052"/>
<Obs TIME_PERIOD="2016" OBS_VALUE="3.679439434"/>
<Obs TIME_PERIOD="2017" OBS_VALUE="3.72270246361418"/>
</Series>
.....
</pre>

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

The output below shows a snippet of the XML - displaying the two series returned from the query
<pre>
<Series REF_AREA="GHA" INDICATOR="GCI" SUB_INDICATOR="RANK" FREQ="A" />
<Series REF_AREA="GHA" INDICATOR="GCI" SUB_INDICATOR="VALUE" FREQ="A" />
</pre>

@@ Line 9: / Line 9: @@
 The SDMX-ML Structure Specific format was introduced in version 1.0 of the SDMX Specification, and exists in all subsequent releases, up to the current release of version 2.1.  In releases prior to 2.1 the data format was called 'Compact' data.
-SDMX-ML Structure Specific 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.
+SDMX-ML Structure Specific can be used as both an import and export format for the Fusion Metadata Registry, and an export format for the Fusion Edge Server and Fusion Data Browser.
 =Example Output=

← Older revision		Revision as of 16:00, 18 March 2021
Line 10:		Line 10:

	SDMX-ML Structure Specific 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.		SDMX-ML Structure Specific 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-compact-2.1
−	* format = sdmx-compact-2.0
−	* format = sdmx-compact-1.0
−
−	~~<strong>Example</strong>~~
−	~~<i>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI..?format=sdmx-compact-2.1</i>~~
−
−	~~<strong>Note:</strong> The same formatting can be applied using [[Data_Formats\|HTTP Accept Headers]] as opposed to query parameters.~~

	=Example Output=		=Example Output=

← Older revision		Revision as of 13:04, 30 March 2020
Line 9:		Line 9:

	The SDMX-ML Structure Specific format was introduced in version 1.0 of the SDMX Specification, and exists in all subsequent releases, up to the current release of version 2.1. In releases prior to 2.1 the data format was called 'Compact' data.		The SDMX-ML Structure Specific format was introduced in version 1.0 of the SDMX Specification, and exists in all subsequent releases, up to the current release of version 2.1. In releases prior to 2.1 the data format was called 'Compact' data.
		+
		+	SDMX-ML Structure Specific 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=		=Formatting Using Query Parameters=

@@ Line 3: / Line 3: @@
 The Structure Specific data format (formally known as Compact format) is an official SDMX format.  It is known as one of the SDMX-ML formats, in that it is SDMX whose representation is in [https://www.w3.org/XML/ XML].
-Unlike the [[SDMX-ML_Generic_Data|SDMX-ML Generic data format]], the XML Elements and XML Attributes are the based on the [[Data_Structure_Definition|Data Structure Definition]] that the data is being transmitted for, this provides two main benefits:
+Unlike the [[SDMX-ML_Generic_Data|SDMX-ML Generic data format]], the XML Elements and XML Attributes are the based on the Data Structure Definition that the data is being transmitted for, this provides two main benefits:
 # It is possible to validate that the dataset is reporting the correct values using a SDMX Schema
 # The dataset is more compact, in terms of the volume of information used to transmit the dataset.

@@ Line 1: / Line 1: @@
-[[Category:SdmxDataFormat]]
+[[Category:FMR Formats Reference]]
 =Overview=
 The Structure Specific data format (formally known as Compact format) is an official SDMX format.  It is known as one of the SDMX-ML formats, in that it is SDMX whose representation is in [https://www.w3.org/XML/ XML].