---
schema_version: "1"
id: 186839e4bafc2f47edcb6033d2d4c9a6111eb8e696f857d99f0589dc6c558b7c
title: Data Cloud Query Profile Parameters
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/platform/api-rest/guides/resources/resources-cdp-query.md
canonical_url: https://developer.salesforce.com/docs/platform/api-rest/guide/resources-cdp-query.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: fae8ef9858f621868868a97f8fe55b643b4e7e9cfbc0dd90c0a6b9558f38b229
products:
  - REST API Developer Guide
  - Platform Developer Content
---

# 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](https://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/dome_query.htm) and [Query](https://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/resources_query.htm).

## 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**

```nolang
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**

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

**Consent Lookup — Get Individual IDs by Phone Number**

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

**Consent Lookup — Get Individual IDs by Name**

```nolang
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**

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

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

```nolang
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**

```nolang
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**

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