CODEWITHSUNDEEP
pythonamazon-web-servicesamazon-dynamodb
vboxer00
vboxer00

Reputation: 125

Write multiple items to DynamoDB table

I have the following list of dictionaries:

datalist = [
    {'Business': 'Business A', 'Category': 'IT', 'Title': 'IT Manager'},
    {'Business': 'Business A', 'Category': 'Sourcing', 'Title': 'Sourcing Manager'}
]

I would like to upload to DynamoDB in the following format:

table.put_item(Item={
                    'Business':'Business A would go here',
                    'Category':'IT would go here',
                    'Title':'IT Manager would go here'
                    },
                    {
                    'Business':'Business B would go here',
                    'Category':'Sourcing would go here',
                    'Title':'Sourcing Manager would go here'
                    }
               )

I've tried converting the list of dicts to dict first and accessing the elements that way or trying to iterate through the Items parameter but no luck. Any help would be appreciated.

Here's my DynamoDB structure, 3 columns (Business, Category, Title):

{
  "Business": {
    "S": "Business goes here"
  },
  "Category": {
    "S": "Category goes here"
  },
  "Title": {
    "S": "Title goes here"
  }
}

Upvotes: 1

Views: 9200

Answers (1)

Maurice
Maurice

Reputation: 13127

The put_item API call allows you to upload exactly one item, you're trying to upload two at the same time, this doesn't work.

You can batch multiple put items requests using boto3 to decrease the number of API calls. Here's an example adapted from the documentation:

with table.batch_writer() as batch:

    for item in datalist:

        batch.put_item(
            Item=item
        )

This will automatically create the batch writes under the hood.

Upvotes: 10

Related Questions