Write Salesforce

Synopsis

This operator creates records for a Salesforce object from the input example set.

Description

This operator creates entries for a Salesforce object from the input example set in the specified Salesforce instance. Each example of the input data will create one Salesforce entry. The selected attributes will be used as the respective field values.

To select the fields which should be created, you can use the attribute selection parameters. Attributes which are not selected are ignored.

Note that datetime fields are always treated as UTC (Coordinated Universal Time), using the pattern "yyyy-MM-dd'T'HH:mm:ss.SSSX". Date fields use "yyyy-MM-dd" and time fields "HH:mm:ss.SSSX".

If the skip invalid parameter is selected, each row for which the creation in Salesforce failed will return a missing value in the ID column.

Input

input

The example set containing the entries which should be created. Note: It is strictly forbidden to have an ID column in the example set.

connection

This input port expects a Connection object if any. See the parameterconnection entryfor more information.

Output

通过

The input example set including an ID column containing the IDs generated by Salesforce for each entry or a missing value if the entry could not be created and the parameter 'skip_invalid_rows' is set to true.

connection

This output port delivers the Connection object from the input port. If the input port is not connected the port delivers nothing.

Parameters

Connection source

This parameter indicates how the connection should be specified. It gives you two options: repository and predefined. The parameter is not visible if theconnectioninput port is connected.

Connection entry

This parameter is only available when theconnection sourceparameter is set torepository. This parameter is used to specify a repository location that represents a connection entry. The connection can also be provided using theconnectioninput port.

Connection

The connection details for the Salesforce connection can be specified here. If you have already configured a Salesforce connection, you can select it from the drop-down list. If you have not configured a Salesforce connection yet, select the icon to the right of the drop-down list. Create a new Salesforce connection in the Manage connections box. This includes username, password and the security token. The URL is predefined but can be changed to work on a different API version.

Object name

Salesforce对象而的名h to create records.

Salesforce id column

The name of the column which will contain the IDs for each successfully created entry. The name must not be used for any existing column in the incoming example set.

Skip invalid rows

If selected, skips and ignores failed creations of a record. In such cases, the ID column value is set to missing. If not selected, the process will fail if a record cannot be created and no records will be created in Salesforce at all.

Attribute filter type

You can specify which attributes should be updated. By default all attributes are updated. Possible values are: all, single, subset, regular_expression, value_type, block_type, no_missing_values, numeric_value_filter.

Invert selection

If the checkbox is activated, the attributes selection is toggled: all attributes that are selected before, are excluded and all excluded attributes are included. If the checkbox is deactivated (default) the attribute selection is applied.

Includes special attributes

If the checkbox is activated, the operator is also applied to special attributes. If the checkbox is deactivated, the special attributes are ignored.