The table shows returned data type for particular argument data type.

See also the Salesforce documentation on Aggregate Functions.

See also Salesforce documentation on Date Functions.

Compound fields group together several fields to represent a complex data type, such as addresses or locations. SalesforceReader does not support reading compound fields as a whole, you need to read their separate parts. The dialog for defining SOQL shows the individual fields of compound fields, e.g. BillingStreet, BillingCity, etc.

For example, to read BillingAddress it is not possible to use the following SOQL:

SELECT BillingAddress FROM Account

Instead you need to read its individual component fields:

SELECT BillingStreet, BillingCity, BillingPostalCode FROM Account

See Compound Fields.

In subqueries, you cannot read data from binary fields or use aggregate functions. This is a limitation of the SOAP API.

When a Salesforce record is deleted it is first moved to Recycle Bin, from where it can be restored. Then automatically after a time interval, or after manually emptying the Recycle Bin, the record will be marked to be permanently deleted. Records marked to be permanently deleted cannot be restored, and are wiped from the database automatically by a background process.

If a record is deleted using the Hard Delete operation, it skips the Recycle Bin and is immediately ready to be permanently deleted.

Reading deleted records returns records which are not wiped yet, including those that are not in the Recycle Bin anymore but were not permanently deleted yet.

SalesforceReader uses multiple API calls during its run. All of them count towards your Salesforce API request limit. The precise call flow is:

Create a Salesforce connection.

In SalesforceReader, set up the Connection, SOQL query and Output mapping parameters.

//#CTL2

function integer transform() {
 	$out.0.Email = $in.0.Email;
 	$out.0.FirstName = $in.0.FirstName;
 	$out.0.LastName = $in.0.LastName;

 	return ALL;
}

SELECT Name, Parent.Name FROM Account

SELECT Account.Name, (SELECT Opportunity.Name, Opportunity.Type, Opportunity.Amount, Opportunity.Description FROM Opportunities) FROM Account

SELECT Account.Name, SUM(Amount) FROM Opportunity WHERE IsWon = true GROUP BY Account.Name ORDER BY SUM(Amount) DESC

Set the SalesforceReader attribute Read mode to Return also deleted or archived records.

Read the records and their IsDeleted field to distinguish deleted and not deleted records:

SELECT Name, IsDeleted FROM Account