Amazon DynamoDB Operation
You can use the Amazon DynamoDB Operation activity to put, delete, or update an item in the DynamoDB database.
Input Settings
The Input Settings tab has the following fields:
Field | Description |
---|---|
Operation Expression | Provide a JSON query. |
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. |
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:
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.