How to convert list to JSON in JavaScript?

Question

I have a list like this:

<ol class="CricketPlayers">
    <li id="1">Player: John, TotalRuns: 4350, AllRounder: false</li>
    <li id="2">Player: Michael, TotalRuns: 8373, AllRounder: true</li>
</ol>

I need to convert this into JSON like this:

[
    {
        "Player": "John",
        "TotalRuns": 4350,
        "AllRounder": false
    },
    {
        "Player": "Michael",
        "TotalRuns": 8373,
        "AllRounder": true
    }
]

Formatting of JSON is not important.

Using jQuery etc. is not an option. I am thinking to convert the list into array and then calling JSON.stringify. But I not sure if that will work because there can be many items in the list.

What's the specific issue? You'll need to iterate over the children of .CricketPlayers, pull the text out of each <li>, split on , (and hope there are no other commas), iterate over those and split on : and use each pair as a property name/value. This is why web scraping is awful--can you just get the data instead? — Dave Newton
– Dave Newton, Commented Apr 22, 2021 at 16:04
@DaveNewton I can start formatting it as JSON when data is entered, but it can be deleted and then deleting it from that variable is even more difficult. — Farhan
– Farhan, Commented Apr 22, 2021 at 16:24
It shouldn't be; you have a unique ID and/or a linear collection, so updating or deleting should be (reasonably) straight-forward. — Dave Newton
– Dave Newton, Commented Apr 22, 2021 at 16:28

iBagus · Accepted Answer · 2021-04-22 16:54:06Z

1

try this:

let result = [];
let parent = document.querySelector(".CricketPlayers").children;
Array.prototype.forEach.call(parent, child => {
  let x = child.innerHTML.split(",");
  let y = JSON.stringify(x).replace("[","{").replace("]","}");
  result.push(y)
});
console.log(result)

answered Apr 22, 2021 at 16:54

iBagus

111 bronze badge

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

Comments

Andy · Accepted Answer · 2021-04-22 16:12:44Z

0

Here you go:

[...document.querySelectorAll('.CricketPlayers li')]
.map(node => node.innerText.match(/Player\: (\w+). TotalRuns\: (.*). AllRounder\: (.*)/))
.map(matchedParts => ({ Player: matchedParts ? matchedParts[1] : '', TotalRuns: matchedParts ? matchedParts[2] : 0, AllRounder: matchedParts ? matchedParts[3] : 0 }))

and the results are like yours.

answered Apr 22, 2021 at 16:12

Andy

5243 silver badges14 bronze badges

1 Comment

Farhan Over a year ago

Thanks. Can you please show the output? When I console.log the whole thing, I did not see the result as JSON.

Charlie · Accepted Answer · 2021-04-22 16:31:17Z

0

Get the children of the ol, iterate them and construct the array.

let ol = document.getElementsByClassName('CricketPlayers');


let output =[...ol[0].children].map(item => {

   let props = item.innerHTML.split(',');
   
   return props.reduce((a, c) => {   
   
      aProp = c.split(':');    
      a[aProp[0].trim()] = aProp[1].trim();    
      return a
    
   }, {})

})

console.log(output)

<ol class="CricketPlayers">
    <li id="1">Player: John, TotalRuns: 4350, AllRounder: false</li>
    <li id="2">Player: Michael, TotalRuns: 8373, AllRounder: true</li>
</ol>

answered Apr 22, 2021 at 16:31

Charlie

24k12 gold badges65 silver badges96 bronze badges

Collectives™ on Stack Overflow

How to convert list to JSON in JavaScript?

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