Why does using ReturnValues: 'ALL_NEW' in a DynamoDB UpdateItem operation return a null ID?

Question

I am doing an update operation on a DynamoDB item using AWS AppSync GraphQL mutations and I want all the values of the item after the update operation returned via the API after a successful update.

The item updates perfectly fine & I've also specified the ReturnedValues attribute with ALL_NEW which should return all of the attributes however Item.Id is null for some reason?.

GraphQL:

type User {
    id: ID!
    name: String
    avatarUrl: String
    createdAt: String
    updatedAt: String
}

type Mutation {
    updateUser(userId: ID!, name: String, avatarUrl: String): User
}

mutation updateUser {
  updateUser(userId:"USER-14160000000", name:"Test Test", avatarUrl:"www.test.com") {
    id
    name
    avatarUrl
    createdAt
    updatedAt
  }
}

Lambda function which updates the item:

const AWS = require("aws-sdk")
AWS.config.update({ region: "ca-central-1" })
const dynamoDB = new AWS.DynamoDB.DocumentClient()

async function updateUser(userId, name, avatarUrl) {
  var params = {
    TableName: "Bol-Table",
    Key: {
      "pk": userId,
      "sk": 'USER',
    },
    UpdateExpression: 'SET details.displayName = :name, details.avatarUrl = :avatarUrl, details.updatedAt = :updateDate',
    ExpressionAttributeValues: {
      ':name': name,
      ':avatarUrl':avatarUrl,
      ':updateDate': new Date().toISOString()
    },

    ReturnValues: 'ALL_NEW'
  };
  const Item = await dynamoDB.update(params).promise();
  console.log(Item);
  return { 
      id: Item.pk, 
      name: Item.displayName,
      avatarUrl: Item.avatarUrl,
      createdAt: Item.createdAt,
      updatedAt: Item.updatedAt
  };
}
module.exports = updateUser;

GraphQL output from the updateUser call:

{
  "data": {
    "updateUser": null
  },
  "errors": [
    {
      "path": [
        "updateUser",
        "id"
      ],
      "locations": null,
      "message": "Cannot return null for non-nullable type: 'ID' within parent 'User' (/updateUser/id)"
    }
  ]
}

Output of console.log(Item) from Amazon CloudWatch:

2021-10-10T17:47:39.338Z    d06b7a58-541e-456f-b830-1a50eea7c35a    INFO    {
  Attributes: {
    sk: 'USER',
    details: {
      avatarUrl: 'www.test.com',
      createdAt: '2021-10-10T16:40:25.455Z',
      displayName: 'Test',
      updatedAt: '2021-10-10T17:47:38.586Z'
    },
    pk: 'USER-16040000000'
  }
}

Why am I receiving the error, Cannot return null for non-nullable type: 'ID' within parent 'User' (/updateUser/id)?

What is the output of `console.log(Item);`? `Item.pk` is probably null. — Ermiya Eskandary, Oct 10 '21 at 17:42
@ErmiyaEskandary I have added the result of console.log to the original post. — Sumchans, Oct 10 '21 at 17:49

Ermiya Eskandary · Accepted Answer · 2021-10-10T18:04:30.663

3

The AWS documentation for UpdateItem shows that the attribute values are returned in a nested Attributes object within the response.

{
   "Attributes": { 
      "string" : { 
         "B": blob,
         "BOOL": boolean,
         "BS": [ blob ],
         "L": [ 
            "AttributeValue"
         ],
         "M": { 
            "string" : "AttributeValue"
         },
         "N": "string",
         "NS": [ "string" ],
         "NULL": boolean,
         "S": "string",
         "SS": [ "string" ]
      }
   },
   ...
}

So you will need to access them using Item.Attributes, as opposed to trying to access them on Item as they don't exist at that level.

This should work:

return { 
  id: Item.Attributes.pk, 
  name: Item.Attributes.details.displayName,
  avatarUrl: Item.Attributes.details.avatarUrl,
  createdAt: Item.Attributes.details.createdAt,
  updatedAt: Item.Attributes.details.updatedAt
};

edited Oct 10 '21 at 18:04

answered Oct 10 '21 at 17:51

Ermiya Eskandary

15,323
3
31
44

Seriously I tried this, but for some reason it didn't work yesterday, it works now. The only issue is it returns null for the updatedAt field. – Sumchans Oct 10 '21 at 18:01
Double checking, isn't it supposed to be `Item.Attributes.details.avatarUrl`? Are you nesting the values in a `details` object? It used to be inside a `data` object last time :) – Ermiya Eskandary Oct 10 '21 at 18:02
Yes I tried it with details, this is the result { "data": { "updateUser": { "id": "USER-16040000000", "name": "Test", "avatarUrl": "www.test.com", "createdAt": "2021-10-10T16:40:25.455Z", "updatedAt": null } } } – Sumchans Oct 10 '21 at 18:04
1

No it is not. It should be having a value like created At – Sumchans Oct 10 '21 at 18:08
@Sumchans Is `Item.Attributes.details.updatedAt` null? – Ermiya Eskandary Oct 10 '21 at 18:10
1

my mistake, I had a field level resolver attached to updatedAt, I removed it, it is working now. – Sumchans Oct 10 '21 at 18:42
1

Thanks Ermiya, really appreciate the help. – Sumchans Oct 10 '21 at 18:43
@Sumchans No worries, happy to help! – Ermiya Eskandary Oct 10 '21 at 18:44

Why does using ReturnValues: 'ALL_NEW' in a DynamoDB UpdateItem operation return a null ID?

1 Answers1