Update value in JSON object using NodeJS

Question

I've got a JSON object that's being submitted to a AWS Lambda NodeJS function. This JSON object has an apostrophe in one of the fields that I need to escape before it's being inserted into a MySQL database.

The object needs to stay intact as it's being stored as a JSON object in the database. I've looked at string replace functions but those won't work since this is a JSON object natively.

I'm sure there is a simple answer here, I'm just very new to NodeJS and haven't found a way after searching around for a few hours. Thanks in advance!

The field I need to update is 2.1 below:

Example of the BAD JSON Object:

{
  "field1": "ABCD1234DEFG4567",
  "field2": "FBI",
  "fieldgroup": {
    "1.1": "ABCD",
    "1.2": 20170721,
    "1.3": "ABCD",
    "2.1": "L'astName, FirstName M"
  }
}

Example of the FINAL JSON object:

{
  "field1": "ABCD1234DEFG4567",
  "field2": "FBI",
  "fieldgroup": {
    "1.1": "ABCD",
    "1.2": 20170721,
    "1.3": "ABCD",
    "2.1": "L''astName, FirstName M"
  }
}

You could convert the values to utf-8 and store it that way. npmjs.com/package/utf8 — Kyle Richardson
– Kyle Richardson, Commented Jul 21, 2017 at 19:58
To be pedantic, there is no 'JSON object', it's either JSON (unparsed -- a string) or a JS value (parsed -- an object, array, string, etc.). — mscdex
– mscdex, Commented Jul 21, 2017 at 20:38

alpinist · Accepted Answer · 2017-07-22 09:12:01Z

const o = {
    "field1": "ABCD1234DEFG4567",
    "field2": "FBI",
    "fieldgroup": {
        "1.1": "ABCD",
        "1.2": 20170721,
        "1.3": "ABCD",
        "2.1": "L'astName, FirstName M"
      }      
   };
   
const preparedObject = prepare(o);
console.log(JSON.stringify(preparedObject, null, 4));

function prepare(o) {
  const replacedStrings = Object.keys(o)
    .filter(key => typeof o[key] === "string")
    .reduce((accu, key) => ({ ...accu, [key]: o[key].replace("'", "''") }), {});
  const preparedChildren = Object.keys(o)
    .filter(key => typeof o[key] === "object")
    .reduce((accu, key) => ({ ...accu, [key]: prepare(o[key]) }), {});
  return { ...o, ...replacedStrings, ...preparedChildren };
}

peteb · Accepted Answer · 2017-07-21 20:25:34Z

2

If you're getting the value as JSON, do a string replace on the JSON and return back as an Object, this should work.

let escapeSingleQuotes = json => {
  return JSON.parse(json.replace(/'/, "''"))
}

If you want to remove the single quotes from a JS Object, its the same as above but, convert to a string first then go back to an object

let escapeSingleQuotes = obj => {
  return JSON.parse(JSON.stringify(obj).replace(/'/, "''"))
}

edited Jul 21, 2017 at 20:25

answered Jul 21, 2017 at 20:18

peteb

19.5k9 gold badges57 silver badges67 bronze badges

1 Comment

alpinist Over a year ago

Please use const for functions.

Collectives™ on Stack Overflow

Update value in JSON object using NodeJS

2 Answers 2

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Related