Difference between revisions of "FXLDataUrl()"
Jump to navigation
Jump to search
m (Vmurrell moved page =FXLDataUrl() to FXLDataUrl() without leaving a redirect: looks better) |
|||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 9: | Line 9: | ||
'''Syntax'''<br> | '''Syntax'''<br> | ||
| − | <small>=<strong>FXLDataUrl</strong>( ''Url , [MaxSeries] '' )</small> | + | <small>=<strong>FXLDataUrl</strong>( ''Url , [MaxSeries], [TimeFormatFrequencyId] '' )</small> |
{| class="wikitable" style="width:70%;" | {| class="wikitable" style="width:70%;" | ||
| Line 15: | Line 15: | ||
! !!style=max-width:4em | Argument!! style=max-width:4em | Description !! style=max-width:4em | Examples !! style=max-width:4em | Required? | ! !!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/ | + | | 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 | | 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 | ||
|} | |} | ||
Latest revision as of 05:08, 30 July 2025
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
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 |
