The Cloud Elements Query Language (CEQL) provides a standard way to search across all of our elements. Many API providers support some form of searching in their APIs but each one approaches searching differently. Rather than having you research how to query each resource at a provider, we've normalized your search experience. Cloud Elements translates your queries to the API provider's search syntax.
CEQL in Salesforce Sales Cloud
When querying in Salesforce Sales Cloud, keep the following in mind:
- The Salesforce bulk chunking mechanism allows you to use bulk on large data sets without limitations. If you use an orderBy clause, chunking is disabled. If chunking is enabled, it may take longer to get all the data. Also, be aware that Salesforce has daily upload and download limits.
- Use CEQL to query the following endpoints:
- GET /campaigns
- GET /accounts
- GET /accounts/{accountId}/activities
- GET /accounts/{accountId}/notes
- GET /accounts/{accountId}/tasks
- GET /users
- GET /{objectName}
- GET /{objectName}/{objectId}/attachments
- GET /{objectName}/{objectId}/{childObjectName}
- GET /opportunities
- GET /opportunities/{opportunityId}/activities
- GET /opportunities/{opportunityId}/notes
- POST /bulk/query
- GET /contacts
- GET /contacts/{contactId}/activities
- GET /contacts/{contactId}/notes
- GET /contacts/{contactId}/tasks
- GET /leads
- GET /leads/{leadId}/activities
- GET /leads/{leadId}/notes
- GET /leads/{leadId}/tasks
- GET /reports/{id}
For more information about CEQL, see the API documentation for the element or Querying with CEQL.
