FXLDataUrl() - Revision history

Grahamcassidy at 13:08, 30 July 2025

2025-07-30T13:08:05Z

Grahamcassidy at 12:53, 30 July 2025

2025-07-30T12:53:39Z

Vmurrell at 10:58, 5 August 2024

2024-08-05T10:58:24Z

Vmurrell: Vmurrell moved page =FXLDataUrl() to FXLDataUrl() without leaving a redirect: looks better

2024-07-22T12:28:35Z

Vmurrell moved page =FXLDataUrl() to FXLDataUrl() without leaving a redirect: looks better

Vmurrell: Created page with "Category:Functions Reference FXLData By default ƒ_''x'' =FXLDataUrl() returns a horizontal time-series dataset. Time is the dimension at observation by default..."

2024-07-22T12:14:21Z

Created page with "Category:Functions Reference FXLData By default ƒ''x'' =FXLDataUrl() returns a horizontal time-series dataset. Time is the dimension at observation by default..."

New page

[[Category:Functions Reference FXLData]]
By default ƒ''x'' =FXLDataUrl() returns a horizontal time-series dataset. Time is the dimension at observation by default resulting in one series per row with time periods spanning the columns. A different dimension at observation can be chosen by adding a REST argument to the URL - refer to the guidance [[#Dimension at Observation|below]].

'''Use Case''' 
[[File:Fdb query syntax.PNG|thumb|Fusion Data Browser Query Syntax function]]
This version of the function is designed primarily for use cases where a data query URL is generated by a data discovery tool, for example:
* The Fusion Registry [https://demo.metadatatechnology.com/FusionRegistry/webservice/data.html REST Web Service query builder]
* The Fusion Data Browser Export Data ''Query Syntax'' function

'''Syntax''' 
=FXLDataUrl( ''Url , [MaxSeries] '' )

{| class="wikitable" style="width:70%;"
|-
! !!style=max-width:4em | Argument!! style=max-width:4em | Description !! style=max-width:4em | Examples !! style=max-width:4em | Required?
|-
| 1||Url|| A complete and fully-formed SDMX data query URL || <nowiki>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/ECB,EXR,1.0/A.CAD+HUF+INR...E?round=2&labels=id</nowiki> || style="background-color:pink;" |Mandatory
|-
| 2||MaxSeries || The maximum number of series to return || 1000 || Optional Defaults to 100 series
|}

@@ Line 19: / Line 19: @@
 | 2||MaxSeries || The maximum number of series to return || 1000 || Optional<br>Defaults to 100 series
 |-
-| 3||TimeFormatFrequencyId || Text If the optional TimeFormatFrequencyId argument is set to 'D', the plugin will convert TIME_PERIOD values to a daily format—provided the original frequency is less granular than daily || D|| Optional Defaults to the underlying time format if not used.
+| 3||TimeFormatFrequencyId || Text If the optional TimeFormatFrequencyId argument is set to 'D', the plugin will convert TIME_PERIOD values to a daily format—provided the original frequency is less granular than daily || D|| Optional Defaults to the underlying time format if not used
 |}

@@ Line 9: / Line 9: @@
 '''Syntax'''<br>
-<small>=<strong>FXLDataUrl</strong>( ''Url , [MaxSeries] '' )</small>
+<small>=<strong>FXLDataUrl</strong>( ''Url , [MaxSeries], [TimeFormatFrequencyId] '' )</small>
 {| class="wikitable" style="width:70%;"
@@ Line 18: / Line 18: @@
 |-
 | 2||MaxSeries || The maximum number of series to return || 1000 || Optional<br>Defaults to 100 series
 |}

@@ Line 15: / Line 15: @@
 ! !!style=max-width:4em | Argument!! style=max-width:4em | Description !! style=max-width:4em | Examples !! style=max-width:4em | Required?
 |-
-| 1||Url|| A complete and fully-formed SDMX data query URL || <nowiki>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/ECB,EXR,1.0/A.CAD+HUF+INR...E?round=2&labels=id</nowiki> || style="background-color:pink;" |Mandatory
+| 1||Url|| A complete and fully-formed SDMX data query URL || <nowiki>=FXLDataUrl("https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/CD2030,CONSOLIDATED,1.0/all?format=sdmx-compact-2.1",50)</nowiki> || style="background-color:pink;" |Mandatory
 |-
 | 2||MaxSeries || The maximum number of series to return || 1000 || Optional<br>Defaults to 100 series
 |}