With this extract type, you can read data directly from Salesforce.com objects.
|Connection:||A connection of type Salesforce|
|Salesforce Object:||Name of the standard or custom Salesforce objects (such as database table) containing the organization’s information, e.g. Account. The user must have read-level permission for that object.|
|Output Columns:||Specifies a list of one or more fields that should be retrieved from the specified object. An alias name of the field and a default value in case of empty or null values can be optionally assigned.|
|Logical Filter Expression:||
With this parameter, a Boolean condition can be applied for if several filter conditions have been defined. Valid symbols are: [0-9] ( ) AND OR NOT
If no logical filter expression is defined, an AND filter is applied, i.e. 1 AND 2 AND … AND n.
|Sorting:||Ascending or descending order of the entered column.|
|Limit:||Sets the number of rows allowed in the table.|
|Offset:||Sets a unit to offset from the beginning of the table. Note: Offset is not available when using Bulk API.|
|Distinct:||When checked, only distinct values from the source are returned.|
Same as Where-Filter, but applied to result of aggregated columns. Note: Having-Filter is not available when using Bulk API.
|Logical Filter Expression:||Same as logical filter expression, but applied to Having-filters.|
An optional part of a SOQL query with additional options that are appended to the generated SOQL statement.
ORDER BY Firstname NULLS LAST
|Use Bulk API:
||Use the Bulk API provided by Salesforce for processing large numbers of records asynchronously. If not set, the (classic) REST API from Salesforce will be used; this API may result in better performance for small and medium data volumes. Note: when using Bulk API, the Offset and Having-Filter options are not available.|
|Use Caching:||Memory, disk, or none (default). See Caching in Extracts for more information.|
Note: Salesforce uses the proprietary query language SOQL (Salesforce Object Query Language) for data retrieval. This extract type generates an SOQL SELECT statement based on the entered criteria. For more generic SOQL queries, the extract type SalesforceSOQL should be used.