Javascript / Node - Convert json stored as text in DB to JSON object

Question

I've been banging my head against a wall with this all day, I've looked at other questions and they all say use JSON.parse or something similar, but I can't get anything to work for the life of me.

I have an object stored as text in a PostGres DB:

{149804: [75319, 2887526, 2938701],3136977: [3482061,3482062]}

I have to read it into a variable and go through it's properties but i can't get it to work, if I do a JSON.parse I get a "SyntaxError: Unexpected number" on the first number {1...}.

I tried looking at the object properties without doing a parse to test it, but it keeps saying it doesn't have that property (with and without ' around the number in case):

if(selectedItems.hasOwnProperty(149804)){
    console.log("HAS 149804");
}else{
    console.log("DOESN'T HAVE 149804");
};

What am I doing wrong here?

You data might already be in JSON/object format. You can confirm by console.log the variable or console.log(typeof VARIABLE_NAME). — Will
– Will, Commented Dec 23, 2015 at 0:27
you can eval(0|| ... ) it instead of JSON.parse(...), but it will be slightly slower. if you don't fill the database, then be careful using eval. you can probably also use a RegExp to "fix" the JSON into something that can be parse()ed. — dandavis
– dandavis, Commented Dec 23, 2015 at 1:59

NGPixel · Accepted Answer · 2015-12-23 00:29:49Z

2

That's because your JSON is invalid.

{149804: [75319, 2887526, 2938701],3136977: [3482061,3482062]}

should instead be

{"149804": [75319, 2887526, 2938701],"3136977": [3482061,3482062]}

Then JSON.parse will work. Object properties should be strings, not numbers.

answered Dec 23, 2015 at 0:29

NGPixel

3903 silver badges9 bronze badges

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

Comments

Hatchet · Accepted Answer · 2015-12-23 00:30:05Z

1

A key name/index in JSON must be a string. Proper JSON would be:

{
  "149804": [
    75319,
    2887526,
    2938701
  ],
  "3136977": [
    3482061,
    3482062
  ]
}

answered Dec 23, 2015 at 0:30

Hatchet

5,4161 gold badge35 silver badges43 bronze badges

Collectives™ on Stack Overflow

Javascript / Node - Convert json stored as text in DB to JSON object

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related