FXLDataUrl()

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 below.

Use Case

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 REST Web Service query builder
• The Fusion Data Browser Export Data Query Syntax function

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

	Argument	Description	Examples	Required?
1	Url	A complete and fully-formed SDMX data query URL	=FXLDataUrl("https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/CD2030,CONSOLIDATED,1.0/all?format=sdmx-compact-2.1",50)	Mandatory
2	MaxSeries	The maximum number of series to return	1000	Optional 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