Connect REST API Developer Guide
jNewer Version Available
Customer Data Platform Query
Synchronously query Customer Data Platform data across data model,
lake, unified, and linked objects.
This query returns up to 4,999 rows.
- Resource
-
1/ssot/query - Available version
- 52.0
- Requires Chatter
- No
- HTTP methods
- POST
- Request body for POST
-
- Root XML tag
- <cdpQueryTag>
- JSON example
-
1{ 2"sql": "select BirthDate__c, DataSourceId__c, DataSourceObjectId__c, ExternalRecordId__c, FirstName__c, GenderId__c, Id__c, InternalOrganizationId__c, 3LastName__c from Individual__dlm where Id__c='100470169'" 4} - Properties
-
Name Type Description Required or Optional Available Version sql String ANSI-standard SQL query. Required 52.0
- Request parameters for POST
-
Parameter Name Type Description Required or Optional Available Version batchSize Integer Number of records to return. Values are from 1–4999. The default value is 4999. Optional 53.0 offset Integer Number of rows to skip before returning results. The sum of offset and batchSize must be less than 2147483647. The default value is 0. Optional 53.0 orderby String Comma-separated values to sort the results in ascending or descending order, for example, GenderId__c ASC,Occupation__c DESC. Optional 53.0 - Response body for POST
- Customer Data Platform Query Output