Update array item in dynamoDB

Question

In my dynamoDB, I have a table that structure as like as given below:

 var params = {
      "TableName" : "pdfs",
      "Item" : {
          pdfid:  // Partition key
          html: [] // array attribute
       }
 };

I can insert new array data, just like as given code:

Insert array data

 var params = {
      "TableName" : "pdfs",
      "Item" : {
          pdfid: pdfid,
          html: [event.html]   // here "html" is an array, I just insert first array data
       }
 };

 dc.put(params, function(err, data) {
     ............................
 });

How can I update array in dynamoDB ?

  var params = {
      TableName: "pdfs",
      Key: {
         pdfid: event.pdfid
      },
      UpdateExpression: "SET html = :html",
      ExpressionAttributeValues: {
         ":html": ??????
      },
      ReturnValues: "ALL_NEW"
  };

If html is an array of Strings, then you should use StringSet data type, and then use ADD in the UpdateExpression — Conti
– Conti, Commented Jul 1, 2016 at 21:16

Alexander Patrikalakis · Accepted Answer · 2017-03-08 13:24:43Z

5

Use the following UpdateExpression to append values to a list: SET html = list_append(html, :html). The ExpressionAttributeValues would just be a mapping from :html to the string that you want to add.

answered Mar 8, 2017 at 13:24

Alexander Patrikalakis

5,2251 gold badge35 silver badges49 bronze badges

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

Comments

Anushri HV · Accepted Answer · 2021-01-17 16:54:38Z

0

Use the String Set attribute to update the list.

ExpressionAttributeValues: {
         ":html": {
              SS: aws.StringSlice(your_html_array)    
      }

answered Jan 17, 2021 at 16:54

Anushri HV

773 bronze badges

Collectives™ on Stack Overflow

Update array item in dynamoDB

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related