Data Cloud Query Profile Parameters

Data Cloud Query and Unified Profile parameters allow you to leverage Salesforce REST API Query endpoint to execute SOQL queries against the Unified Profile, Data Source objects, or Data Model objects within your org. This functionality is supported using API version 51.0 or later.

For general information about using the Query REST call, see Execute a SOQL Query and Query.

The following SOQL parameters are supported for use with Data Cloud:

  • SELECT statement on a single object
  • SELECT clause: count()
  • SOQL WHERE clause: contains operators
  • SOQL LIKE
  • SOQL LIMIT clause. The default limit is set to 100. The max limit is 2,000 records in a single call.
  • SOQL OFFSET clause
  • SOQL ORDER BY clause

The following queries are not supported for use with Data Cloud:

  • SOQL Subqueries
  • SELECT clause: aggregate functions
  • SELECT clause: date functions
  • SOQL HAVING clause
Use CaseQueries
Data Preview: Examine data that has been ingested into a data lake object.Get Email Click Events. See example after this table.
Consent Lookup: Retrieve Individual IDs from Contact Point Data Model objects based on email address, phone number, or first and last name.Get Individual IDs by Email Address, Phone Number, or Name. See examples after this table.
Unified Profile Lookup: Retrieve Unified Individual and Unified Contact Points by Source Record Id.Steps to get Unified Record Id by Source Record Id, query Unified Individual by Unified Profile ID, and query Unified Contact Point details. See examples after this table.

Data Preview — Get Email Click Events

Consent Lookup — Get Individual IDs by Email Address

Consent Lookup — Get Individual IDs by Phone Number

Consent Lookup — Get Individual IDs by Name

Unified Profile Lookup — Step 1: Get Unified Record Id by Source Record Id

Unified Profile Lookup — Step 2: Query Unified Individual by Unified Profile ID

Unified Profile Lookup — Step 3: Query Unified Contact Point Email by Unified Profile ID

Unified Profile Lookup — Step 3: Query Unified Contact Point Phone by Unified Profile ID