I am having a problem pulling the data called, to my table. How can i achieve this?

kmartin

This is my api code

app.get('/readVendor', function (req, res) {
let sql = "SELECT Id,firstName,lastName,telephone,email,address FROM vendors";
//query db
con.query(sql,
function (err, result) {
if (err) {
res.status(500).send({ message: err });
} else if (result) {
res.status(200).send({data: result});
}
});
})

Here is the result when called

{
"data": [
{
"Id": 1,
"firstName": "karim",
"lastName": "james",
"telephone": " 111-345-6789",
"email": "",
"address": "Constitution+Hi"
},
{
"Id": 14,
"firstName": "karim",
"lastName": "james",
"telephone": " 111-345-6789",
"email": "arim@gmail.com",
"address": "Constitution+Hi"
},
{
"Id": 17,
"firstName": "karim",
"lastName": "james",
"telephone": " 111-345-6789",
"email": "garim@gmail.com",
"address": "Constitution+Hi"
},
{
"Id": 18,
"firstName": "karim",
"lastName": "james",
"telephone": " 111-345-6789",
"email": "gadrim@gmail.com",
"address": "Constitution+Hi"
},
{
"Id": 19,
"firstName": "karim",
"lastName": "james",
"telephone": " 111-345-6789",
"email": "gdrim@gmail.com",
"address": "Constitution+Hi"
},
{
"Id": 20,
"firstName": "karim",
"lastName": "james",
"telephone": " 111-345-6789",
"email": "gdrie@gmail.com",
"address": "Constitution+Hi"
},
{
"Id": 21,
"firstName": "karim",
"lastName": "james",
"telephone": " 111-345-6789",
"email": "gdaje@gmail.com",
"address": "Constitution+Hi"
},
{
"Id": 22,
"firstName": "karim",
"lastName": "james",
"telephone": " 111-345-6789",
"email": "gdaffe@gmail.com",
"address": "Constitution+Hi"
},
{
"Id": 23,
"firstName": "karim",
"lastName": "james",
"telephone": " 111-345-6789",
"email": "gadeffe@gmail.com",
"address": "Constitution+Hi"
}
]
}

This is my datatable.js code

$(document).ready(function () {
$('#example').DataTable({
ajax:{
url: 'http://localhost:3005/readVendor',
},
"columns": [
{ "data": "Id" },
{ "data": "firstName"},
{ "data": "lastName" },
{ "data": "telephone"},
{ "data": "email"},
{ "data": "address"}
],
});
});

I am not sure what's going on, but I need your help.

kmartin

the above picture is a browser view of the data called.

colin

It should work, see here. Are you able to link to your page so we can take a look?

Colin

kmartin

@colin I tried that solution before and it worked and that's what makes things weird.

When I called the data from a text file or from the javascript, it worked.

But when I called the data from an express.js API, the data don't show in the table.

If I select (F12) and look under the network tab I can see that the data was called.

kmartin

@colin i am wondering if its a timing issue.

kthorngren

If I select (F12) and look under the network tab I can see that the data was called

Do you see the response and is it the above data?

Do you see errors in your browser's console?

Can you provide a link to your page so we can take a look?

Kevin

kmartin

Do you see the response and is it the above data? Yes
Do you see errors in your browser's console? No
Can you provide a link to your page so we can take a look? Not at this moment, I am using my node.js as my server on my laptop. I would have to post the site on a public webserver

kmartin

@kthorngren my problem is rendering the data on the table.

kthorngren

It looks like everything is correct. If you are unable to provide a test case maybe the developers can find something interesting from the debugger.

Kevin

allan

Yes - I don't see anything wrong there, so I'm not sure why it isn't working. If you could use the debugger as Kevin says, I'll take a look at it.

Allan

kmartin

thanks @kthorngren and @allan. I tried something else i think its how react setup