Salesforce CDP API Developer Guide
jSalesforce CDP Query API Library
This API family supports only synchronous query API in v1, with SQL query
in ANSI standard. The SQL can be a free form SQL with objects that include data
streams, profile/engagement data model objects, and unified data model objects.
This API can be used to support a variety of use cases that include data extraction,
external application integration or interactive querying on the data lake.
Key Properties
- The call return limit defaults to the max limit of 49,999 rows returned. Use a done flag to check whether more records exist.
- There is no explicit limit to the SQL call length.
- There is no explicit limit for the number of nested sub queries.
- There is no explicit limit for the number of joins.
- There is no explicit limit for the number of filters.
- There is no explicit limit for the number of column projections.
- There is no explicit limit for any specific data type, such as VARCHAR, DECIMAL, or TIMESTAMP.
- Pagination supported via limit, offset, and orderby parameters.
- When done is flagged as true in the response, then there are no more records to query. When the response is false, call orderby with offset param to retrieve the next set of numbers.
Connected App Setup
Set Up a Connected App to discover new insights about your customers.
Acquire and Exchange Your Access Token for Salesforce CDP
Acquire, and exchange your access token.