queryDataV2
POST {{baseUrl}}/ssot/queryv2
Query up to 8 MB of data across data model, lake, unified, and linked objects in Data Cloud.
Available Version: 54.0
Root XML tag: <cdpQueryTag>
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
| Key | Datatype | Required | Description |
|---|---|---|---|
Content-Type | string |
RESPONSES
status: OK
{"done":"\u003cboolean\u003e","endTime":"\u003cstring\u003e","metadata":{"//":{"placeInOrder":"\u003cinteger\u003e","type":"\u003cstring\u003e","typeCode":"\u003cinteger\u003e"}},"nextBatchId":"\u003cstring\u003e","queryId":"\u003cstring\u003e","rowCount":"\u003cinteger\u003e","startTime":"\u003cstring\u003e"}