postQuery
POST {{baseUrl}}/wave/query
Execute a CRM Analytics query written in Salesforce Analytics Query Language (SAQL) or standard SQL.
For additional information, see the Query Resource.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
queryLanguage | string | (Optional) The query language. The default is SAQL. | |
queryString | string | (Optional) The query string to execute. It is recommended to use the SAQL Query Input Representation to pass the query. | |
timezone | string | (Optional) The timezone for the query. |
Request Body
{"query"=>"q = load \"0Fb1Q000000oOPCSA2/0Fc1Q00000BSHfxSAH\"; q = filter q by 'StageName' in [\"Closed Won\"]; q = group q by ('Type'); q = foreach q generate q.'Type' as 'Type', sum(q.'Amount') as 'A'; q = limit q 2000;"}
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
Content-Type | string |
RESPONSES
status: OK
{"eTag":"\u003cstring\u003e","json":"\u003cstring\u003e"}