REST API Developer Guide
j
No Results
Search Tips:
- Please consider misspellings
- Try different search keywords
Data Cloud Query Profile Parameters
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 SELECT SubscriberKey__c, EngagementChannel__c, EmailName__c, SubjectLine__c FROM sfmc_email_engagement_click_{EID}__dll LIMIT =100 |
|
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
SELECT PartyId__c FROM ContactPointEmail__dlm WHERE EmailAddress__c=’jjones@email.com’ LIMIT =100 Get Individual IDs by Phone Number SELECT PartyId__c FROM ContactPointPhone__dlm WHERE TelephoneNumber__c=’555-123-4567’ LIMIT =100 Get Individual IDs by Name SELECT IndividualId__c FROM Individual__dlm WHERE FirstName__c=’Jimmy’ AND LastName__c=’Smith’ LIMIT =100 |
|
Unified Profile Lookup:
Retrieve Unified Individual and Unified Contact Points by Source Record Id. |
Step 1:
Get Unified Record Id by Source Record Id SELECT UnifiedRecordId__c FROM IndividualIdentityLink__dlm WHERE SourceRecordID__c='{sourceID}' LIMIT =100 Step 2: Query Unified Individual by Unified Profile ID SELECT FirstName__c, LastName__c FROM UnifiedIndividual__dlm WHERE Id__c='{UnifiedRecordId__c}' LIMIT =100 Step 3: Query Unified Contact Point Details by Unified Profile ID Unified Contact Point Email SELECT EmailAddress__c FROM UnifiedContactPointEmail__dlm WHERE PartyId__c={UnifiedRecordId__c} LIMIT =100 Unified Contact Point Phone SELECT TelephoneNumber__c FROM UnifiedContactPointPhone__dlm WHERE PartyId__c={UnifiedRecordId__c} LIMIT =100 |