Publication Table Web Services - Revision history

Mnelson: /* Excel Output Format */

2023-01-24T08:43:13Z

‎Excel Output Format

2023-01-24T08:42:54Z

‎JSON Output Format

2022-10-13T10:07:04Z

‎Publication Table Variable Availability

2022-10-13T10:06:43Z

‎Materialise Publication Table

2022-05-24T13:29:29Z

‎Publication Table Variable Availability

2022-05-20T09:00:03Z

‎Materialise Publication Table

2022-04-11T08:30:33Z

2022-03-30T08:28:01Z

‎Publication Table Variable Availability

2022-03-30T08:27:44Z

‎Materialise Publication Table

2022-03-30T08:27:25Z

‎Publication Table Definition

@@ Line 40: / Line 40: @@
 == Excel Output Format ==
-The default format for a materialised publication table is JSON, to explicitally request JSON set use the query parameter '''format=xlsx'''
+The default format for a materialised publication table is JSON, to explicitly request JSON set use the query parameter '''format=xlsx'''
 == Query pararmeters ==

@@ Line 35: / Line 35: @@
 == JSON Output Format ==
 [[File:Publication Table Excel.png|thumb|Publication Table output in Excel]]
-The default format for a materialised publication table is JSON, to explicitally request JSON set use the query parameter '''format=json'''
+The default format for a materialised publication table is JSON, to explicitly request JSON set use the query parameter '''format=json'''
-https://demo11.metadatatechnology.com/FusionRegistry/sdmx/v2/table/ECB.DISS/EXR/1.0
+https://demo11.metadatatechnology.com/FusionRegistry/sdmx/v2/table/ECB.DISS/EXR/1.0?CURRENCY=CAD
 == Excel Output Format ==

← Older revision		Revision as of 10:07, 13 October 2022
Line 71:		Line 71:
	Example 2 - Time Period set to 2019, variable values in the response are only included if they have data for this time period		Example 2 - Time Period set to 2019, variable values in the response are only included if they have data for this time period
	http(s)://myregistry/sdmx/v2/tableavailability/MY_AGENCY/MY_TABLE_D/1.0.0'''?TIME_PERIOD=2019'''		http(s)://myregistry/sdmx/v2/tableavailability/MY_AGENCY/MY_TABLE_D/1.0.0'''?TIME_PERIOD=2019'''
		+
		+	https://demo11.metadatatechnology.com/FusionRegistry/sdmx/v2/tableavailability/ECB.DISS/EXR/1.0

@@ Line 36: / Line 36: @@
 [[File:Publication Table Excel.png|thumb|Publication Table output in Excel]]
 The default format for a materialised publication table is JSON, to explicitally request JSON set use the query parameter '''format=json'''
 == Excel Output Format ==
 The default format for a materialised publication table is JSON, to explicitally request JSON set use the query parameter '''format=xlsx'''
+https://demo11.metadatatechnology.com/FusionRegistry/sdmx/v2/table/ECB.DISS/EXR/1.0?format=xlsx

@@ Line 65: / Line 65: @@
 Example 1 - No variable parameters are passed, the response contains all variable values that have data
-  http(s)://myregistry/'''sdmx/v2/table/MY_AGENCY/MY_TABLE_D/1.0.0'''
+  http(s)://myregistry/'''sdmx/v2/tableavailability/MY_AGENCY/MY_TABLE_D/1.0.0'''
 Example 2 - Time Period set to 2019, variable values in the response are only included if they have data for this time period
-  http(s)://myregistry/sdmx/v2/table/MY_AGENCY/MY_TABLE_D/1.0.0'''?TIME_PERIOD=2019'''
+  http(s)://myregistry/sdmx/v2/tableavailability/MY_AGENCY/MY_TABLE_D/1.0.0'''?TIME_PERIOD=2019'''

@@ Line 32: / Line 32: @@
 |}
-'''Query pararmeters'''
 Set variable Dimension Values: The parameter is the Dimension ID and the parameter value is the Dimension Value to set it to. For example, if TIME_PERIOD and REF_AREA are both variable Dimensions in the Publication Table definition, their values can be passed like this.

← Older revision		Revision as of 08:30, 11 April 2022
Line 1:		Line 1:
	[[Category:WebService]]		[[Category:WebService]]
		+
		+	@see [[Publication_Table\|Publication Table]]

	= Publication Table Definition =		= Publication Table Definition =

@@ Line 33: / Line 33: @@
 Set variable Dimension Values: The parameter is the Dimension ID and the parameter value is the Dimension Value to set it to. For example, if TIME_PERIOD and REF_AREA are both variable Dimensions in the Publication Table definition, their values can be passed like this.
-  http(s)://myregistry/sdmx/v2/table/MY_AGENCY/MY_TABLE_D/1.0.0?TIME_PERIOD=2019&REF_AREA=UK
+  http(s)://myregistry/sdmx/v2/table/MY_AGENCY/MY_TABLE_D/1.0.0'''?TIME_PERIOD=2019&REF_AREA=UK'''
 Include Time Range: It is possible to include the time range in the Publication Table response using the '''includePeriod''' query parameter. This provides the earliest possible data and latest possible date for which there is data for the given Table (taking into account Dimension varaible values).  This is an opt-in parameter as this information requires a secondary data query to the data store.

@@ Line 6: / Line 6: @@
 {| class="wikitable"
 |-
-|style="background-color:#eaecf0"|<b>Entry Point</b>|| <b> /sdmxapi/v2/publicationtable</b>
+|style="background-color:#eaecf0"|<b>Entry Point</b>|| <b> /sdmxapi/v2/structure/publicationtable/{agency id}/{id}/{version}</b>
 |-
 |style="background-color:#eaecf0"|<b>Http Method</b>|| GET
 |}
 = Materialise Publication Table  =