Difference between revisions of "Client-side REST Arguments -FXLData"

From Fusion Registry Wiki
Jump to navigation Jump to search
(Created page with "Category:How to and other features in FXLData =Client-side REST Arguments= The =FXLData() and =FXLDataV() functions support additional REST arguments to modify behaviour i...")
 
 
(No difference)

Latest revision as of 02:57, 25 July 2024

Client-side REST Arguments

The =FXLData() and =FXLDataV() functions support additional REST arguments to modify behaviour in Excel. These arguments are not passed to the Fusion Registry or Edge Server.

nocc - suppress completion of the resultset cube when startPeriod and / or endPeriod are specified. Under normal behaviour, the resultset will always span the time periods specified irrespective of whether there are observation values available. If nocc is specified in the REST Arguments, the resultset will only span time periods for which observations are available.
Examples:

nocc
round=2&nocc
nocc&dimensionAtObservation=REF_AREA