Newer Version Available

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

Data Cloud Query V2

Query up to 8 MB of data across data model, lake, unified, and linked objects.
Resource
1/ssot/queryv2
Available version
54.0
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
Data Cloud Query Output V2
Use the nextBatchId from the Data Cloud Query Output V2 response body as the nextBatchId parameter in the Data Cloud Query Batch resource to get the next batch of data.