Connect REST API Developer Guide
jNewer Version Available
Customer Data Platform Query V2
Query up to 8 MB of Customer Data Platform data across data model,
lake, unified, and linked objects.
- Resource
-
1/ssot/queryv2 - Available version
- 54.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
- Response body for POST
- Customer Data Platform Query Output V2
- Use the nextBatchId from the Customer Data Platform Query Output V2 response body as the nextBatchId parameter in the Customer Data Platform Query Batch resource to get the next batch of data.