JSON stringify re-structure

Question

I have a database, with multiple cells, and under each cell, values.

Cells are: id, name, duration, date, and relationid

I have this code:

var result = {} 
properties.data.forEach(addToResult); //Get data from database using properties.data
    
instance.data.datavarb = JSON.stringify(result); //Send data after converted to JSON
      
function addToResult(pair,isjson){ //operations
if(isjson===true) result[pair.key] = JSON.parse(pair.value); else result[pair.key] = pair.value;
}

I'm facing 2 problems:

1- First problem: This is how i get the value after converted to JSON:

{"id":"1","name":"Football","duration":"12","date":"02-07-2018","relationid":null}

How i need to be:

{id:1, name:"Football", duration:12, date:"02-07-2018", relationid:null}

Need remove the "" quotes from the numbers (id, duration and relationid) and the id,duration,relationid values.

2- Second problem: In the problem 1, just for show you I only was parsing one of the three values from my database. What happens when I parse them all? This is how it looks like:

{"id":"1, 2, 3","name":"Football, France, Belgium","duration":"12, 4, 3","date":"02-07-2018, 08-07-2018, 10-07-2018","relationid":", 1, 1"}

Instead of creating one by one, it creates the same identifiers (id,name,duration) and put all the values in the same. For my prupose i need to be:

{id:1, name:"Football", duration:12, date:"02-07-2018", relationid:null},
{id:2, name:"France", duration:4, date:"08-07-2018", relationid:1},
{id:3, name:"Belgium", duration:3, date:"10-07-2018", relationid:1}

Many thanks!!

JSON insists that property names be quoted; it's not JSON if they're not. — Pointy
– Pointy, Commented Jul 6, 2018 at 21:42
JSON isn't converting the values to strings, they must have been strings in the original properties.data. — Barmar
– Barmar, Commented Jul 6, 2018 at 21:43
Thanks for your answer @Pointy but i'm trying to use this resource: docs.dhtmlx.com/gantt/desktop__loading.html Check how their loading data works. — K3ny1
– K3ny1, Commented Jul 6, 2018 at 21:44
@K3ny1 If you look at their tasks.json example, it has quotes around the property names. — Barmar
– Barmar, Commented Jul 6, 2018 at 21:45
keys of a JSON are always strings, even if you don't put double quotes on them. So what's the problem? — Jay Ghosh
– Jay Ghosh, Commented Jul 6, 2018 at 21:47

Barmar · Accepted Answer · 2018-07-06 23:09:51Z

2

You can test whether the values look like integers, and parse them.

function addToResult(pair,isjson){ //operations
    if(isjson===true) {
        result[pair.key] = JSON.parse(pair.value); 
    } else if (/^\d+$/.test(pair.value)) {
        result[pair.key] = Number(pair.value);
    } else {
        result[pair.key] = pair.value;
    }
}

edited Jul 6, 2018 at 23:09

answered Jul 6, 2018 at 22:00

Barmar

789k57 gold badges554 silver badges668 bronze badges

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

8 Comments

K3ny1 Over a year ago

Hello, will test it now, btw I think in the else if is missing a ) Thanks!

Barmar Over a year ago

Yep, I do that all the time here, too used to IDE that automatically balances....

K3ny1 Over a year ago

Hello Barmar seems the code works well, but i'm facing a little problem that is my code is running before the it gets the value from the database, and is returning me a missing value error.

Barmar Over a year ago

This code should be in the callback function of the database query.

K3ny1 Over a year ago

Thanks so much @Barmar, i'm so near to do it. I need to remove also the "" from the id,name,duration,date titles. Is possible like you did?

|

Collectives™ on Stack Overflow

JSON stringify re-structure

1 Answer 1

8 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Related