AWS Dynamodb - PartiQL

0

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: <dynamic value 1>

    },
     { SS: [<dynamic value 2>] // eg: l1,l2
    }
  • Can you please write the query that you are trying to execute? and the table/object structure you are using?

asked 2 years ago469 views
1 Answer
0

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"] }

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions