Amazon DynamoDB

Configuration

Get Item

Operation

Get Item

AWS Region*

us-east-1

AWS Access Key ID*

••••••••

AWS Secret Access Key*

••••••••

Table Name*

my-table

Key (JSON)*

json

{\n "pk": "user#123"\n}

Consistent Read

Select...

Get Item (dynamodb_get)

Get an item from a DynamoDB table by primary key

Input

Parameter	Type	Required	Description
`region`	string	Yes	AWS region (e.g., us-east-1)
`accessKeyId`	string	Yes	AWS access key ID
`secretAccessKey`	string	Yes	AWS secret access key
`tableName`	string	Yes	DynamoDB table name
`key`	object	Yes	Primary key of the item to retrieve
`consistentRead`	boolean	No	Use strongly consistent read

Output

Parameter	Type	Description
`message`	string	Operation status message

Put Item

Operation

Put Item

AWS Region*

us-east-1

AWS Access Key ID*

••••••••

AWS Secret Access Key*

••••••••

Table Name*

my-table

Item (JSON)*

json

{\n "pk": "user#123",\n "name": "John Doe",\n "email": "john@example.com"\n}

Put Item (dynamodb_put)

Put an item into a DynamoDB table

Input

Parameter	Type	Required	Description
`region`	string	Yes	AWS region (e.g., us-east-1)
`accessKeyId`	string	Yes	AWS access key ID
`secretAccessKey`	string	Yes	AWS secret access key
`tableName`	string	Yes	DynamoDB table name
`item`	object	Yes	Item to put into the table

Output

Parameter	Type	Description
`message`	string	Operation status message

Query

Operation

Query

AWS Region*

us-east-1

AWS Access Key ID*

••••••••

AWS Secret Access Key*

••••••••

Table Name*

my-table

Key Condition Expression*

pk = :pk

Filter Expression

attribute_exists(email)

Expression Attribute Names (JSON)

json

{\n "#name": "name"\n}

Expression Attribute Values (JSON)

json

{\n ":pk": "user#123",\n ":name": "Jane"\n}

Index Name

GSI1

Limit

100

Query (dynamodb_query)

Query items from a DynamoDB table using key conditions

Input

Parameter	Type	Required	Description
`region`	string	Yes	AWS region (e.g., us-east-1)
`accessKeyId`	string	Yes	AWS access key ID
`secretAccessKey`	string	Yes	AWS secret access key
`tableName`	string	Yes	DynamoDB table name
`keyConditionExpression`	string	Yes	Key condition expression (e.g., "pk = :pk")
`filterExpression`	string	No	Filter expression for results
`expressionAttributeNames`	object	No	Attribute name mappings for reserved words
`expressionAttributeValues`	object	No	Expression attribute values
`indexName`	string	No	Secondary index name to query
`limit`	number	No	Maximum number of items to return

Output

Parameter	Type	Description
`message`	string	Operation status message
`items`	array	Array of items returned

Scan

Operation

Scan

AWS Region*

us-east-1

AWS Access Key ID*

••••••••

AWS Secret Access Key*

••••••••

Table Name*

my-table

Filter Expression

attribute_exists(email)

Projection Expression

pk, #name, email

Expression Attribute Names (JSON)

json

{\n "#name": "name"\n}

Expression Attribute Values (JSON)

json

{\n ":status": "active"\n}

Limit

100

Scan (dynamodb_scan)

Scan all items in a DynamoDB table

Input

Parameter	Type	Required	Description
`region`	string	Yes	AWS region (e.g., us-east-1)
`accessKeyId`	string	Yes	AWS access key ID
`secretAccessKey`	string	Yes	AWS secret access key
`tableName`	string	Yes	DynamoDB table name
`filterExpression`	string	No	Filter expression for results
`projectionExpression`	string	No	Attributes to retrieve
`expressionAttributeNames`	object	No	Attribute name mappings for reserved words
`expressionAttributeValues`	object	No	Expression attribute values
`limit`	number	No	Maximum number of items to return

Output

Parameter	Type	Description
`message`	string	Operation status message
`items`	array	Array of items returned

Update Item

Operation

Update Item

AWS Region*

us-east-1

AWS Access Key ID*

••••••••

AWS Secret Access Key*

••••••••

Table Name*

my-table

Key (JSON)*

json

{\n "pk": "user#123"\n}

Update Expression*

SET #name = :name

Expression Attribute Names (JSON)

json

{\n "#name": "name"\n}

Expression Attribute Values (JSON)

json

{\n ":name": "Jane Doe"\n}

Condition Expression

attribute_exists(pk)

Update Item (dynamodb_update)

Update an item in a DynamoDB table

Input

Parameter	Type	Required	Description
`region`	string	Yes	AWS region (e.g., us-east-1)
`accessKeyId`	string	Yes	AWS access key ID
`secretAccessKey`	string	Yes	AWS secret access key
`tableName`	string	Yes	DynamoDB table name
`key`	object	Yes	Primary key of the item to update
`updateExpression`	string	Yes	Update expression (e.g., "SET #name = :name")
`expressionAttributeNames`	object	No	Attribute name mappings for reserved words
`expressionAttributeValues`	object	No	Expression attribute values
`conditionExpression`	string	No	Condition that must be met for the update to succeed

Output

Parameter	Type	Description
`message`	string	Operation status message

Delete Item

Operation

Delete Item

AWS Region*

us-east-1

AWS Access Key ID*

••••••••

AWS Secret Access Key*

••••••••

Table Name*

my-table

Key (JSON)*

json

{\n "pk": "user#123"\n}

Condition Expression

attribute_exists(pk)

Delete Item (dynamodb_delete)

Delete an item from a DynamoDB table

Input

Parameter	Type	Required	Description
`region`	string	Yes	AWS region (e.g., us-east-1)
`accessKeyId`	string	Yes	AWS access key ID
`secretAccessKey`	string	Yes	AWS secret access key
`tableName`	string	Yes	DynamoDB table name
`key`	object	Yes	Primary key of the item to delete
`conditionExpression`	string	No	Condition that must be met for the delete to succeed

Output

Refer to the block outputs for this operation.

Usage Instructions

Integrate Amazon DynamoDB into workflows. Supports Get, Put, Query, Scan, Update, and Delete operations on DynamoDB tables.

Notes

Category: tools
Type: dynamodb

Amazon DynamoDB

On this page