Connect REST API Developer Guide
jNewer Version Available
Salesforce CDP Query
Synchronously query Salesforce CDP 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
- Response body for POST
- Salesforce CDP Query Output