Put

The Put activity adds a row to a datagrid table. Before using the Put activity, you must first create a row object and set its values in the fields. The row object must contain a value in all fields of the primary key. The value of the key is unique. If the table already contains a row with that key value, then the Put activity replaces the existing row within the table. All other fields may contain or omit values.

General

In the General tab, you can specify the activity Name and a Table Connection.

The following table describes the fields in the General tab of the Put activity:

Field Module Property? Description
Name No Specifies the name to be displayed as the label for the activity in the process.
Table Connection Yes Click to select a table connection. If the datagrid for the required table connection is not found, in the Select FireflyResource Resource Template dialog box that opens, click Create Shared Resource to create a datagrid connection first. See Creating a DataGrid Connection and Adding a Table for details.
Timeout (sec) No Specifies the timeout value for the activity. The value specified here overrides the ActiveMatrix BusinessWorks™ default timeout value.

Description

In the Description tab, you can enter a short description for the Put activity.

Advanced

In the Advanced tab, you can provide advanced settings for the Put activity.

The following table describes the field in the Advanced tab of the Put activity:

Field Module Property? Description
Global TTL for All Rows No Specifies the time to live for the rows that you want to put in the table. The value that you enter in this field overrides the value provided in the —Time to Live (seconds) field in Table parameters.
Note: You can set a value in the "ttl" field for a specific row in the Input tab to override the global value provided here.
Batch Put Operation No Specifies if you want to execute put operations as a batch.
Operations Per Batch No Specifies the number of rows to be processed as a batch
Generate Put Output No Specifies the output schema and also indicates if there was an error in the ResultList of the Output tab. By default, the check box for this field is not selected.
Override Transaction Behavior No Specifies whether to override the existing transaction behavior for a local transaction.
Generate Only Key Output No Specifies the output based only on key fields.

Input

In the Input tab, you must provide the new rows that you want to put in the table.

Note: You can set the input in all the fields specified in the table. Non-key fields are optional. Here if you set a value in the "ttl" field for a row, it overrides the value that was provided in Global TTL for All Rows in the Advanced tab. Also if you set a value in the "timeout" field here, it overrides the ActiveMatrix BusinessWorks™ default timeout value.

Output

In the Output tab, you can find the operation results when you test the process.

The following table describes the field in the Output tab of the Put activity:

Output Item Data Type Description
ResultList String Specifies the HasError boolean value and the result. The result contains the HasError boolean value and the ROWs. If HasError is true, the result contains the Error message as well.
Note:

The HasError value is true when one or more results have errors.

The HasError value is false when no error occurs.

Fault

In the Fault tab, you can find the error code and error message of the Put activity. See Error Codes for more detailed explanation of the errors.

The following table describes the errors in the Fault tab of the Put activity:

Error Schema Element Data Type Description
msg String The plug-in error message.
msgCode String The plug-in error code.