Fusion-CSV-TS - Revision history

Mnelson: /* Parameters */

2021-02-04T11:47:21Z

‎Parameters

2021-02-04T11:46:39Z

‎Parameters

2020-12-02T15:00:04Z

‎Parameters

2020-10-29T20:24:07Z

‎Parameters

2020-10-22T11:51:14Z

‎Overview

2020-10-22T11:50:50Z

‎Overview

2020-07-28T13:14:17Z

‎Parameters

2020-07-10T08:31:56Z

‎Parameters

2020-07-10T08:31:22Z

‎Parameters

2020-07-09T18:44:04Z

‎Overview

@@ Line 50: / Line 50: @@
 <strong><u>Examples</u></strong><br>
 '''Breakdown by Time Series'''<br>
-<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><br>
+<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>
-<br/>
+<br><br>
 '''Breakdown by Time Series, include Series key'''<br>
 <i>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI..?format=csv-ts&labels=id&serieskey=include</i>
-<br/>
+<br><br>
 '''Breakdown by Sub Indicator'''<br>
 <i>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI..?format=csv-ts&labels=both&dimensionAtObservation=SUB_INDICATOR</i>
 '''One Row Per Observation'''<br>
 <i>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI..?format=csv-ts&labels=both&dimensionAtObservation=AllDimensions</i>

@@ Line 48: / Line 48: @@
 |}
-<strong>Examples</strong>
+<strong><u>Examples</u></strong><br>
-Breakdown by Time Series:
+'''Breakdown by Time Series'''<br>
-<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><br>
 <br/>
-Breakdown by Time Series, include Series key:
+'''Breakdown by Time Series, include Series key'''<br>
 <i>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI..?format=csv-ts&labels=id&serieskey=include</i>
 <br/>
-Breakdown by Sub Indicator
+'''Breakdown by Sub Indicator'''<br>
 <i>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI..?format=csv-ts&labels=both&dimensionAtObservation=SUB_INDICATOR</i>
 =Example Output=

@@ Line 42: / Line 42: @@
 |-
 | dimensionAtObservation || [dimension id] <br/> default to TIME_PERIOD || ID of Dimension default if not provided is TIME_PERIOD
 |-
 | bom || '''include ''' or '''exclude'''  || (Include or Exclude the [https://en.wikipedia.org/wiki/Byte_order_mark '''B'''yte '''O'''rder '''M'''ark] (BOM).<br/> The BOM helps Excel interpret non Latin characters when opening a CSV file)
@@ Line 49: / Line 51: @@
 Breakdown by Time Series:
 <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>
 <br/>
 Breakdown by Sub Indicator

@@ Line 31: / Line 31: @@
 The following URL parameters can be used in a RESTful query for Fusion-CSV-TS data.
-* format =csv-ts
+{| class="wikitable"
-* delimiter =comma | tab | semicolon | space (comma is default)
+|-
-* labels = id | name | both (id is default)
+! Query Parameter !! Values !! Description
-* dimensionAtObservation = ID of Dimension default if not provided is TIME_PERIOD
+|-
-* bom = include | exclude  (Include or Exclude the [https://en.wikipedia.org/wiki/Byte_order_mark '''B'''yte '''O'''rder '''M'''ark] (BOM).<br/> The BOM helps Excel interpret non Latin characters when opening a CSV file)
+| format || csv-ts || Required to output the dataset in csv-ts format
 <strong>Examples</strong>

@@ Line 25: / Line 25: @@
 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.
-'''Attributes'''
+'''Attributes'''<br>
 <b>Note:</b> The Fusion-CSV-TS Data format does not output observation or dataset Attributes, but it does output series Attributes.  Series Attributes are determined by the Attribute Attachement level as defined in the Data Structure Definition (DSD).  If the DSD defines an Attribute as varying with FREQ and REF_AREA, then this Attribute will be output unless either REF_AREA or FREQ are output as the Dimension at observation.

@@ Line 23: / Line 23: @@
 The Dimension in the columns is controlled using the '''dimensionAtObservation''' REST query parameter, defaulting to Time if not provided.
-<b>Note:</b> The Fusion-CSV-TS Data format does not output observation Attributes, but it does output series attributes.  Series Attributes are determined by the Attribute Attachement level as defined in the Data Structure Definition (DSD).  If the DSD defines an Attribute as varying with FREQ and REF_AREA, then this Attribute will be output unless either REF_AREA or FREQ are output as the Dimension at observation.
+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.
-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.
+'''Attributes'''
 =Parameters=

@@ Line 15: / Line 15: @@
 '''Example - By SUB_INDICATOR'''
 <pre>
-REF_AREA, INDICATOR, SUB_INDICATOR, FREQ, TIME_PERIOD, RANK, VALUE
+REF_AREA, INDICATOR,  FREQ, TIME_PERIOD, RANK, VALUE
-GHA,      GCI,       RANK,          A,    2008,        102,  3.6
+GHA,      GCI,        A,    2008,        102,  3.6
-GHA,      GCI,       RANK,          A,    2009,        114,  3.4
+GHA,      GCI,        A,    2009,        114,  3.4
-GHA,      GCI,       RANK,          A,    2010,        114,  3.5
+GHA,      GCI,        A,    2010,        114,  3.5
 </pre>