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

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

Consent Lookup — Get Individual IDs by Email Address

1SELECT PartyId__c
2FROM ContactPointEmail__dlm
3WHERE EmailAddress__c=’jjones@email.com’
4LIMIT =100

Consent Lookup — Get Individual IDs by Phone Number

1SELECT PartyId__c
2FROM ContactPointPhone__dlm
3WHERE TelephoneNumber__c=’555-123-4567’
4LIMIT =100

Consent Lookup — Get Individual IDs by Name

1SELECT IndividualId__c
2FROM Individual__dlm
3WHERE FirstName__c=’Jimmy’ AND LastName__c=’Smith’
4LIMIT =100

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

1SELECT UnifiedRecordId__c
2FROM IndividualIdentityLink__dlm
3WHERE SourceRecordID__c='{sourceID}'
4LIMIT =100

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

1SELECT FirstName__c, LastName__c
2FROM UnifiedIndividual__dlm
3WHERE Id__c='{UnifiedRecordId__c}'
4LIMIT =100

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

1SELECT EmailAddress__c
2FROM UnifiedContactPointEmail__dlm
3WHERE PartyId__c={UnifiedRecordId__c}
4LIMIT =100

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

1SELECT TelephoneNumber__c
2FROM UnifiedContactPointPhone__dlm
3WHERE PartyId__c={UnifiedRecordId__c}
4LIMIT =100