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
36.0
HTTP Methods
POST
POST Request Body
Parameter Name Type Description Required or Optional Available Version
queryString String The SQL query. 36.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, 36.0 36.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 Analytics SAQL Referenceand the Analytics SDK Guide.