Client-side REST Arguments -FXLData
Revision as of 02:38, 22 July 2024 by Vmurrell (talk | contribs) (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...")
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
