PivotView() is one of the view options for displaying data retrieved from the RelationshipData() and TimeSeries() functions. This view organises the requested data into rows

GlobalVariable() allows users to access variables configured by the administrator on a global level. These variables can be accessed from the Quintessence editor (from artifacts

Note: This is a legacy function and will be deprecated soon. Please use TimeSeries() instead.

Note: This is a legacy function and will be deprecated soon. Please use TimeSeries() instead.

Introduction Formatted Reports allow users to enhance basic data reports with advanced formatting, dynamic features, and user interaction options using IronPython. By adding formatting and

NPV stands for Net Present Value, and it is a financial metric used in capital budgeting and investment analysis. The Net Present Value represents the

TimeSeries is a sequence of data points, each consisting of a date and a value, associated with an entity and stored in the Quintessence database

JSON (JavaScript object notation) is a syntax for storing and exchanging data. Since the JSON format is text only, it can easily be sent to

The UploadDataAsync() function uploads data to Quintessence using a configured data feed and a range of data as input. Typically, a data feed would take

ReportAsync() performs calculations in the background (asynchronously from Excel). This is useful for larger reports, allowing you to continue working in Excel while the report

ExecuteScheduleAsync() works the same way as the ExecuteSchedule() function, but runs in the background (asynchronously when called from third-party applications). This is useful for longer-running

Schedules are automated workflows that perform tasks on behalf of a user. They can be run directly from the Quintessence application or triggered programmatically using

The audit log captures data related to usage activity routed through Quintessence by users. The AuditLog() function retrieves records and relevant details for all requests

The Span() function arranges multiple blocks of data into a single block of data and is often used to create reports consisting of multiple parts.

The Quintessence utility functions are available in both the Quintessence Excel® Addin and Quintessence Application. These functions perform useful manipulations on data. AlignToAxes ArrayToString Colouring

The XmlToArray() function converts a block of Xml formatted data to an Array. Syntax XmlToArray (Xml Input, Xml Mapping) Xml Input Raw Xml data used

The WebRequest() function sends an HTTP or HTTPS request to a specified URL using either the GET or POST method and returns the response data.