dynamoDB - Get multiple items from DB by array of primary keys

Question

I have an array of users id's and I want to get all users with that id from the dynamoDB table

Didn't find it in the documentation

any ideas?

Answer 1

I ended up using batchGet, an operation of AWS.DynamoDB.DocumentClient

There's no support for multiple items with same key, so I have to define the key over and over again like this:

var dynamoConfig = {
  sessionToken:    process.env.AWS_SESSION_TOKEN,
  region:          process.env.AWS_REGION
};
var dynamodbDocClient = new AWS.DynamoDB.DocumentClient(dynamoConfig);

var params = {
  RequestItems: {
    tableName: {
      Keys: [
        {
          id: 'user1Id'
        },
        {
          id: 'user2Id'
        },
        {
          id: 'user3Id'
        }
      ]
    }
  }
}

dynamodbDocClient.batchGet(paramsForQueringFormerEvaluators, function(err, data) {
  if (err) {
    console.log('createEvaluation: get former evaluators: err: ', err);
    return;
  }

  var users = data.Responses.tableName;
  console.log('createEvaluation: get former evaluators: ', users);

});

Answer 2

You can use the BatchGetItem API for this.

Of course, I can't help you with any code snippet without knowing your table schema. But you can look at the documentation here.