Newer Version Available

This content describes an older version of this product. View Latest

Query Resource

Executes a query written in Salesforce Analytics Query Language (SAQL).
Resource URL
1/wave/query
Formats
JSON
Available Version
34.0
HTTP Methods
POST
POST Request Body
Property Name Type Description Required or Optional Available Version
query String The SAQL query in JSON format. Required 34.0
Example Request Body
1{
2    "query":"q = load \"0Fbxx0000000006CAA/0Fcxx000000001dCAA\";
3     q = group q by 'FirstName';
4     q = foreach q generate 'FirstName' as 'FirstName', count() as 'count';
5     q = limit q 2000;"
6}
POST Response Body
Property Name Type Description Filter Group and Version Available Version
json String The results of a SAQL query, in JSON format. Small, 34.0 34.0
Example Response Body
1{
2    "action":"query",
3    "responseId":"3vy-E9YmX-TIWe0769juD-",
4    "results": {
5      "records":[
6        {"FirstName":"","count":1},
7        {"FirstName":"Admin","count":1},
8        {"FirstName":"Integration","count":1},
9        {"FirstName":"Security","count":1}]},
10      "query":"q = load \"0Fbxx0000000006CAA/0Fcxx000000001dCAA\";
11        q = group q by 'FirstName';
12        q = foreach q generate 'FirstName' as 'FirstName', count() as 'count';
13        q = limit q 2000;",
14      "responseTime":544
15}

For more information about creating SAQL queries, see Wave Analytics SAQL Reference.