aws dynamodb import/export JSON format

Question

I have exported JSON files from aws dynamodb in this format:

[
  {
    "__typename": "Article",
<snip>
  }
<snip>
]

This results in "Invalid JSON" error:

aws dynamodb batch-write-item --request-items file://Article.json

Error parsing parameter '--request-items': Invalid JSON:

The correct format is (https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/SampleData.LoadData.html) How to export the DynamoDB so that I could easily import it to tables? Or is there anything I could do to transform the JSON files that I receive from third party?

Sri · Accepted Answer · 2022-08-28 06:16:54Z

1

The json seems to be invalid. you could use https://jsonlint.com/ to validate the JSON.

To import data to DynamoDB Table

aws dynamodb batch-write-item --request-items file://ProductCatalog.json
{
    "UnprocessedItems": {}
}

you could export data from DynamoDB using the following command

aws dynamodb scan --table-name ProductCatalog > ProductCatalog_export.json

DynamoDB can import data in three formats: CSV, DynamoDB JSON, and Amazon Ion.

answered Aug 28, 2022 at 6:16

Sri

4126 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1