bind in json format from two different arrays in jquery

Question

I want to bind the json data I got from Site into following json format:

{
  "siteList": [
    {
      "siteName": "Site1",
      "deviceList": [
        {
          "deviceName": "S1device1"
        },
        {
          "deviceName": "S1device2"
        }
      ]
    },
    {
      "siteName": "Site2",
      "deviceList": [
        {
          "deviceName": "S2device1"
        },
        {
          "deviceName": "S2device2"
        }
      ]
    }
  ]
}

I have stored the site name and device name in two different array please help me bind me bind all of this into the format given above.

The jQuery code I used to store the data:

$(document).ready(function() {
     $("input:checkbox[name=check]:checked").each(function(){
      
    var id=$(this).attr('id');
    var site_data = $(this).closest('tr').find('#site').val();
    var device_data = $(this).closest('tr').find('#device').val();
    site_checks.push(site_data);
    device_checks.push(device_data);
});
  var site_check_length = site_checks.length;
 var device_check_length = device_checks.length;
  var site_data_list = [];
     for(var site = 0 ; site < site_check_length ; site++){
        var sites_checked = {};
        var device_checked = {};
        sites_checked['siteName'] = site_checks[site];
        sites_checked['deviceName'] = device_checks[site];
        site_data_list.push(sites_checked);
      }
      console.log(site_data_list);
          });

});
(2) [{…}, {…}]
0: {siteName: "Site1", deviceName: "S1device1"}
1: {siteName: "Site2", deviceName: "S2device1"}

length: 2 This sort of ouput is coming but i have to bind it in above given json format Help!!!

Oliver Kucharzewski · Accepted Answer · 2020-09-07 22:36:44Z

1

In the success function you have provided, you could parse the data accordingly. Here is an example of how you can do so. JSON.stringify will create a JSON string for you using an array of data.

let siteList = [];
let siteListItem = [];
siteListItem.siteName = "Site1";
siteListItem.deviceList = [];

// Create new device
let device_details = [];
device_details.deviceName = 'S1Device';  
// Push device to deviceList
siteListItem.deviceList.push(device_details);

// Push new site to siteList
siteList.push(siteListItem);

// Create a JSON String out of all the changes we've made
console.log(JSON.stringify(siteList));

Though this may seem like a suitable solution, its generally better to find an API provided by the site owner, or to create your own to parse the data on the back-end via PHP, Python or whatever language you are using.

This will ensure you can modify data across multiple clients without having to adjust the local code everytime you want to restructure the JSON string.

edited Sep 7, 2020 at 22:36

answered Sep 7, 2020 at 22:24

Oliver Kucharzewski

2,7155 gold badges32 silver badges56 bronze badges

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

3 Comments

Swarnadeep Over a year ago

M not using php or python i just used jquery and JavaScript with html in this whole code, that is why m facing so many problems

Oliver Kucharzewski Over a year ago

My solution should work for you then, please let me know if otherwise :)

Oliver Kucharzewski Over a year ago

If not, i would suggest you try building a PHP script that scrapes the data from the page into a JSON format. It will be difficult to scrape it using Javascript and is not a wise move efficiency wise.

Collectives™ on Stack Overflow

bind in json format from two different arrays in jquery

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related