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
Request
- Base URLhttps://companynode.pricefx.com/pricefx/companypartition
- Auth
- HTTP basic
- or API key in header X-PriceFx-jwt
- TypeScriptA function with typed inputs. Its response is checked against the schema.
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
Response
OK
Changes
No recorded changes to this operation across all 2 revisions of this API.