Amazon DynamoDB Query

Configuration

The Configuration tab has the following field.

Field Description
Connection Select the Amazon Web Services connection from the drop-down list.

Input Settings

This tab has the following fields:

Field Description
Query Provide a JSON query.
Sample JSON query: 
{
    "TableName": "orders",
    "ProjectionExpression": "orderId,address",
    "KeyConditionExpression": "orderId = :orderId",
    "FilterExpression": "state = :state"
}
Fields Autopopulated with expression attribute names and expression attribute values. Select a corresponding data type.

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.

This tab has the following optional fields:

Field Description
ScanIndexForward To reverse the order, set the Scan Index Forward parameter to false.
ConsistentRead Select one of the following options:

True: To allow the operations to use strongly consistent reads

False: To allow the operations to use eventually consistent reads

Limit The maximum number of items to be evaluated.
ReturnConsumedCapacity The details of the consumed capacity returned in the response.

Valid values: INDEXES, TOTAL, or NONE

Output Settings

This tab has the following fields:

Field Description
Response Schema Provide the DynamoDB JSON schema. To select a record, go to the "Edit Item" window in the AWS dynamodb table, select "Text" mode from the drop-down list and select DynamoDB JSON check box.

Sample JSON schema: 

{
    "customer_id": 
    {
        "S": "1527368"
    },
    "firstName": 
    {
        "S": "William"
    },
    "order_id": 
    {
        "S": "order21"
    }
}

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.

This tab has the following fields:

Field Description
Items The information in the schema varies based on the output schema provided by the user on the Output Settings tab.
Count If a filter expression is present, the number of items that remain after applying the filter expression.
ScannedCount If a filter expression is present, the number of items that match the key condition expression before applying the filter expression.
ConsumedCapacity The details of the throughput used by an operation.