queryData

POST {{baseUrl}}/ssot/query?batchSize=<integer>&offset=<integer>&orderby=<string>

Synchronously query data across data model, lake, unified, and linked objects in Data Cloud. This query returns up to 4,999 rows.

Available Version: 52.0

Root XML tag: <cdpQueryTag>

Note

A newer version of the Query API is available. We recommend using Query V2 API to take advantage of GET calls in addition to POST calls, subsequent requests, and larger response sizes.

Request Params

Available Version: 53.0 | | offset | string | | Number of rows to skip before returning results. The sum of offset and batchSize must be less than 2147483647. The default value is 0.

Available Version: 53.0 | | orderby | string | | Comma-separated values to sort the results in ascending or descending order, for example, GenderId__c ASC,Occupation__c DESC.

Available Version: 53.0 |

Request Body

{"sql"=>"select BirthDate__c, DataSourceId__c, DataSourceObjectId__c, ExternalRecordId__c, FirstName__c, GenderId__c, Id__c, InternalOrganizationId__c, LastName__c from Individual__dlm where Id__c='100470169'"}

HEADERS

RESPONSES

status: OK

{"done":"\u003cboolean\u003e","endTime":"\u003cstring\u003e","metadata":{"//":"\u003cobject\u003e"},"queryId":"\u003cstring\u003e","rowCount":"\u003cinteger\u003e","startTime":"\u003cstring\u003e"}