Extract Data | Salesforce CDP API Developer Guide

Retrieve Metadata
The Salesforce CDP Metadata API response includes metadata about all entities, including Calculated Insights, Engagement, Profile, and other entities, as well as their relationships to other objects.

Search Customer Profile Information
The Salesforce CDP Profile API calls are used to lookup and search customer profile information. These API calls can be included in your external web/mobile apps to look up customer profile information.

Query Data using Query API V2
This API supports SQL query in ANSI standard. The results return as an array of records. The expected input when calling this API is free form SQL. The expected input objects include data stream, profile and engagement data model objects, and unified data model objects. This API can be used to support a variety of use cases, which includes large volume data reads, external application integration, or interactive ad hoc querying on the data lake.

Query Data using Query API V1
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.

Query Source Record IDs
Universal ID Lookup API allows you to query on a source record ID from one org and returns the IDs from all orgs.

Query Calculated Insights
The Calculated Insights API calls only support data collection from the Salesforce CDP Calculated Insights object. You can use this API to query Calculated Insights with selected SQL dimensions and measures with optional filters.