Client-side REST Arguments -FXLData
Revision as of 02:57, 25 July 2024 by Vmurrell (talk | contribs) (Vmurrell moved page Client-side REST Arguments -FXLData - Draft to Client-side REST Arguments -FXLData)
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
