Difference between revisions of "Fusion-CSV-TS"
(→Overview) |
(→Example) |
||
| Line 18: | Line 18: | ||
<i>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI..?format=csv-ts&labels=both&delimiter=tab</i> | <i>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI..?format=csv-ts&labels=both&delimiter=tab</i> | ||
| − | =Example= | + | =Example Output= |
An example query using the format request parameters, [[Data_Formats|HTTP Accept Headers]] can also be used to define the same format.<br/> | An example query using the format request parameters, [[Data_Formats|HTTP Accept Headers]] can also be used to define the same format.<br/> | ||
<i>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI..?format=csv-ts&labels=both</i> | <i>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI..?format=csv-ts&labels=both</i> | ||
Revision as of 13:27, 24 March 2020
Overview
The Fusion-CSV-TS Data format predated SDMX-CSV and is not an official SDMX format. The format differs from both SDMX-CSV and Fusion-CSV as it does not output an observation per row, instead it outputs a Series per row with the time periods output across the columns.
Note: The Fusion-CSV-TS Data format does not output any Attribute values.
Fusion-CSV-TS can be used as an export format for the Fusion Registry, and an export format for the Fusion Edge Server and Fusion Data Browser. Fusion-CSV-TS can not be used as a data import format.
Parameters
The following URL parameters can be used in a RESTful query for Fusion-CSV-TS data.
format =csv delimiter =comma | tab | semicolon | space (comma is default) labels = id | name | both (id is default)
Example Output
An example query using the format request parameters, HTTP Accept Headers can also be used to define the same format.
https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI..?format=csv-ts&labels=both
An example dataset with IDs only, spaces have been added to this example to assist readability.
REF_AREA, INDICATOR, SUB_INDICATOR, FREQ, 2008, 2009, 2010 GHA, GCI, RANK, A, 102, 114, 114 GHA, GCI, VALUE, A, 3.6, 3.4, 3.5
The same dataset in Fusion-CSV with lables included. Note, labels columns are only included if the Dimension, Attribute, or Measure is Coded, if it is not, then only one column is output - this can be seen in the table below where both TIME_PERIOD and OBS_VALUE are only single columns.
REF_AREA, Reference Area, INDICATOR, Indicator, SUB_INDICATOR, Sub Indicator, FREQ, Frequency, 2008, 2009, 2010 GHA, Ghana, GCI, Global Competitiveness Index, RANK, Rank A, Annual, 102, 114, 114 GHA, Ghana, GCI, Global Competitiveness Index, VALUE, Value A, Annual, 3.6, 3.4, 3.5
