Obtaining JSON information from AJAX with the help of express.js

Question

Obtaining JSON information from AJAX with the help of express.js

After retrieving data from HandsOnTable, I am sending it to my Node.JS and Express.JS backend for storage. Following the example provided here (), I utilize json.stringify to format the data before transmitting it using an AJAX GET request.

The challenge arises when attempting to access the received data on the backend. Although I employ body-parser to retrieve JSON objects via req.body.xxx, I desire a method to access each individual row and field - such as 'Bob'.

Any suggestions? Below is a snippet of my JSON data.

{"data":[["Bob",null,"PHD",null],["Julie",null,"test",null],["Stan",null,"Masters",null]]}

javascript express handsontable

Answer 1

Answer №1

If you want to retrieve data from a specific row and column, you can use the following function:

function getDataByRowAndColumn(data, rowNum, colNum) {
    return data.data[rowNum][colNum];
}
console.log(getDataByRowAndColumn(data, 0, 0)); // "Bob"

Answer 2

If you want to retrieve data from a specific row and column, you can use the following function:

function getDataByRowAndColumn(data, rowNum, colNum) {
    return data.data[rowNum][colNum];
}
console.log(getDataByRowAndColumn(data, 0, 0)); // "Bob"

Answer 3

Answer №2

To iterate through the data, you can create a simple loop:

Access all fields and perform your desired actions on each one

for(var i = 0; i < t.data.length; i++) 
  for(var y = 0; y < t.data[i].length; y++) {
     console.log(t.data[i][y]); 
  }

Alternatively, you can retrieve specific elements based on their indexes using

t.data[x][y]

Assuming that variable 't' contains your dataset

Answer 4

To iterate through the data, you can create a simple loop:

Access all fields and perform your desired actions on each one

for(var i = 0; i < t.data.length; i++) 
  for(var y = 0; y < t.data[i].length; y++) {
     console.log(t.data[i][y]); 
  }

Alternatively, you can retrieve specific elements based on their indexes using

t.data[x][y]

Assuming that variable 't' contains your dataset

Obtaining JSON information from AJAX with the help of express.js

Answer №1

Answer №2

Similar questions

nap within a for loop and executed in a finally block

Update an item's precise orientation in relation to the global axis

Create a copy of a div element once the value of a select element has

Angular 6: encountering difficulty in setting up component routes (from root to child) when creating separate modules

Encountered a null error while utilizing ES6 computed state in React components

What is the best method for securely storing billing and credit card data?

tutorial on updating database status with ajax in Laravel

The type does not contain a property named `sort`

When transmitting JSON data from the View to the Controller in ASP.NET MVC, the received values are

Analyze two objects and eliminate any duplicate keys present between them

What is the best way to remove the hover effect from a specific element within a div?

Tips for transferring a variable from Next.js to a plain JavaScript file

What is the best way to initiate a fresh AJAX request whenever the submit button is pressed?

Using jQuery to modify the caret class when clicked

What are the steps to customize the $http interface in AngularJS?

New Angular Datatables used to create a revitalizing table

Saving Information from an HTML Form Input?

Is it possible to create a subclass by extending an HTML element?

Add the slide number and total count in between the navigation arrows of the owl carousel

The combination of NodeJS, Express, and the dynamic Socket.io event system