Salesforce Reader: Feature Type Parameters

To access feature type parameters, click the gear icon on a feature type in the workspace. This opens the Feature Type Parameter Editor.

Tip To always display the editor in FME Workbench, you can select View > Windows > Parameter Editor.

General

All feature types share similar General parameters, which may include Feature Type Name, Reader or Writer information, and Geometry.

In most Writer Feature Type parameter dialogs, you can also control Dynamic Schema Definitions. Some database formats accept Table or Index Qualifier prefixes on the output table feature type.

These parameters apply only to a selected feature type, not to the entire reader.

Important If a feature type parameter corresponds to a reader-level parameter, then the reader parameter will be ignored and the feature type parameter will be used.

Object

Note If a SELECT Statement or WHERE clause is specified in the Salesforce Reader, the resulting attributes may be hidden. To expose the attributes created, you can place an AttributeExposer transformer in the workspace, after the Salesforce Reader.

WHERE Clause

The SOQL WHERE clause applied to object fields to limit the set of features returned.

If this parameter is not specified, then all the rows are returned. It will be ignored if the SELECT Statement is present.

SELECT Statement

A SOQL SELECT query to be used as the source for the results.

If this is specified, Salesforce will execute the query, and the Salesforce Reader will use the resulting rows as the features instead of reading from the table <objectName>.

All returned features will have a feature type of <objectName>, and attributes for all columns selected by the query.

Refer to Salesforce documentation for SOQL syntax and limitations.