Dynamo DB + In put Item Request how to pass null value?

Question

I have one field which i have declared as string in the model as show below:

App.Student= DS.Model.extend({
name: DS.attr('string'),
address1: DS.attr('string'),
address2: DS.attr('string'),
city: DS.attr('string'),
state: DS.attr('string'),
postal: DS.attr('string'),
country: DS.attr('string'),
});

Here in the Edit mode when i update Adderess 2 field as null then below error comes:

"Failed to edit property: One or more parameter values were invalid: An AttributeValue may not contain an empty string"

I know this Error is generated because i am updating address 2 field as null and that what i want Address 2 field is not mandatory(One can pass data or can also left that column as blank")

Answer 1

AWS finally resolved this issue. DynamoDb now supports empty string values for non-key attributes: https://aws.amazon.com/about-aws/whats-new/2020/05/amazon-dynamodb-now-supports-empty-values-for-non-key-string-and-binary-attributes-in-dynamodb-tables/

Answer 2

If you are using DynamoDB (not DocumentClient) you can specify nulls like this

const putItem: PutItemInput = {
  TableName: `${process.env.PRIMARY_TABLE}`,
  Item: {
    key: { S: ${userId}` },
    someField: { NULL: true }
  }
}