Can't scan DynamoDb with multiple where conditions using Node JS

Question

AWS Documentation Sucks, I can't seem to get an idea of how to "scan" DynamoDb with two or more where conditions, in NodeJS ?

Here's my code

const AWS = require("aws-sdk");
let documentClient = new AWS.DynamoDB.DocumentClient();


module.exports.RetryIncompleteCSV = async (event, context, callback) => {
  console.log('In RetryIncompleteCSV');
  const cmpId = event.queryStringParameters.campaign;
  console.log('cmpId = ', cmpId);

  var params = {
    TableName : 'processed_csv_developments',
    FilterExpression : 'campaignId = :campaignId',
    ExpressionAttributeValues : {':campaignId' : cmpId}
  };

  let incompleteCsvData = await scanIncompleteProcessedCsv(params);

  console.log('incompleteCsvData = ', incompleteCsvData);
}

async function scanIncompleteProcessedCsv(params) {  // get method fetch data from dynamodb  
console.log(params)
  const queryExecute = await documentClient.scan(params, function(err, data) {
     if (err) console.log(err);
     else console.log(data);
     console.log('queryExecute=',queryExecute)
  });
}

I need scan to filter out data, based on following two conditions:

campaignId must be equal to the campaignId that I get from query params.
isComplete should be equal to false (Boolean)

The code written above neither give any error nor a success message. Attaching the cloudwatch logs screenshot below :

What am I missing. I looked at a lot of questions and tutorials, but nothing worked for me. Please Help!

Might I suggest you add a return statement to your scanIncompleteProcessedCsv() function? — Jens
– Jens, Commented Dec 17, 2020 at 20:28

hoangdv · Accepted Answer · 2020-12-18 01:29:36Z

1

scanIncompleteProcessedCsv should return a promise. Now it returns void, this mean RetryIncompleteCSV function will finish before a querying to dynamoDB complete.

async function scanIncompleteProcessedCsv(params) {  // get method fetch data from dynamodb  
console.log(params)
  return await documentClient.scan(params).promise();
}

About multiple conditions, I found to many documents about that, just try:

  var params = {
    TableName : 'processed_csv_developments',
    FilterExpression : 'campaignId = :campaignId AND isComplete = false',
    ExpressionAttributeValues : {':campaignId' : cmpId}
  };

Ref: Link

answered Dec 18, 2020 at 1:29

hoangdv

16.3k4 gold badges31 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

Can't scan DynamoDb with multiple where conditions using Node JS

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related