DynamoDB Json Formatting w/ Node.js with Lambda

Question

I've got an issue here with formatting my json and I can't quite figure out how to do it. when I run this code via Lambda:

  let body;
  let statusCode = 200;
  const headers = {
    "Content-Type": "application/json"
  };
body = await dynamo.scan({ TableName: "MyTutorials" }).promise();
body = JSON.stringify(body);

It returns as json string that looks like this:

{
    "Items": [
        {
            "published": false,
            "description": "This is an orange.",
            "id": 2,
            "title": "Orange"
        },
        {
            "published": true,
            "description": "this is an apple",
            "id": 1,
            "title": "Apple"
        }
    ],
    "Count": 2,
    "ScannedCount": 2
}

Thats great and all, but for my React app I need something cleaner that looks like this:

[
        {
            "published": false,
            "description": "This is an orange.",
            "id": 2,
            "title": "Orange"
        },
        {
            "published": true,
            "description": "this is an apple",
            "id": 1,
            "title": "Apple"
        }
    ]

Bascially, I need just the straight-up array in the json and not wrapped with all the other stuff like "Items" and "Count." Any ideas on how to make that call?

kevintechie · Accepted Answer · 2022-01-08 01:29:52Z

1

You just need to return the items of body:

body = JSON.stringify(body.Items);

answered Jan 8, 2022 at 1:29

kevintechie

1,5311 gold badge13 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

DynamoDB Json Formatting w/ Node.js with Lambda

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related