Amazon DynamoDB Operation

You can use the Amazon DynamoDB Operation activity to put, delete, or update an item in the DynamoDB database.

Settings

The Settings tab has the following fields:
Field Description
Connection Select an Amazon Web Services connection from the drop-down list.
Operation Select an operation from the following drop-down list:
  • PutItem
  • UpdateItem
  • DeleteItem

Input Settings

The Input Settings tab has the following fields:

Field Description
Operation Expression Provide a JSON query.
Sample JSON query:
{
    "TableName": "orders",
    "ConditionExpression": "orderId = :orderId"   
}
Note: On the Settings tab, if you select UpdateItem in the Operation, the following condition can be included in the JSON query: "UpdateExpression": "SET address = :adr".
Use Item Attributes Schema The default value of Use Item Attributes Schema is false. If true, you must provide the DynamoDB JSON schema for item attributes. For PutItem operation you must configure all the item attributes to be inserted in the database. For UpdateItem or Deleteitem operations, you must configure only the key attributes. If the primary key is defined, then the HashKey must be configured and if the composite key is defined, then both the HashKey and SortKey must be configured.
Attribute Fields Autopopulated with attributeNames and attributeValues used in Operation Expression. You can update the Type for these autopopulated fields.

If Use Item Attributes Schema is false, then you must manually add the FieldName and Type by using the Edit option in Attribute Fields. For PutItem operation you must configure all the item attributes and for UpdateItem or DeleteItem operations, you must configure only the key attributes.

Input

The Input tab contains the input schema. The fields that were selected on the Input Settings tab are available in the schema. You can either hard code their values or map them to a field from the output of a preceding activity in the flow using the Mapper. The Input tab has the following fields:

Field Description
TableName The name of the table that contains the items. The TableName value overwrites the value mentioned in the Operation Expression field on the Input Settings tab.
ExpressionAttributeNames To map the value for expression attribute names configured in Attribute Fields on the Input Settings tab. You must configure the child elements if expression attribute names are present in the Operation Expression on the Input Settings tab.
ExpressionAttributeValues To map the value for expression attribute values configured in Attribute Fields on the Input Settings tab. You must configure the child elements if expression attribute values are present in the Operation Expression on the Input Settings tab.
ItemAttributeValues (Mandatory) To map the value for item attributes configured in the Attribute Fields on the Input Settings tab. For PutItem operation you must configure all the item attributes and for UpdateItem or DeleteItem operations, you must configure only the key attributes.
ReturnConsumedCapacity The details of the consumed capacity returned in the response.

Valid values: INDEXES, TOTAL, or NONE

ReturnValues The values of the output attributes after performing the operation.
Valid values:
  • For PutItem or DeleteItem operations: NONE, ALL_OLD
  • For UpdateItem operation: NONE, ALL_OLD, ALL_NEW, UPDATED_OLD, UPDATED_NEW
RetryCount

The retry count for recoverable errors.

Output Settings

To define the schema that must be displayed for ReturnValues field on the Output tab, add the appropriate DynamoDB JSON Response Schema on the Output Settings tab. If the JSON Response field is empty, then the default schema is displayed on the Output tab without ReturnValues schema. For sample JSON response, see the Amazon DynamoDB documentation.

You can enable the Use app level schema toggle switch to configure the DynamoDB JSON Response Schema from app level schema. You can populate parsed output to map to the input of the subsequent activity.

Output

The Output tab displays the output schema of the activity as a tree structure. The output is read-only. The properties that are displayed in the schema correspond to the output of this activity and can be used as input by subsequent activities in the flow. The Output tab has the following fields:

Field Description
ReturnValues The values of the attributes after performing the operations and as per the value configured for ReturnValues on the Input tab.
ConsumedCapacity The details of the capacity units used by an operation.

Loop

If you want this activity to iterate multiple times within the flow, enter an expression that evaluates to the iteration details. Select a type of iteration from the Type menu. The default type is None, which means the activity does not iterate. For more information, refer to the "Using the Loop Feature in an Activity" topic in the TIBCO Flogo® Enterprise documentation.

Related concepts
Related reference