DynamoDB Array of String becomes Array of Objects

Question

I insert an array of string to DynamoDB:

[13, 12, 12, 4]

It becomes Array of Objects when I view it in DynamoDB:

[ { "S" : "13" }, { "S" : "12" }, { "S" : "12" }, { "S" : "4" }]

Is it reasonable? Do I need to do something to make my data being inserted as array of string?

Here is how I put my array to DynamoDB:

var params = {
   TableName: "MatchDate",
   Item:{
      position: [1, 3, 4, 5]
   }
};

DynamoDBClient.put(params, function(err, data) {
   //Some other code
});

F_SO_K · Accepted Answer · 2017-12-04 16:11:27Z

6

If you want a single object (an array of strings) you need to set your attribute type to String Set

Then you will get

"SS": ["13", "12" ,"12", "4"]

Or you can use Number Set

"NS": ["13", "12" ,"12", "4"]

EDIT: Try something like this in nodejs

var params = {
   TableName: "MatchDate",
   Item: {
   "position": {
      SS: [
         '12',
         '13',
         '4'
      ]
   }
};

DynamoDBClient.put(params, function(err, data) {
   //Some other code
});

Check here for AWS Refernce of Javascript putItem

edited Dec 4, 2017 at 16:11

answered Dec 4, 2017 at 15:39

F_SO_K

15k6 gold badges64 silver badges90 bronze badges

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

3 Comments

ykn121 Over a year ago

Where should I set this?

F_SO_K Over a year ago

If you post your existing putItem command I can give you a better answer. For now I have updated the answer with a generic example. I think your're using php right?

ykn121 Over a year ago

I have edited my post and included the command i written in nodejs.

Collectives™ on Stack Overflow

DynamoDB Array of String becomes Array of Objects

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related