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.

Supported SOQL Parameters

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

SOQL Limitations

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

SOQL Subqueries
SELECT clause: aggregate functions
SELECT clause: date functions
SOQL HAVING clause

Sample Queries

Use Case	Queries
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

SELECT SubscriberKey__c, EngagementChannel__c, EmailName__c, SubjectLine__c
FROM sfmc_email_engagement_click_{EID}__dll
LIMIT =100

Consent Lookup — Get Individual IDs by Email Address

SELECT PartyId__c
FROM ContactPointEmail__dlm
WHERE EmailAddress__c=’jjones@email.com’
LIMIT =100

Consent Lookup — Get Individual IDs by Phone Number

SELECT PartyId__c
FROM ContactPointPhone__dlm
WHERE TelephoneNumber__c=’555-123-4567’
LIMIT =100

Consent Lookup — Get Individual IDs by Name

SELECT IndividualId__c
FROM Individual__dlm
WHERE FirstName__c=’Jimmy’ AND LastName__c=’Smith’
LIMIT =100

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

SELECT UnifiedRecordId__c
FROM IndividualIdentityLink__dlm
WHERE SourceRecordID__c='{sourceID}'
LIMIT =100

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

SELECT FirstName__c, LastName__c
FROM UnifiedIndividual__dlm
WHERE Id__c='{UnifiedRecordId__c}'
LIMIT =100

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

SELECT EmailAddress__c
FROM UnifiedContactPointEmail__dlm
WHERE PartyId__c={UnifiedRecordId__c}
LIMIT =100

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

SELECT TelephoneNumber__c
FROM UnifiedContactPointPhone__dlm
WHERE PartyId__c={UnifiedRecordId__c}
LIMIT =100