DynamoDB Delete Table Item

• The input document must contain a Key object that identifies the item to delete.
• Key must have the partition key, plus the sort key if the table has one. Without the full primary key, DynamoDB can't find the item.

Example:

{ "Key": { "PartitionKeyName": { "S": "value1" }, "SortKeyName": { "S": "value2" } } }

{ "Key": { "PartitionKeyName": { "S": "value1" } } }

• Structure
• JSON Generator

• Filter
• JSON Formatter

Label

Default value: DynamoDB Delete Table Item

Default value: None

Example: Thread

Specify a logical condition to delete the item. This field is optional and does not pick the item to delete. It is a check that has to pass for the delete operation to succeed (for example, delete only if accountStatus = :status, with :status defined in Expression attribute values).

• If this field is empty, the item named in Key is deleted with no condition.
• If the condition is false, the Snap returns an error and doesn't delete the item.

Default value: None

Example deletion scenarios:

• A simple delete: Leave this field empty.
• Delete item only if the attribute exists: attribute_exists(duplicate1)
• Delete only if the status matches: accountStatus = :status, with :status of type S and value inactive in Expression attribute values.
• Delete only if the version matches: itemVersion = :ver, with :ver of type N and value 36 in Expression attribute values.
• Delete only if the record was created before 2000: CreatedDateTime < :cutoffDate, with :cutoffDate of type S and value 1999-12-31T23:59:59Z in Expression attribute values.

When to use each important field in this Snap:

Default value: 1

Default value: Not selected

Snap execution

Default value: Execute only

String Set [SS]

A value of this type contains a set of strings delimited by double quotes as follows:

Pattern: [String object 1, String object 2, ........, String Object n]

Example: ["Snaplogic", "San Mateo", "Pipeline"]

Number Set [NS]

A value of this type contains a set of numbers delimited by double quotes as follows:

Pattern: [Number Obj1, Number Object2,...., Number Object n]

Example: ["123", "24.56", "-35", "-21.456","0"]

Binary Set [BS]

A value of this type contains a set of base64-encoded binary data objects delimited by double quotes as follows:

Pattern: [ Binary Object 1, Binary Object 2,...Binary Object n]

Example: ["U3Vubnk=", "UmFpbnk=", "U25vd3k="]

List (L)

A value of this type contains a set of objects. Each object further can be of any type (String, Number, String Set, Map, List etc.,). In general, the List object resembles a JSON array.

Pattern: [ object 1, object 2, ........, Object n]

Example: [{"N":"3"},{"S":"-7.5"},{"B":"U3Vubnk="},{"L":[{"N":"-45.56"},{"M":{"Name":{"S":"ahmed"}}}]}, {"M":{"name":{"S":"syed"}}},{"SS":["a","b"]},{"BS":["U3Vubnk="]},{"NS":["23","45"]}]

Map (M)

A value of this type contains a set of key-value pairs. Keys are always strings, whereas values can be of any type (String, Number, String Set, Map, List etc.,). In general, the Map object resembles a JSON object.

Pattern: {"Key1":Object1, "Key2": Object2......"Keyn": Objectn}

Example: {"id":{"S":"snaplogic"}, "orgs":{"L":[{"S":"uat"}, {"S":"qa"}]}, "admins":{"L":[{"M":{"name":{"S":"a"}}}, {"M":{"name":{"S":"45"}}}]}}

• The DynamoDB Delete Table Item Snap expects the primary key to be provided in the input document with a specific structure ({"Key": {"PartitionKey": {"S": "value"}}}), rather than being derived from the Delete condition field.
• The Delete condition and Expression Attribute Values are not used to specify which item should be deleted. These fields are only used when a conditional delete is required.