SAP Cloud Platform Open Connectors

Salesforce Sales Cloud Querying

The Open Connectors Query Language (OCNQL) provides a standard way to search across all of our connectors. 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. SAP Cloud Platform Open Connectors 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 OCNQL, see the API documentation for the connector or Querying with OCNQL.