Put Items using Json File in AWS DynamoDB using AWS CLI

Question

While putting below JSON in dynamo DB using AWS CLI with below command:

aws dynamodb put-item --table-name ScreenList --item file://tableName.json

I am getting Parameter validation failed Exception.I have gone rigorously through AWS docs but failed to find example to insert a complicated json.Every small help is welcome.

The updated Json :

{
  "itemName": {
    "S": "SCREEN_LIST"
  },
  "productName": {
    "S": "P2P_MOBITEL"
  },
  "screenList": {
    "L": [
      {
        "menu": {
          "L": [
            {
              "M": {
                "menuId": {
                  "N": "1"
                },
                "menuText": {
                  "S": "ENG_HEADING"
                },
                "menuType": {
                  "S": "Dynamic"
                }
              }
            }
          ]
        },
        "M": {
          "screenFooter": {
            "S": "F_LANGUAGE_CHANGE"
          },
          "screenHeader": {
            "S": "H_LANGUAGE_CHANGE"
          },
          "screenId": {
            "S": "LANGUAGE_CHANGE"
          },
          "screenType": {
            "S": ""
          }
        }
      }
    ]
  }
}

I've updated the answer, please take a look.

Ivan Mushketyk
– Ivan Mushketyk

2017-08-03 16:21:38 +00:00
Commented Aug 3, 2017 at 16:21 — Ivan Mushketyk
– Ivan Mushketyk, Commented Aug 3, 2017 at 16:21

Ivan Mushketyk · Accepted Answer · 2017-08-03 13:19:04Z

11

It seems that you are defining complex types incorrectly. According to AWS documentation you should define a list like this:

"L": ["Cookies", "Coffee", 3.14159]

and a map should be defined like this:

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

which means that a menu map should be defined like this:

"menu": { 
  "L": [
    {
      "M": {
        "menuId": {"N" :"1"},
        "menuText": {"S" :"PACKS_SCREEN"},
        "menuType": {"S" :"Dynamic"}
      }
    }
  ]
}

Notice the "M" and "L" attributes.

You should change the rest of your JSON in a similar fashion.

You can find full JSON definition here in the Options section.

UPDATE

Now your list definition is incorrect. You have:

   "screenList":{  
      "L":[  
         {  
            "menu":{ ... },
            "M":{ ... }
         }
      ]
   }

While it should be:

   "screenList":{  
      "L":[  
         {  
            "M":{ ... }   
         },
         {  
            "M":{ ... }   
         },
      ]
   }

edited Aug 3, 2017 at 13:19

answered Aug 3, 2017 at 11:00

Ivan Mushketyk

8,3359 gold badges55 silver badges69 bronze badges

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

5 Comments

Priancy Over a year ago

Again it says was parameter validation Exception...it says unknown parameter "menu".It should be must be one of :S,N,B,M,L.

Ivan Mushketyk Over a year ago

I am not sure if this is an issue with StackOverflow or with your JSON, but it does not pass JSON validation. Try to ensure that this is valid JSON first (e.g. you can use an online formatter: jsonformatter.org)

Ivan Mushketyk Over a year ago

Also, could you update JSON in your question? It's hard to read it in the comment section.

Priancy Over a year ago

It worked , but here I need name of map.The entries are added in the table along with the "L","M".I want to replace 2 maps "M","M" in List "L " with some name so that i can retrieve easily and my table becomes readable.

Ivan Mushketyk Over a year ago

You can have item names in a list. You can either make "screenList" a map (I guess it would be "screenMap" then), or you can store a nested map in a list something like [{"menu": {}, "else": {}}]. Mind that you need to convert this into DynamoDB format.

Collectives™ on Stack Overflow

Put Items using Json File in AWS DynamoDB using AWS CLI

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related