Amazon DynamoDB

2021/11/23 - Amazon DynamoDB - 3 updated api methods

Changes  DynamoDB PartiQL now supports ReturnConsumedCapacity, which returns capacity units consumed by PartiQL APIs if the request specified returnConsumedCapacity parameter. PartiQL APIs include ExecuteStatement, BatchExecuteStatement, and ExecuteTransaction.

BatchExecuteStatement (updated) Link ¶
Changes (request, response)
Request
{'ReturnConsumedCapacity': 'INDEXES | TOTAL | NONE'}
Response
{'ConsumedCapacity': [{'CapacityUnits': 'double',
                       'GlobalSecondaryIndexes': {'string': {'CapacityUnits': 'double',
                                                             'ReadCapacityUnits': 'double',
                                                             'WriteCapacityUnits': 'double'}},
                       'LocalSecondaryIndexes': {'string': {'CapacityUnits': 'double',
                                                            'ReadCapacityUnits': 'double',
                                                            'WriteCapacityUnits': 'double'}},
                       'ReadCapacityUnits': 'double',
                       'Table': {'CapacityUnits': 'double',
                                 'ReadCapacityUnits': 'double',
                                 'WriteCapacityUnits': 'double'},
                       'TableName': 'string',
                       'WriteCapacityUnits': 'double'}]}

This operation allows you to perform batch reads or writes on data stored in DynamoDB, using PartiQL.

Note

The entire batch must consist of either read statements or write statements, you cannot mix both in one batch.

See also: AWS API Documentation

Request Syntax

client.batch_execute_statement(
    Statements=[
        {
            'Statement': 'string',
            'Parameters': [
                {
                    'S': 'string',
                    'N': 'string',
                    'B': b'bytes',
                    'SS': [
                        'string',
                    ],
                    'NS': [
                        'string',
                    ],
                    'BS': [
                        b'bytes',
                    ],
                    'M': {
                        'string': {'... recursive ...'}
                    },
                    'L': [
                        {'... recursive ...'},
                    ],
                    'NULL': True|False,
                    'BOOL': True|False
                },
            ],
            'ConsistentRead': True|False
        },
    ],
    ReturnConsumedCapacity='INDEXES'|'TOTAL'|'NONE'
)
type Statements

list

param Statements

[REQUIRED]

The list of PartiQL statements representing the batch to run.

  • (dict) --

    A PartiQL batch statement request.

    • Statement (string) -- [REQUIRED]

      A valid PartiQL statement.

    • Parameters (list) --

      The parameters associated with a PartiQL statement in the batch request.

      • (dict) --

        Represents the data for an attribute.

        Each attribute value is described as a name-value pair. The name is the data type, and the value is the data itself.

        For more information, see Data Types in the Amazon DynamoDB Developer Guide .

        • S (string) --

          An attribute of type String. For example:

          "S": "Hello"

        • N (string) --

          An attribute of type Number. For example:

          "N": "123.45"

          Numbers are sent across the network to DynamoDB as strings, to maximize compatibility across languages and libraries. However, DynamoDB treats them as number type attributes for mathematical operations.

        • B (bytes) --

          An attribute of type Binary. For example:

          "B": "dGhpcyB0ZXh0IGlzIGJhc2U2NC1lbmNvZGVk"

        • SS (list) --

          An attribute of type String Set. For example:

          "SS": ["Giraffe", "Hippo" ,"Zebra"]

          • (string) --

        • NS (list) --

          An attribute of type Number Set. For example:

          "NS": ["42.2", "-19", "7.5", "3.14"]

          Numbers are sent across the network to DynamoDB as strings, to maximize compatibility across languages and libraries. However, DynamoDB treats them as number type attributes for mathematical operations.

          • (string) --

        • BS (list) --

          An attribute of type Binary Set. For example:

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

          • (bytes) --

        • M (dict) --

          An attribute of type Map. For example:

          "M": {"Name": {"S": "Joe"}, "Age": {"N": "35"}}

          • (string) --

            • (dict) --

              Represents the data for an attribute.

              Each attribute value is described as a name-value pair. The name is the data type, and the value is the data itself.

              For more information, see Data Types in the Amazon DynamoDB Developer Guide .

        • L (list) --

          An attribute of type List. For example:

          "L": [ {"S": "Cookies"} , {"S": "Coffee"}, {"N", "3.14159"}]

          • (dict) --

            Represents the data for an attribute.

            Each attribute value is described as a name-value pair. The name is the data type, and the value is the data itself.

            For more information, see Data Types in the Amazon DynamoDB Developer Guide .

        • NULL (boolean) --

          An attribute of type Null. For example:

          "NULL": true

        • BOOL (boolean) --

          An attribute of type Boolean. For example:

          "BOOL": true

    • ConsistentRead (boolean) --

      The read consistency of the PartiQL batch request.

type ReturnConsumedCapacity

string

param ReturnConsumedCapacity

Determines the level of detail about either provisioned or on-demand throughput consumption that is returned in the response:

  • INDEXES - The response includes the aggregate ConsumedCapacity for the operation, together with ConsumedCapacity for each table and secondary index that was accessed. Note that some operations, such as GetItem and BatchGetItem , do not access any indexes at all. In these cases, specifying INDEXES will only return ConsumedCapacity information for table(s).

  • TOTAL - The response includes only the aggregate ConsumedCapacity for the operation.

  • NONE - No ConsumedCapacity details are included in the response.

rtype

dict

returns

Response Syntax

{
    'Responses': [
        {
            'Error': {
                'Code': 'ConditionalCheckFailed'|'ItemCollectionSizeLimitExceeded'|'RequestLimitExceeded'|'ValidationError'|'ProvisionedThroughputExceeded'|'TransactionConflict'|'ThrottlingError'|'InternalServerError'|'ResourceNotFound'|'AccessDenied'|'DuplicateItem',
                'Message': 'string'
            },
            'TableName': 'string',
            'Item': {
                'string': {
                    'S': 'string',
                    'N': 'string',
                    'B': b'bytes',
                    'SS': [
                        'string',
                    ],
                    'NS': [
                        'string',
                    ],
                    'BS': [
                        b'bytes',
                    ],
                    'M': {
                        'string': {'... recursive ...'}
                    },
                    'L': [
                        {'... recursive ...'},
                    ],
                    'NULL': True|False,
                    'BOOL': True|False
                }
            }
        },
    ],
    'ConsumedCapacity': [
        {
            'TableName': 'string',
            'CapacityUnits': 123.0,
            'ReadCapacityUnits': 123.0,
            'WriteCapacityUnits': 123.0,
            'Table': {
                'ReadCapacityUnits': 123.0,
                'WriteCapacityUnits': 123.0,
                'CapacityUnits': 123.0
            },
            'LocalSecondaryIndexes': {
                'string': {
                    'ReadCapacityUnits': 123.0,
                    'WriteCapacityUnits': 123.0,
                    'CapacityUnits': 123.0
                }
            },
            'GlobalSecondaryIndexes': {
                'string': {
                    'ReadCapacityUnits': 123.0,
                    'WriteCapacityUnits': 123.0,
                    'CapacityUnits': 123.0
                }
            }
        },
    ]
}

Response Structure

  • (dict) --

    • Responses (list) --

      The response to each PartiQL statement in the batch.

      • (dict) --

        A PartiQL batch statement response..

        • Error (dict) --

          The error associated with a failed PartiQL batch statement.

          • Code (string) --

            The error code associated with the failed PartiQL batch statement.

          • Message (string) --

            The error message associated with the PartiQL batch resposne.

        • TableName (string) --

          The table name associated with a failed PartiQL batch statement.

        • Item (dict) --

          A DynamoDB item associated with a BatchStatementResponse

          • (string) --

            • (dict) --

              Represents the data for an attribute.

              Each attribute value is described as a name-value pair. The name is the data type, and the value is the data itself.

              For more information, see Data Types in the Amazon DynamoDB Developer Guide .

              • S (string) --

                An attribute of type String. For example:

                "S": "Hello"

              • N (string) --

                An attribute of type Number. For example:

                "N": "123.45"

                Numbers are sent across the network to DynamoDB as strings, to maximize compatibility across languages and libraries. However, DynamoDB treats them as number type attributes for mathematical operations.

              • B (bytes) --

                An attribute of type Binary. For example:

                "B": "dGhpcyB0ZXh0IGlzIGJhc2U2NC1lbmNvZGVk"

              • SS (list) --

                An attribute of type String Set. For example:

                "SS": ["Giraffe", "Hippo" ,"Zebra"]

                • (string) --

              • NS (list) --

                An attribute of type Number Set. For example:

                "NS": ["42.2", "-19", "7.5", "3.14"]

                Numbers are sent across the network to DynamoDB as strings, to maximize compatibility across languages and libraries. However, DynamoDB treats them as number type attributes for mathematical operations.

                • (string) --

              • BS (list) --

                An attribute of type Binary Set. For example:

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

                • (bytes) --

              • M (dict) --

                An attribute of type Map. For example:

                "M": {"Name": {"S": "Joe"}, "Age": {"N": "35"}}

                • (string) --

                  • (dict) --

                    Represents the data for an attribute.

                    Each attribute value is described as a name-value pair. The name is the data type, and the value is the data itself.

                    For more information, see Data Types in the Amazon DynamoDB Developer Guide .

              • L (list) --

                An attribute of type List. For example:

                "L": [ {"S": "Cookies"} , {"S": "Coffee"}, {"N", "3.14159"}]

                • (dict) --

                  Represents the data for an attribute.

                  Each attribute value is described as a name-value pair. The name is the data type, and the value is the data itself.

                  For more information, see Data Types in the Amazon DynamoDB Developer Guide .

              • NULL (boolean) --

                An attribute of type Null. For example:

                "NULL": true

              • BOOL (boolean) --

                An attribute of type Boolean. For example:

                "BOOL": true

    • ConsumedCapacity (list) --

      The capacity units consumed by the entire operation. The values of the list are ordered according to the ordering of the statements.

      • (dict) --

        The capacity units consumed by an operation. The data returned includes the total provisioned throughput consumed, along with statistics for the table and any indexes involved in the operation. ConsumedCapacity is only returned if the request asked for it. For more information, see Provisioned Throughput in the Amazon DynamoDB Developer Guide .

        • TableName (string) --

          The name of the table that was affected by the operation.

        • CapacityUnits (float) --

          The total number of capacity units consumed by the operation.

        • ReadCapacityUnits (float) --

          The total number of read capacity units consumed by the operation.

        • WriteCapacityUnits (float) --

          The total number of write capacity units consumed by the operation.

        • Table (dict) --

          The amount of throughput consumed on the table affected by the operation.

          • ReadCapacityUnits (float) --

            The total number of read capacity units consumed on a table or an index.

          • WriteCapacityUnits (float) --

            The total number of write capacity units consumed on a table or an index.

          • CapacityUnits (float) --

            The total number of capacity units consumed on a table or an index.

        • LocalSecondaryIndexes (dict) --

          The amount of throughput consumed on each local index affected by the operation.

          • (string) --

            • (dict) --

              Represents the amount of provisioned throughput capacity consumed on a table or an index.

              • ReadCapacityUnits (float) --

                The total number of read capacity units consumed on a table or an index.

              • WriteCapacityUnits (float) --

                The total number of write capacity units consumed on a table or an index.

              • CapacityUnits (float) --

                The total number of capacity units consumed on a table or an index.

        • GlobalSecondaryIndexes (dict) --

          The amount of throughput consumed on each global index affected by the operation.

          • (string) --

            • (dict) --

              Represents the amount of provisioned throughput capacity consumed on a table or an index.

              • ReadCapacityUnits (float) --

                The total number of read capacity units consumed on a table or an index.

              • WriteCapacityUnits (float) --

                The total number of write capacity units consumed on a table or an index.

              • CapacityUnits (float) --

                The total number of capacity units consumed on a table or an index.

ExecuteStatement (updated) Link ¶
Changes (request, response)
Request
{'ReturnConsumedCapacity': 'INDEXES | TOTAL | NONE'}
Response
{'ConsumedCapacity': {'CapacityUnits': 'double',
                      'GlobalSecondaryIndexes': {'string': {'CapacityUnits': 'double',
                                                            'ReadCapacityUnits': 'double',
                                                            'WriteCapacityUnits': 'double'}},
                      'LocalSecondaryIndexes': {'string': {'CapacityUnits': 'double',
                                                           'ReadCapacityUnits': 'double',
                                                           'WriteCapacityUnits': 'double'}},
                      'ReadCapacityUnits': 'double',
                      'Table': {'CapacityUnits': 'double',
                                'ReadCapacityUnits': 'double',
                                'WriteCapacityUnits': 'double'},
                      'TableName': 'string',
                      'WriteCapacityUnits': 'double'}}

This operation allows you to perform reads and singleton writes on data stored in DynamoDB, using PartiQL.

See also: AWS API Documentation

Request Syntax

client.execute_statement(
    Statement='string',
    Parameters=[
        {
            'S': 'string',
            'N': 'string',
            'B': b'bytes',
            'SS': [
                'string',
            ],
            'NS': [
                'string',
            ],
            'BS': [
                b'bytes',
            ],
            'M': {
                'string': {'... recursive ...'}
            },
            'L': [
                {'... recursive ...'},
            ],
            'NULL': True|False,
            'BOOL': True|False
        },
    ],
    ConsistentRead=True|False,
    NextToken='string',
    ReturnConsumedCapacity='INDEXES'|'TOTAL'|'NONE'
)
type Statement

string

param Statement

[REQUIRED]

The PartiQL statement representing the operation to run.

type Parameters

list

param Parameters

The parameters for the PartiQL statement, if any.

  • (dict) --

    Represents the data for an attribute.

    Each attribute value is described as a name-value pair. The name is the data type, and the value is the data itself.

    For more information, see Data Types in the Amazon DynamoDB Developer Guide .

    • S (string) --

      An attribute of type String. For example:

      "S": "Hello"

    • N (string) --

      An attribute of type Number. For example:

      "N": "123.45"

      Numbers are sent across the network to DynamoDB as strings, to maximize compatibility across languages and libraries. However, DynamoDB treats them as number type attributes for mathematical operations.

    • B (bytes) --

      An attribute of type Binary. For example:

      "B": "dGhpcyB0ZXh0IGlzIGJhc2U2NC1lbmNvZGVk"

    • SS (list) --

      An attribute of type String Set. For example:

      "SS": ["Giraffe", "Hippo" ,"Zebra"]

      • (string) --

    • NS (list) --

      An attribute of type Number Set. For example:

      "NS": ["42.2", "-19", "7.5", "3.14"]

      Numbers are sent across the network to DynamoDB as strings, to maximize compatibility across languages and libraries. However, DynamoDB treats them as number type attributes for mathematical operations.

      • (string) --

    • BS (list) --

      An attribute of type Binary Set. For example:

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

      • (bytes) --

    • M (dict) --

      An attribute of type Map. For example:

      "M": {"Name": {"S": "Joe"}, "Age": {"N": "35"}}

      • (string) --

        • (dict) --

          Represents the data for an attribute.

          Each attribute value is described as a name-value pair. The name is the data type, and the value is the data itself.

          For more information, see Data Types in the Amazon DynamoDB Developer Guide .

    • L (list) --

      An attribute of type List. For example:

      "L": [ {"S": "Cookies"} , {"S": "Coffee"}, {"N", "3.14159"}]

      • (dict) --

        Represents the data for an attribute.

        Each attribute value is described as a name-value pair. The name is the data type, and the value is the data itself.

        For more information, see Data Types in the Amazon DynamoDB Developer Guide .

    • NULL (boolean) --

      An attribute of type Null. For example:

      "NULL": true

    • BOOL (boolean) --

      An attribute of type Boolean. For example:

      "BOOL": true

type ConsistentRead

boolean

param ConsistentRead

The consistency of a read operation. If set to true , then a strongly consistent read is used; otherwise, an eventually consistent read is used.

type NextToken

string

param NextToken

Set this value to get remaining results, if NextToken was returned in the statement response.

type ReturnConsumedCapacity

string

param ReturnConsumedCapacity

Determines the level of detail about either provisioned or on-demand throughput consumption that is returned in the response:

  • INDEXES - The response includes the aggregate ConsumedCapacity for the operation, together with ConsumedCapacity for each table and secondary index that was accessed. Note that some operations, such as GetItem and BatchGetItem , do not access any indexes at all. In these cases, specifying INDEXES will only return ConsumedCapacity information for table(s).

  • TOTAL - The response includes only the aggregate ConsumedCapacity for the operation.

  • NONE - No ConsumedCapacity details are included in the response.

rtype

dict

returns

Response Syntax

{
    'Items': [
        {
            'string': {
                'S': 'string',
                'N': 'string',
                'B': b'bytes',
                'SS': [
                    'string',
                ],
                'NS': [
                    'string',
                ],
                'BS': [
                    b'bytes',
                ],
                'M': {
                    'string': {'... recursive ...'}
                },
                'L': [
                    {'... recursive ...'},
                ],
                'NULL': True|False,
                'BOOL': True|False
            }
        },
    ],
    'NextToken': 'string',
    'ConsumedCapacity': {
        'TableName': 'string',
        'CapacityUnits': 123.0,
        'ReadCapacityUnits': 123.0,
        'WriteCapacityUnits': 123.0,
        'Table': {
            'ReadCapacityUnits': 123.0,
            'WriteCapacityUnits': 123.0,
            'CapacityUnits': 123.0
        },
        'LocalSecondaryIndexes': {
            'string': {
                'ReadCapacityUnits': 123.0,
                'WriteCapacityUnits': 123.0,
                'CapacityUnits': 123.0
            }
        },
        'GlobalSecondaryIndexes': {
            'string': {
                'ReadCapacityUnits': 123.0,
                'WriteCapacityUnits': 123.0,
                'CapacityUnits': 123.0
            }
        }
    }
}

Response Structure

  • (dict) --

    • Items (list) --

      If a read operation was used, this property will contain the result of the read operation; a map of attribute names and their values. For the write operations this value will be empty.

      • (dict) --

        • (string) --

          • (dict) --

            Represents the data for an attribute.

            Each attribute value is described as a name-value pair. The name is the data type, and the value is the data itself.

            For more information, see Data Types in the Amazon DynamoDB Developer Guide .

            • S (string) --

              An attribute of type String. For example:

              "S": "Hello"

            • N (string) --

              An attribute of type Number. For example:

              "N": "123.45"

              Numbers are sent across the network to DynamoDB as strings, to maximize compatibility across languages and libraries. However, DynamoDB treats them as number type attributes for mathematical operations.

            • B (bytes) --

              An attribute of type Binary. For example:

              "B": "dGhpcyB0ZXh0IGlzIGJhc2U2NC1lbmNvZGVk"

            • SS (list) --

              An attribute of type String Set. For example:

              "SS": ["Giraffe", "Hippo" ,"Zebra"]

              • (string) --

            • NS (list) --

              An attribute of type Number Set. For example:

              "NS": ["42.2", "-19", "7.5", "3.14"]

              Numbers are sent across the network to DynamoDB as strings, to maximize compatibility across languages and libraries. However, DynamoDB treats them as number type attributes for mathematical operations.

              • (string) --

            • BS (list) --

              An attribute of type Binary Set. For example:

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

              • (bytes) --

            • M (dict) --

              An attribute of type Map. For example:

              "M": {"Name": {"S": "Joe"}, "Age": {"N": "35"}}

              • (string) --

                • (dict) --

                  Represents the data for an attribute.

                  Each attribute value is described as a name-value pair. The name is the data type, and the value is the data itself.

                  For more information, see Data Types in the Amazon DynamoDB Developer Guide .

            • L (list) --

              An attribute of type List. For example:

              "L": [ {"S": "Cookies"} , {"S": "Coffee"}, {"N", "3.14159"}]

              • (dict) --

                Represents the data for an attribute.

                Each attribute value is described as a name-value pair. The name is the data type, and the value is the data itself.

                For more information, see Data Types in the Amazon DynamoDB Developer Guide .

            • NULL (boolean) --

              An attribute of type Null. For example:

              "NULL": true

            • BOOL (boolean) --

              An attribute of type Boolean. For example:

              "BOOL": true

    • NextToken (string) --

      If the response of a read request exceeds the response payload limit DynamoDB will set this value in the response. If set, you can use that this value in the subsequent request to get the remaining results.

    • ConsumedCapacity (dict) --

      The capacity units consumed by an operation. The data returned includes the total provisioned throughput consumed, along with statistics for the table and any indexes involved in the operation. ConsumedCapacity is only returned if the request asked for it. For more information, see Provisioned Throughput in the Amazon DynamoDB Developer Guide .

      • TableName (string) --

        The name of the table that was affected by the operation.

      • CapacityUnits (float) --

        The total number of capacity units consumed by the operation.

      • ReadCapacityUnits (float) --

        The total number of read capacity units consumed by the operation.

      • WriteCapacityUnits (float) --

        The total number of write capacity units consumed by the operation.

      • Table (dict) --

        The amount of throughput consumed on the table affected by the operation.

        • ReadCapacityUnits (float) --

          The total number of read capacity units consumed on a table or an index.

        • WriteCapacityUnits (float) --

          The total number of write capacity units consumed on a table or an index.

        • CapacityUnits (float) --

          The total number of capacity units consumed on a table or an index.

      • LocalSecondaryIndexes (dict) --

        The amount of throughput consumed on each local index affected by the operation.

        • (string) --

          • (dict) --

            Represents the amount of provisioned throughput capacity consumed on a table or an index.

            • ReadCapacityUnits (float) --

              The total number of read capacity units consumed on a table or an index.

            • WriteCapacityUnits (float) --

              The total number of write capacity units consumed on a table or an index.

            • CapacityUnits (float) --

              The total number of capacity units consumed on a table or an index.

      • GlobalSecondaryIndexes (dict) --

        The amount of throughput consumed on each global index affected by the operation.

        • (string) --

          • (dict) --

            Represents the amount of provisioned throughput capacity consumed on a table or an index.

            • ReadCapacityUnits (float) --

              The total number of read capacity units consumed on a table or an index.

            • WriteCapacityUnits (float) --

              The total number of write capacity units consumed on a table or an index.

            • CapacityUnits (float) --

              The total number of capacity units consumed on a table or an index.

ExecuteTransaction (updated) Link ¶
Changes (request, response)
Request
{'ReturnConsumedCapacity': 'INDEXES | TOTAL | NONE'}
Response
{'ConsumedCapacity': [{'CapacityUnits': 'double',
                       'GlobalSecondaryIndexes': {'string': {'CapacityUnits': 'double',
                                                             'ReadCapacityUnits': 'double',
                                                             'WriteCapacityUnits': 'double'}},
                       'LocalSecondaryIndexes': {'string': {'CapacityUnits': 'double',
                                                            'ReadCapacityUnits': 'double',
                                                            'WriteCapacityUnits': 'double'}},
                       'ReadCapacityUnits': 'double',
                       'Table': {'CapacityUnits': 'double',
                                 'ReadCapacityUnits': 'double',
                                 'WriteCapacityUnits': 'double'},
                       'TableName': 'string',
                       'WriteCapacityUnits': 'double'}]}

This operation allows you to perform transactional reads or writes on data stored in DynamoDB, using PartiQL.

Note

The entire transaction must consist of either read statements or write statements, you cannot mix both in one transaction. The EXISTS function is an exception and can be used to check the condition of specific attributes of the item in a similar manner to ConditionCheck in the TransactWriteItems API.

See also: AWS API Documentation

Request Syntax

client.execute_transaction(
    TransactStatements=[
        {
            'Statement': 'string',
            'Parameters': [
                {
                    'S': 'string',
                    'N': 'string',
                    'B': b'bytes',
                    'SS': [
                        'string',
                    ],
                    'NS': [
                        'string',
                    ],
                    'BS': [
                        b'bytes',
                    ],
                    'M': {
                        'string': {'... recursive ...'}
                    },
                    'L': [
                        {'... recursive ...'},
                    ],
                    'NULL': True|False,
                    'BOOL': True|False
                },
            ]
        },
    ],
    ClientRequestToken='string',
    ReturnConsumedCapacity='INDEXES'|'TOTAL'|'NONE'
)
type TransactStatements

list

param TransactStatements

[REQUIRED]

The list of PartiQL statements representing the transaction to run.

  • (dict) --

    Represents a PartiQL statment that uses parameters.

    • Statement (string) -- [REQUIRED]

      A PartiQL statment that uses parameters.

    • Parameters (list) --

      The parameter values.

      • (dict) --

        Represents the data for an attribute.

        Each attribute value is described as a name-value pair. The name is the data type, and the value is the data itself.

        For more information, see Data Types in the Amazon DynamoDB Developer Guide .

        • S (string) --

          An attribute of type String. For example:

          "S": "Hello"

        • N (string) --

          An attribute of type Number. For example:

          "N": "123.45"

          Numbers are sent across the network to DynamoDB as strings, to maximize compatibility across languages and libraries. However, DynamoDB treats them as number type attributes for mathematical operations.

        • B (bytes) --

          An attribute of type Binary. For example:

          "B": "dGhpcyB0ZXh0IGlzIGJhc2U2NC1lbmNvZGVk"

        • SS (list) --

          An attribute of type String Set. For example:

          "SS": ["Giraffe", "Hippo" ,"Zebra"]

          • (string) --

        • NS (list) --

          An attribute of type Number Set. For example:

          "NS": ["42.2", "-19", "7.5", "3.14"]

          Numbers are sent across the network to DynamoDB as strings, to maximize compatibility across languages and libraries. However, DynamoDB treats them as number type attributes for mathematical operations.

          • (string) --

        • BS (list) --

          An attribute of type Binary Set. For example:

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

          • (bytes) --

        • M (dict) --

          An attribute of type Map. For example:

          "M": {"Name": {"S": "Joe"}, "Age": {"N": "35"}}

          • (string) --

            • (dict) --

              Represents the data for an attribute.

              Each attribute value is described as a name-value pair. The name is the data type, and the value is the data itself.

              For more information, see Data Types in the Amazon DynamoDB Developer Guide .

        • L (list) --

          An attribute of type List. For example:

          "L": [ {"S": "Cookies"} , {"S": "Coffee"}, {"N", "3.14159"}]

          • (dict) --

            Represents the data for an attribute.

            Each attribute value is described as a name-value pair. The name is the data type, and the value is the data itself.

            For more information, see Data Types in the Amazon DynamoDB Developer Guide .

        • NULL (boolean) --

          An attribute of type Null. For example:

          "NULL": true

        • BOOL (boolean) --

          An attribute of type Boolean. For example:

          "BOOL": true

type ClientRequestToken

string

param ClientRequestToken

Set this value to get remaining results, if NextToken was returned in the statement response.

This field is autopopulated if not provided.

type ReturnConsumedCapacity

string

param ReturnConsumedCapacity

Determines the level of detail about either provisioned or on-demand throughput consumption that is returned in the response. For more information, see TransactGetItems and TransactWriteItems.

rtype

dict

returns

Response Syntax

{
    'Responses': [
        {
            'Item': {
                'string': {
                    'S': 'string',
                    'N': 'string',
                    'B': b'bytes',
                    'SS': [
                        'string',
                    ],
                    'NS': [
                        'string',
                    ],
                    'BS': [
                        b'bytes',
                    ],
                    'M': {
                        'string': {'... recursive ...'}
                    },
                    'L': [
                        {'... recursive ...'},
                    ],
                    'NULL': True|False,
                    'BOOL': True|False
                }
            }
        },
    ],
    'ConsumedCapacity': [
        {
            'TableName': 'string',
            'CapacityUnits': 123.0,
            'ReadCapacityUnits': 123.0,
            'WriteCapacityUnits': 123.0,
            'Table': {
                'ReadCapacityUnits': 123.0,
                'WriteCapacityUnits': 123.0,
                'CapacityUnits': 123.0
            },
            'LocalSecondaryIndexes': {
                'string': {
                    'ReadCapacityUnits': 123.0,
                    'WriteCapacityUnits': 123.0,
                    'CapacityUnits': 123.0
                }
            },
            'GlobalSecondaryIndexes': {
                'string': {
                    'ReadCapacityUnits': 123.0,
                    'WriteCapacityUnits': 123.0,
                    'CapacityUnits': 123.0
                }
            }
        },
    ]
}

Response Structure

  • (dict) --

    • Responses (list) --

      The response to a PartiQL transaction.

      • (dict) --

        Details for the requested item.

        • Item (dict) --

          Map of attribute data consisting of the data type and attribute value.

          • (string) --

            • (dict) --

              Represents the data for an attribute.

              Each attribute value is described as a name-value pair. The name is the data type, and the value is the data itself.

              For more information, see Data Types in the Amazon DynamoDB Developer Guide .

              • S (string) --

                An attribute of type String. For example:

                "S": "Hello"

              • N (string) --

                An attribute of type Number. For example:

                "N": "123.45"

                Numbers are sent across the network to DynamoDB as strings, to maximize compatibility across languages and libraries. However, DynamoDB treats them as number type attributes for mathematical operations.

              • B (bytes) --

                An attribute of type Binary. For example:

                "B": "dGhpcyB0ZXh0IGlzIGJhc2U2NC1lbmNvZGVk"

              • SS (list) --

                An attribute of type String Set. For example:

                "SS": ["Giraffe", "Hippo" ,"Zebra"]

                • (string) --

              • NS (list) --

                An attribute of type Number Set. For example:

                "NS": ["42.2", "-19", "7.5", "3.14"]

                Numbers are sent across the network to DynamoDB as strings, to maximize compatibility across languages and libraries. However, DynamoDB treats them as number type attributes for mathematical operations.

                • (string) --

              • BS (list) --

                An attribute of type Binary Set. For example:

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

                • (bytes) --

              • M (dict) --

                An attribute of type Map. For example:

                "M": {"Name": {"S": "Joe"}, "Age": {"N": "35"}}

                • (string) --

                  • (dict) --

                    Represents the data for an attribute.

                    Each attribute value is described as a name-value pair. The name is the data type, and the value is the data itself.

                    For more information, see Data Types in the Amazon DynamoDB Developer Guide .

              • L (list) --

                An attribute of type List. For example:

                "L": [ {"S": "Cookies"} , {"S": "Coffee"}, {"N", "3.14159"}]

                • (dict) --

                  Represents the data for an attribute.

                  Each attribute value is described as a name-value pair. The name is the data type, and the value is the data itself.

                  For more information, see Data Types in the Amazon DynamoDB Developer Guide .

              • NULL (boolean) --

                An attribute of type Null. For example:

                "NULL": true

              • BOOL (boolean) --

                An attribute of type Boolean. For example:

                "BOOL": true

    • ConsumedCapacity (list) --

      The capacity units consumed by the entire operation. The values of the list are ordered according to the ordering of the statements.

      • (dict) --

        The capacity units consumed by an operation. The data returned includes the total provisioned throughput consumed, along with statistics for the table and any indexes involved in the operation. ConsumedCapacity is only returned if the request asked for it. For more information, see Provisioned Throughput in the Amazon DynamoDB Developer Guide .

        • TableName (string) --

          The name of the table that was affected by the operation.

        • CapacityUnits (float) --

          The total number of capacity units consumed by the operation.

        • ReadCapacityUnits (float) --

          The total number of read capacity units consumed by the operation.

        • WriteCapacityUnits (float) --

          The total number of write capacity units consumed by the operation.

        • Table (dict) --

          The amount of throughput consumed on the table affected by the operation.

          • ReadCapacityUnits (float) --

            The total number of read capacity units consumed on a table or an index.

          • WriteCapacityUnits (float) --

            The total number of write capacity units consumed on a table or an index.

          • CapacityUnits (float) --

            The total number of capacity units consumed on a table or an index.

        • LocalSecondaryIndexes (dict) --

          The amount of throughput consumed on each local index affected by the operation.

          • (string) --

            • (dict) --

              Represents the amount of provisioned throughput capacity consumed on a table or an index.

              • ReadCapacityUnits (float) --

                The total number of read capacity units consumed on a table or an index.

              • WriteCapacityUnits (float) --

                The total number of write capacity units consumed on a table or an index.

              • CapacityUnits (float) --

                The total number of capacity units consumed on a table or an index.

        • GlobalSecondaryIndexes (dict) --

          The amount of throughput consumed on each global index affected by the operation.

          • (string) --

            • (dict) --

              Represents the amount of provisioned throughput capacity consumed on a table or an index.

              • ReadCapacityUnits (float) --

                The total number of read capacity units consumed on a table or an index.

              • WriteCapacityUnits (float) --

                The total number of write capacity units consumed on a table or an index.

              • CapacityUnits (float) --

                The total number of capacity units consumed on a table or an index.