Extract Data | Customer Data Platform 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.

SQL Guide for Query Service
Customer Data Platform supports ANSI-compliant SQL to formulate queries. Post these queries as requests to Query service and retrieve data from Customer Data Platform.

Customer Data Platform Python Connector
Unlock and extend the value of Customer Data Platform data with the CDP Python Connector. The connector uses the Query API and extracts the Customer Data Platform data into Python. It lets you fetch data in Pandas DataFrames. With the data in your environment, you can create visual data models, perform powerful analytical operations, or build powerful machine learning and AI models as well.

API Limits for Profile, Query, and Calculated Insights
There are three distinct classes of APIs: Profile, Query, and Calculated Insights. At present, the limits are by Salesforce editions, not APIs. Therefore, the following limits apply when using Customer Data Platform for all APIs. The limits are calculated cumulatively across Profile, Query, and Calculated Insights API.