AWS Dynamodb - PartiQL

Question

Hi, 
i am using Dynamodb ExecuteStatement with Parameter attribute in nodejs.
I am dynamically passing string array to one of the column. But i am getting below error while executing. please suggest the fix.

InvalidParameterType: Expected params.Parameters[1].SS[0] to be a string

Code Snippet:

Parameters: [
        {
          S: 
          
        },
         { SS: [] // eg: l1,l2
        }

Answer

Statement: `
    UPDATE "lab_results"
      SET "notification_status"= 'Notified'
    WHERE "cerner_millennium_id" = ?
      AND "lab_result_id" IN ?

Reading a json request which is in below format and passing the same to the above query for updation.
{
    "cerner_millennium_id" : "1",
    "lab_result_id" : ["lr3","lr4"]
}

AWS Dynamodb - PartiQL

相关内容