Why is the ID property of this query result undefined?

Question

This code logs out [ { ID: 4 } ].

const result = await db.query(
  `SELECT ID FROM MetaData WHERE MintStatus='unminted' ORDER BY rand() LIMIT 1;`,
);

thisID = JSON.parse(JSON.stringify(result));
console.log(thisID[0]);

But if I do thisID[0].ID it returns undefined. Why?

Is `[ { ID: 4 } ]` the result of `thisID[0]` or of `thisID`? Arrays don’t have an `ID` property. — Sebastian Simon, Jul 26 '21 at 05:05
Does this answer your question? [How can I access and process nested objects, arrays or JSON?](https://stackoverflow.com/questions/11922383/how-can-i-access-and-process-nested-objects-arrays-or-json) — Sebastian Simon, Jul 26 '21 at 05:46

0brine · Accepted Answer · 2021-07-26T05:11:27.513

-2

If this console.log output is correct.

You can get the ID by writing thisID[0][0].ID

edited Jul 26 '21 at 05:11

answered Jul 26 '21 at 05:09

0brine

450
5
18

Why is the ID property of this query result undefined?

1 Answers1