v1

latestOpenAPI 3.0.02026-08-064842333.5 MB
Data Manager

SQL Query a Data Manager Object

Processes and queries data from Price Analyzer or Price Optimizer. The queries can be aggregated, do various computations including statistical projections. Supports filtering.

post/datamart.sqlquery

Query parameters

timeoutstring
Example:20

Set this parameter to override the default timeout (60 seconds) of the query. The maximum allowed timeout is 300 seconds. The default timeout value and the maximum timeout value can be configured in the backend. Setting higher timeout can be useful, for example, when a query takes long time (e.g., when processing large tables).

Request body

operationTypestring
startRowinteger
endRowinteger

Response

OK