Skip to main content

On Demand Expressions

The Orgvue scripting language, Gizmo, allows you to perform querying, calculations, aggregations and transformations on your data and save those expressions to a property in your dataset for use in analysis and visualization

These calculation properties can be set to run automatically when editing the data within a pack or triggered manually from within Orgvue when required

The Orgvue API allows you to trigger these On Demand calculation to update your dataset

Executing On Demand Expressions​

If more than one expression is executed to update property values in your dataset, they will be executed in the order defined in the payload

For details of the On Demand endpoint see the API Reference

The format for the JSON payload is:

{
  "executeOnDemand": [
    "onDemandPropertyKey1",
    "onDemandPropertyKey2"
  ],
}

Optional Callback and Result Location URL's may be added to the payload

info

Orgvue API is unable to execute expressions saved as Pack properties. On Demand expressions must be saved as dataset properties in order for them to be available to execute via the API

The execution of an On Demand expression performs a calculation based on the data contained within your dataset therefore if it is being used as part of a data refresh routine it should be conducted after any target datasets have been updated