Newer Version Available

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

Salesforce CDP Query V2

Query up to 8 MB of Salesforce CDP 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
Salesforce CDP Query Output V2
Use the nextBatchId from the CDP Query Output V2 response body as the nextBatchId parameter in the Salesforce CDP Query Batch resource to get the next batch of data.