Customer 360 Audiences Query Profile Parameters (Beta)

The Customer 360 Audiences Query and Unified Profile parameters allow you to leverage the 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 50.0 or later.

As a Beta feature, the Customer 360 Audiences Query and Profile parameters are not part of the “Services” under your master subscription agreement with Salesforce. Use this feature at your sole discretion, and make your purchase decisions based on the generally available products and features. Salesforce doesn’t guarantee general availability of this feature within any particular time frame or at all, and we can discontinue it at any time. These parameters are for evaluation purposes only, and not for production use. They are offered as is and are not supported. Salesforce has no liability for any harm or damage arising out of the use of this feature. All restrictions, Salesforce reservation of rights, obligations concerning the Services, and terms for related Non-Salesforce Applications and Content apply equally to your use of these parameters. For general information about using the Query REST call, see Execute a SOQL Query and Query.

Note

Supported SOQL Parameters

The following SOQL parameters are supported for use with Customer 360 Audiences:

SELECTstatement on a single object
SOQL WHEREclause: contains operators
SOQL LIKE
SOQL LIMITclause
The default limit is set to 100. The max limit is 2,000 records in single call.
SOQL OFFSETclause

SOQL Limitations

The following queries are not supported for use with Customer 360 Audiences:

SOQLSubqueries
SOQL ORDER BYclause
SELECTclause: count()
SELECTclause: aggregate functions
SELECTclause: date functions
SOQL HAVINGclause

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

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

REST API Developer Guide

Customer 360 Audiences Query Profile Parameters (Beta)

Supported SOQL Parameters

SOQL Limitations

Sample Queries