Official |[Amazon DynamoDB] Add/Replace Item

Operation name

Add/Replace Item

Function overview

Writes input data to an Amazon DynamoDB table.

= Remarks =

This operation uses PutItem API or BatchWriteItem API. For more details on API specifications, refer to the following pages:

"PutItem" (http://docs.aws.amazon.com/en_us/amazondynamodb/latest/APIReference/API_PutItem.html)
"BatchWriteItem" (http://docs.aws.amazon.com/en_us/amazondynamodb/latest/APIReference/API_BatchWriteItem.html)

Data model

The data model of this component is table model type.

Properties

= Remarks =

For details on use of variables, refer to Variables.

Basic settings

Item name	Required/Optional	Use of variables	Description	Remarks
Name	Required	Not available	Enter a name that is used on the script canvas.
Input data	Required	Not available	Select a component on the script canvas.

Required settings

Item name	Required/Optional	Use of variables	Description	Remarks
Destination	Required	Not available	Select a connection resource. Add A new connection resource can be added. Edit list Connection resource settings can be edited in > HULFT INTEGRATE > Connections.
Table name	Required	Available	Select or enter a table name to be written to.
Attribute list	Required	-	Specify attribute list of the table specified in Table name. Added rows will be the target columns to write. Each target column can be operated with the following buttons: Up Move the selected target column upwards by one row. Down Move the selected target column downwards by one row. Add Add a target column. Delete Delete the target column.
Attribute list/Hash key	Optional	Not available	Displays whether it's a hash key attribute of the table specified in Table name or not.
Attribute list/Range key	Optional	Not available	Displays whether it's a range key attribute of the table specified in Table name or not.
Attribute list/Attribute name	Required	Available	Enter an attribute name of the table specified in Table name.	The specified attribute name is displayed in Mapper schema.
Attribute list/Type	Required	Not available	Select the type of Attribute name.	It's displayed in "<DynamoDB data type> (<Internal data type>)" format. DynamoDB data type Data type supported by Amazon DynamoDB. Internal data type Data type used internally. For details, refer to Internal data types.

Property actions

Item name	Description	Remarks
Update table name list	Get table names in the specified destination and set them in Table name.
Update attribute list	Execute the query for the table specified in Table name to get the items, and set the attributes of the first 10 items to the attribute list.	Enabled when Table name is specified. Attribute names and data types are extracted from the items gotten by executing a scan for the table specified in Table name. When there's an attribute of unsupported DynamoDB data type in the items gotten by scanning, that attribute isn't added to the attribute list. For more details on the supported types, refer to Limitations of AMAZONDYNAMODB category. When there's no item in the table specified in Table name, only the primary key attribute will be set. Irrespective of the actual attribute type, String (String) will be set for the data type.

Write settings

Item name	Required/Optional	Use of variables	Description	Remarks
Enable batch writing	Optional	Not available	Select whether or not to enable batch writing. Selected Batch writing will be performed. Not selected (Default) Batch writing won't be performed.	When Enable batch writing is selected, requests to add/update up to 25 items at a time will be sent.

Item name

Required/Optional

Use of variables

Description

Remarks

Enable batch writing

Optional

Not available

Select whether or not to enable batch writing.

Selected

Batch writing will be performed.

Not selected

(Default)

Batch writing won't be performed.

When Enable batch writing is selected, requests to add/update up to 25 items at a time will be sent.

Comment

Item name	Required/Optional	Use of variables	Description	Remarks
Comment	Optional	Not available	You can write a short description of this connector.

Schemas

Input schema

The number of columns varies depending on the Attribute list settings.

= Remarks =

For schema structure, refer to Table model type .

Output schema

None.

Loading schema in Mapper

The schema is loaded automatically.

= Remarks =

For details, refer to Edit Schema.

Transaction

Transaction isn't supported.

Parallel Stream Processing

PSP is supported.

= Remarks =

For details on PSP, refer to Parallel Stream Processing.

Available component variables

Component variable name	Description	Remarks
count	The number of add/replace requests that has been sent is stored.	The default value is null.
message_category	When an error occurs, the category of the message code corresponding to the error is stored.	The default value is null.
message_code	When an error occurs, the code of the message code corresponding to the error is stored.	The default value is null.
message_level	When an error occurs, the severity of the message code corresponding to the error is stored.	The default value is null.
error_type	When an error occurs, the error type is stored.	The default value is null. The format of the error type is as follows. Example: java.io.FileNotFoundException
error_message	When an error occurs, the error message is stored.	The default value is null.
error_trace	When an error occurs, the trace information for the error is stored.	The default value is null.

Message codes, exception messages, and limitations

Connector	Message code	Exception message	Limitations
Messages and limitations of the Amazon DynamoDB connector

Notes

When a request to Amazon DynamoDB fails due to a reason such as a connection timeout, the request will be retried 10 times.