> For the complete documentation index, see [llms.txt](https://docs.thingsup.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.thingsup.io/actions/dynamodb-query-action.md).

# DynamoDB Query Action

It provides a way to perform a query on DynamoDB. Before adding DynamoDB Query Action, user has to define a [**AWS Connection**](/connections/aws-connection.md). User need to provide following parameters to add DynamoDB Query Action.

#### TableName

User's DynamoDB Tablename

#### Function

*  JavaScript code to Query "DynamoDB".
*  "payload" object and "params" object is available in this code. params object should hold key-value data pairs as mentioned in [AWS Doc](https://docs.aws.amazon.com/AWSJavaScriptSDK/latest/AWS/DynamoDB/DocumentClient.html#query-property). "payload" object is supplied from Action Trigger like Rules, Action Command etc.
* Any params passed through Function will override parameters passed through form.

#### Connection ID

Connection ID of AWS Connection.

#### Limit

User can set limit here.

#### KeyConditionExpression

User can provide a KeyConditionExpression here. Check [AWS Doc](https://docs.aws.amazon.com/AWSJavaScriptSDK/latest/AWS/DynamoDB/DocumentClient.html#query-property) for more information.

#### ExpressionAttributeValues

User can provide a ExpressionAttributeValues here. Check [AWS Doc](https://docs.aws.amazon.com/AWSJavaScriptSDK/latest/AWS/DynamoDB/DocumentClient.html#query-property) for more information.

#### ExpressionAttributeNames

User can provide a ExpressionAttributeNames here. Check [AWS Doc](https://docs.aws.amazon.com/AWSJavaScriptSDK/latest/AWS/DynamoDB/DocumentClient.html#query-property) for more information.

#### FilterExpression

User can provide a FilterExpression here. Check [AWS Doc](https://docs.aws.amazon.com/AWSJavaScriptSDK/latest/AWS/DynamoDB/DocumentClient.html#query-property) for more information.

#### ProjectionExpression

User can provide a ProjectionExpression here. Check [AWS Doc](https://docs.aws.amazon.com/AWSJavaScriptSDK/latest/AWS/DynamoDB/DocumentClient.html#query-property) for more information.

```
//Example 1
//Let "id" and "name" are the column names inside DynamoDB table.
//It contains a entry having id=2 and name="abc"
//Following are the fields you need mention in form to get the entries from table id having value 2.

#a = :id_val     //KeyConditionExpression
{"#a":"id" }     //ExpressionAttributeNames
{":id_val":2}    //ExpressionAttributeValues
```

![Add DynamoDB Query Action](/files/rpXzO3uhZR1ox5hsVoNd)

Please note the following points:

{% hint style="info" %}

* "payload" object is supplied from Action Trigger like Rules, Action Command etc.
* Data Response of Query will be available as Action Response.
  {% endhint %}