Write Salesforce
(Cloud Connectivity)
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 (Data Table)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 (Connection)This input port expects a Connection object if any. See the parameter connection entry for more information.
Output
- through (Data Table)
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 (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 the connection input port is connected. Range: selection
- connection_entry This parameter is only available when the connection source parameter is set to repository. This parameter is used to specify a repository location that represents a connection entry. The connection can also be provided using the connection input port. Range: string
- 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. Range: configurable
- object_name The name of the Salesforce object for which to create records. Range: selection
- 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. Range: string
- 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. Range: boolean
- 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. Range: selection
- 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. Range: boolean
- 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. Range: boolean
