Connect REST API Developer Guide
jSalesforce CDP Query
Synchronously query Salesforce CDP data across data model, lake,
unified, and linked objects.
This query returns up to 4,999 rows.
- Resource
-
- Available version
- 52.0
- Requires Chatter
- No
- HTTP methods
- POST
- Request body for POST
-
- Root XML tag
- <cdpQueryTag>
- JSON example
-
- Properties
-
Name Type Description Required or Optional Available Version sql String ANSI-standard SQL query. Required 52.0
- Request parameters for POST
-
Parameter Name Type Description Required or Optional Available Version batchSize Integer Number of records to return. Values are from 1–4999. The default value is 4999. Optional 53.0 offset Integer Number of rows to skip before returning results. The sum of offset and batchSize must be less than 2147483647. The default value is 0. Optional 53.0 orderby String Comma-separated values to sort the results in ascending or descending order, for example, GenderId__c ASC,Occupation__c DESC. Optional 53.0 - Response body for POST
- Salesforce CDP Query Output