Create a JSON object for a member

Question

Create a JSON object for a member

Looking to transform the provided page into a JSON object:

var mybody = document.getElementsByTagName('body')[0];
var table = mybody.getElementsByTagName('table')[0];

var jsonObj = [];

for (var i = 0, row; row = table.rows[i]; i++) 
{
    var cell2 = row.cells.length == '1' ? '' : row.cells[1].textContent.trim();
    jsonObj.push( { what: row.cells[0].textContent.trim(), value:cell2 });
}
console.log(jsonObj);

This code generates the following JSON object

[
    Object { what= "Beograd" , value= "" }, 
    Object { what= "Broj leta" , value= "JU 109, JA 1376" }, 
    Object { what= "Avio-kompanija" , value= "JAT AIRWAYS" }, 
    Object { what= "Tip aviona" , value= "AT72" }, 
    Object { what= "Planirano vrijeme" , value= "06:20" }, 
    Object { what= "Status leta" , value= "Odletio" }, 
    Object { what= "" , value= "" }, 
    Object { what= "Beograd" , value= "" }, 
    Object { what= "Broj leta" , value= "SOP 4121" }, 
    Object { what= "Avio-kompanija" , value= "SOLINAIR LTD" }, 
    Object { what= "Tip aviona" , value= "SF34" }, 
    Object { what= "Planirano vrijeme" , value= "16:35" }, 
    Object { what= "Status leta" , value= "Odletio" }, 
    Object { what= "" , value= "" }
]

As the data is for 2 flights on the page, we need to include two elements in the JSON string describing

Flight1
Flight2

To achieve this structure:

 {  "Flight1": [
    Object { what= "Beograd" , value= "" }, 
    Object { what= "Broj leta" , value= "JU 109, JA 1376" }, 
    Object { what= "Avio-kompanija" , value= "JAT AIRWAYS" }, 
    Object { what= "Tip aviona" , value= "AT72" }, 
    Object { what= "Planirano vrijeme" , value= "06:20" }, 
    Object { what= "Status leta" , value= "Odletio" }, 
    Object { what= "" , value= "" }],

"Flight2": [
    Object { what= "Beograd" , value= "" },     
    Object { what= "Broj leta" , value= "SOP 4121" }, 
    Object { what= "Avio-kompanija" , value= "SOLINAIR LTD" }, 
    Object { what= "Tip aviona" , value= "SF34" }, 
    Object { what= "Planirano vrijeme" , value= "16:35" }, 
    Object { what= "Status leta" , value= "Odletio" }, 
    Object { what= "" , value= "" ]

}

javascript json

Answer 1

Answer №1

Object is considered invalid in JSON formatting.

To ensure the validity of your JSON data, you can use this validator: http://jsonlint.com/

Answer 2

Object is considered invalid in JSON formatting.

To ensure the validity of your JSON data, you can use this validator: http://jsonlint.com/

Answer 3

Answer №2

Creating basic JavaScript objects is what you are currently engaged in. Here's an alternative way to accomplish this:

var myObject = {}; // initialize object
myObject["key"] = ["x", "y"]; // establish key-value pairs
myObject.property = {}
myObject.value = 15;

If you want to convert these objects to JSON format, your top choice would be to use JSON.stringify(), a function that transforms JavaScript objects into JSON strings. Additionally, you can utilize $jQuery.parseJSON(), which allows for the conversion of a JSON string back to a JavaScript object. It's important to note that you will need to have jQuery installed to make use of these functions.

Answer 4

Creating basic JavaScript objects is what you are currently engaged in. Here's an alternative way to accomplish this:

var myObject = {}; // initialize object
myObject["key"] = ["x", "y"]; // establish key-value pairs
myObject.property = {}
myObject.value = 15;

If you want to convert these objects to JSON format, your top choice would be to use JSON.stringify(), a function that transforms JavaScript objects into JSON strings. Additionally, you can utilize $jQuery.parseJSON(), which allows for the conversion of a JSON string back to a JavaScript object. It's important to note that you will need to have jQuery installed to make use of these functions.

Answer 5

Answer №3

To iterate through your objects, you can utilize the <hr> element as a reference point:

var myBody = document.getElementsByTagName('body')[0];
var table = myBody.getElementsByTagName('table')[0];

var dataObject = [], items = {}, itemCount = 1;

for (var j = 0, itemRow; itemRow = table.rows[j]; j++) 
{
    if (itemRow.cells[0].innerHTML == "<hr>") {
        items["Item"+(itemCount++)] = dataObject;
        dataObject = [];
    }
    else {
       var cellValue = itemRow.cells.length == '1' ? '' : itemRow.cells[1].textContent.trim();
       dataObject.push( { key: itemRow.cells[0].textContent.trim(), val:cellValue });
    }
}
console.log(items);

Answer 6

To iterate through your objects, you can utilize the <hr> element as a reference point:

var myBody = document.getElementsByTagName('body')[0];
var table = myBody.getElementsByTagName('table')[0];

var dataObject = [], items = {}, itemCount = 1;

for (var j = 0, itemRow; itemRow = table.rows[j]; j++) 
{
    if (itemRow.cells[0].innerHTML == "<hr>") {
        items["Item"+(itemCount++)] = dataObject;
        dataObject = [];
    }
    else {
       var cellValue = itemRow.cells.length == '1' ? '' : itemRow.cells[1].textContent.trim();
       dataObject.push( { key: itemRow.cells[0].textContent.trim(), val:cellValue });
    }
}
console.log(items);

Create a JSON object for a member

Answer №1

Answer №2

Answer №3

Similar questions

Is the div empty? Maybe jQuery knows the answer

What is the best way to make a recursive function display every return value in Javascript?

Which method of loading website images is quicker: sequential or parallel, utilizing Javascript?

Implementing Ajax Like Button functionality in a Ruby on Rails application

How to Transfer Data from a Dynamic Drop-down Menu to PHP for Processing and Presentation in a Div Element on the Same Web Page

The ASP.net WebMethod seems to be providing a full page output instead of the expected JSON data

filtering elements with selectable functionality in jQuery UI

Using both withNextIntl and withPlaiceholder simultaneously in a NextJS project causes compatibility issues

Difficulty transmitting Heroku environment variable to Angular CLI application using Node.js

Utilizing TypeScript interfaces to infer React child props

Tips for successfully passing array index as an image source in Vuejs with v-img?

Is it possible to parse Json using Gson without the need for square brackets around arrays?

Babel not compiling code correctly

Is there a way to completely clear a form using jQuery in JavaScript?

Utilize the ESLint plugin to manage unresolved import paths in Next.js modules

What is the method for including the RegExpression value in the request body of a Postman post?

Validation of the top-level URL

Leveraging jQuery plugin within a React ecosystem

How does the StreamingContext parameter benefit Json.NET Serialization Callbacks?

Executing an Ajax request. Best method for transmitting various data elements: