My JSON is stored in MySQL as this....
{'profile':'sweet', 'count':38},{'profile':'bitter', 'count':31},{'profile':'green', 'count':22}
When it's being returned as JSON from Express, it looks likes this...
[{"JSON":"{'profile':'sweet', 'count':38},{'profile':'bitter', 'count':31},{'profile':'green', 'count':22}"}]
which is valid JSON according to JSONLint.com
What throws me is iterating over it in a HTML javascript...
I have this in Javascript ....
fProfiles_JSON = JSON.parse(xhr.responseText);
console.log('Type of '+ typeof fProfiles_JSON); //yields "object"
console.log('My object', fProfiles_JSON);
console.log('LENGTH ', fProfiles_JSON.length); // Yields "1"
I get that I have to somehow iterate over this object type to get at the "profile" and "count" values but honestly, I'm not sure how since the length value is "1". I know this is probably dead simple and I'm just not seeing it. Can someone point me in the right direction?
var obj = [{"JSON":"{'profile':'sweet', 'count':38},{'profile':'bitter', 'count':31},{'profile':'green', 'count':22}"}]
// in this case we have to extract the string:
var string = obj[0]["JSON"]
var fProfiles = JSON.parse("[" + string + "]");
// as @Barmar pointed out, the string's content is not valid JSON.
// so we add at beginning and end square brackets to get a list
// of objects.
FProfiles.length // should be 3
// and you can access the `count` and `profile` attributes.
Json does not accept single quotes so they must be replaced
//xhr.responseText contents simulated with var
resp = "[{\"JSON\":\"{'profile':'sweet', 'count':38},{'profile':'bitter', 'count':31},{'profile':'green', 'count':22}\"}]";
j = JSON.parse(resp);
inner = j[0]['JSON'].replaceAll("'","\"");
objs = JSON.parse("[" + inner +"]");
objs[0]
Result:
Object { profile: "sweet", count: 38 }
As @barmar pointed out, "fixing" json with a custom parser is always a risk.
A slightly better attempt could be to replace single quotes with more specific regular expressions
# added possible 'key': 'value' at the end
resp = "[{\"JSON\":\"{'profile':'sweet', 'count':38},{'profile':'bitter', 'count':31},{'profile':'green', 'count':22},{'key99': 'value99'}\"}]";
j = JSON.parse(resp);
re3 = /[{]'/ig;
re4 = /'[}]/ig;
re1 = /'(, *|: *)'/ig;
re2 = /' *: *([0-9])/ig;
inner = j[0]['JSON'].replaceAll(re3,"{\"").replaceAll(re4, "\"}").replaceAll(re1, "\"$1\"").replaceAll(re2,"\":$1");
// "{\"profile\":\"sweet\", \"count\":38},{\"profile\":\"bitter\", \"count\":31},{\"profile\":\"green\", \"count\":22},{\"key99\": \"value99\"}"
objs = JSON.parse("[" + inner +"]");
// Array(3) [ {…}, {…}, {…} ]