How to convert array string to JSON value?

Question

This string is received from database:

"[{\"country_code\":\"IN\",\"gdpr_fields\":{\"policy\":\"yes\",\"profiling\":\"na\",\"age\":\"yes\",\"subscription\":\"na\"}}]"

I have been trying to convert this string to a JSON value but it always ends up throwing an error

undefined:1
[{\"country_code\":\"IN\",\"gdpr_fields\":{\"policy\":\"yes\",\"profiling\":\"na\",\"age\":\"yes\",\"subscription\":\"na\"}}]
  ^
Unexpected token \ in JSON at position 2

Is there a way to convert this string to JSON using javascript?

Expected Result:

[{"country_code":"IN","gdpr_fields":{"policy":"yes","profiling":"na","age":"yes","subscription":"na"}}]

I have been trying to convert this string to a JSON value ... How? It looks like you are parsing JSON instead of stringifying it. — Jax-p
– Jax-p, Commented Jul 8, 2021 at 10:37
Why do you have a string like that in the first place? Can't you fix the issue with whatever's creating it? — Andy
– Andy, Commented Jul 8, 2021 at 10:39
is that string coming from database ? looks like you have double time json stringified it. — shyammakwana.me
– shyammakwana.me, Commented Jul 8, 2021 at 10:44
@ChrisG No, the string is not valid JSON. The backslashes are actual characters in the string. You can see it in the error message. They're not escape symbols. — user15388024
– user15388024, Commented Jul 8, 2021 at 11:31
@ChrisG I showed you a fiddle that proves that JSON.parse can't handle actual backslashes: jsfiddle.net/egm5vhtu Often databases are connected to many systems and it's not possible to fix all systems at once. A workaround is sometimes necessary. — user15388024
– user15388024, Commented Jul 8, 2021 at 11:46

user15388024 · Accepted Answer · 2021-07-08 11:25:30Z

1

You can replace all \" with " with replaceAll or replace with a regex (for older browsers/engines):

const invalidJson = '[{\\"country_code\\":\\"IN\\",\\"gdpr_fields\\":{\\"policy\\":\\"yes\\",\\"profiling\\":\\"na\\",\\"age\\":\\"yes\\",\\"subscription\\":\\"na\\"}}]';

try {
  JSON.parse(invalidJson);
} catch(err) {
  console.log('Parse error');
}
const json = invalidJson.replaceAll('\\"', '\"');
console.log(JSON.parse(json));

const invalidJson = '[{\\"country_code\\":\\"IN\\",\\"gdpr_fields\\":{\\"policy\\":\\"yes\\",\\"profiling\\":\\"na\\",\\"age\\":\\"yes\\",\\"subscription\\":\\"na\\"}}]';

try {
  JSON.parse(invalidJson);
} catch(err) {
  console.log('Parse error');
}
const json = invalidJson.replace(/\\"/g, '\"');
console.log(JSON.parse(json));

answered Jul 8, 2021 at 11:25

user15388024

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

Comments

Vishal P Gothi · Accepted Answer · 2021-07-08 11:03:16Z

1

var temp = "[{\"country_code\":\"IN\",\"gdpr_fields\":{\"policy\":\"yes\",\"profiling\":\"na\",\"age\":\"yes\",\"subscription\":\"na\"}}]";   


temp = JSON.parse(temp);

console.log(temp);

Please use something like this, it is working for me.

edited Jul 8, 2021 at 11:03

answered Jul 8, 2021 at 10:57

Vishal P Gothi

9985 silver badges16 bronze badges

1 Comment

Vishal P Gothi Over a year ago

Hey, @user12551649 use this, it is working well.

user12551649 · Accepted Answer · 2021-07-08 10:54:38Z

0

This could be only possible by first cleaning the string

jsonArr = "[{\\\"country_code\\\":\\\"IN\\\",\\\"gdpr_fields\\\":{\\\"policy\\\":\\\"yes\\\",\\\"profiling\\\":\\\"na\\\",\\\"age\\\":\\\"yes\\\",\\\"subscription\\\":\\\"na\\\"}}]".split("\\").join("")

and then

JSON.parse(jsonArr)

answered Jul 8, 2021 at 10:54

user12551649

4261 gold badge7 silver badges26 bronze badges

Collectives™ on Stack Overflow

How to convert array string to JSON value?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related