从dynamoDB项中删除嵌套属性-Node.js [英] Remove nested attributes from dynamoDB Items - nodejs

问题描述

我在dynamodb中有一个项目

I have a single item in dynamodb

{
    "id": "123",
    "201907240815": {
        "userid1": {
            "name": "Hello",
            "email": "[e-mail]"
        },
        "userid2": {
            "name": "World",
            "email": "[e-mail]"
        }
    }
}

我需要删除嵌套属性。例如： 201907240815.userid1 。

I need to remove the nested attribute. ex:201907240815.userid1.

我不得不尝试下面的代码，但是没有用

I had to try below code but it not worked

const param = {
    TableName:'userinfo',
    Key:{id:'123'},
    UpdateExpression:'remove 201907240815.userid1',
    ReturnValues: 'UPDATED_NEW'
}
try{
const response = await dynamoDB.update(param).promise();
return response;
}catch(e){
return e;
}

无法删除该属性。我遇到了这个问题。

It could not be remove the attribute. I got this issue.

ValidationException: Invalid UpdateExpression: Syntax error; token: "201907240815", near: "remove 201907240815."

推荐答案

我认为删除应大写：删除

I think that 'remove' should be capitalized: 'REMOVE'

这篇关于从dynamoDB项中删除嵌套属性-Node.js的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！