PHP DynamoDB- Add/Update an value in the list

Question

I am trying to add more email address to the list. The architecture and the example in Dynamo DB

ID: STRING
DEP: MAP
    Contacts: MAP
        EMAIL: LIST
Version: Number
    

{
 “ID”: "1234567888",
 "Dep": {
            "Contacts": {
                   "Email": [
                            "[email protected]”
                            ]
                   }
           },
 "Version": 34
}

I tried but it just updates the value but don't add the new one. (if you can also help me with if the value does not exist than only add would be nice but not mandatory)

$eav = $marshaler->marshalItem([":email" => [$email]]);
$params = ['TableName' => "xxx", 'ID' => $key, 
        'UpdateExpression' => 'SET Dep.Contacts.Email = :email',
    'ExpressionAttributeValues' => $eav, 'ReturnValues' => 'UPDATED_NEW'];
                        
$result = $dynamodb->updateItem($params);

stackoverflow.com/questions/31288085/…

hunterhacker
– hunterhacker

2022-09-26 22:49:35 +00:00
Commented Sep 26, 2022 at 22:49 — hunterhacker
– hunterhacker, Commented Sep 26, 2022 at 22:49

Leeroy Hannigan · Accepted Answer · 2022-09-27 00:53:28Z

0

You should list_append to add an element to a list. CLI example below:

--update-expression "SET #ri = list_append(#ri, :vals)"

You can see this in the documentation here:

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Expressions.UpdateExpressions.html#Expressions.UpdateExpressions.SET.AddingListElements

answered Sep 27, 2022 at 0:53

Leeroy Hannigan

20.5k4 gold badges23 silver badges46 bronze badges

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

Collectives™ on Stack Overflow

PHP DynamoDB- Add/Update an value in the list

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