Skip to content

SOQL query (Salesforce)¤

Python Plugin

This operator is part of a Python Plugin Package. In order to use it, you need to install it, e.g. with cmemc.

This task executes a custom Salesforce Object Query (SOQL) and returns sets of tabular data from your organization’s Salesforce account.

Use the Salesforce Object Query Language (SOQL) to search your organization’s Salesforce data for specific information. SOQL is similar to the SELECT statement in the widely used Structured Query Language (SQL) but is designed specifically for Salesforce data. – developer.salesforce.com

SOQL uses the SELECT statement combined with filtering statements to return sets of data, which can optionally be ordered. For a complete description of the syntax, see Salesforce SOQL SELECT Syntax.

In the Advanced Options section, you can enable / disable the validation of your SOQL Query. By default, this Parse SOQL option is set True (enabled).

Examples:

Retrieve all standard fields from all Lead resources. (without parser validation) 

SELECT FIELDS(STANDARD) FROM Lead
Retrieve first name and last name of all Contact resources. (with parser validation) 
SELECT Contact.Firstname, Contact.Lastname FROM Contact

Please refer to the Salesforce Standard Objects list of the Salesforce Platform data model in order to get an overview of the available objects and fields.

Parameter¤

Username¤

Username of the Salesforce Account. This is typically your email address.

  • Datatype: string
  • Default Value: None

Password¤

  • Datatype: string
  • Default Value: None

Security Token¤

In addition to your standard account credentials, you need to provide a security token to access your data. Refer to the Salesforce Reset Token Documentation to learn how to retrieve or reset your token.

  • Datatype: string
  • Default Value: None

SOQL Query¤

The query text of your SOQL query. SOQL uses the SELECT statement combined with filtering statements to return sets of data, which can optionally be ordered. For a complete description of the syntax, see Salesforce SOQL SELECT Syntax.

  • Datatype: multiline string
  • Default Value: None

Dataset¤

In addition to have direct output of the fetched entities of your SOQL query, you can directly write the response to a JSON dataset (mostly for debugging purpose).

  • Datatype: string
  • Default Value: None

Comments