Difference between revisions of "FXLDataUrlV()"
Jump to navigation
Jump to search
m (Vmurrell moved page =FXLDataUrlV() to FXLDataUrlV() without leaving a redirect: looks better) |
|||
| (2 intermediate revisions by one other user not shown) | |||
| Line 9: | Line 9: | ||
'''Syntax'''<br> | '''Syntax'''<br> | ||
| − | <small>=<strong>FXLDataUrlV</strong>( ''Url , [MaxSeries] '' )</small> | + | <small>=<strong>FXLDataUrlV</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/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>=FXLDataUrlV("https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/ECB,EXR,1.0/A.CAD+HUF+INR...E?round=2&labels=id",20) |
| + | </nowiki> || style="background-color:pink;" |Mandatory | ||
|- | |- | ||
| − | | 2||MaxSeries || The maximum number of series to return || | + | | 2||MaxSeries || The maximum number of series to return || 20 || 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:15, 30 July 2025
ƒx =FXLDataUrlV() returns a vertical dataset, one series per column with time spanning the rows. The dimension at observation cannot be changed, the REST argument, if set is ignored.
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
=FXLDataUrlV( Url , [MaxSeries], [TimeFormatFrequencyId] )
| Argument | Description | Examples | Required? | |
|---|---|---|---|---|
| 1 | Url | A complete and fully-formed SDMX data query URL | =FXLDataUrlV("https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/ECB,EXR,1.0/A.CAD+HUF+INR...E?round=2&labels=id",20) | Mandatory |
| 2 | MaxSeries | The maximum number of series to return | 20 | 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 |
