Struggling with setting up Express.js and the mysql package for creating APIs, I find myself unable to execute a POST request.
This is the current state of my code:
const express = require('express');
const mysql = require('mysql');
const config = mysql.createConnection({
host: theHost,
port: thePort,
user: theUser,
password: thePass,
database: theDB,
});
const app = express();
config.connect(function(err){
if(!err) {
console.log("Success");
} else {
console.log("Error trying to connect");
}
});
app.get("/api/InternalAccess", function(req, res){
config.query('SELECT * from InternalAccess', (error, result) => {
if (error) throw error;
res.send(result);
});
});
app.post("/api/internalAccess", function(req, res){
var info = { User: req.body.User, Password: req.body.Password, CreationDate: req.body.CreationDate };
config.query('INSERT INTO InternalAccess SET ?', info, (error, result) => {
if (error) throw error;
res.send(result);
});
});
app.listen(3000);
While getting data using GET works perfectly, attempting to make a POST request in Postman throws an error: "Cannot read property "User" of undefined". What am I missing? I'm quite new to using the mysql package.
The database I'm working with is MySQL Workbench, alongside Node.js, Express.js, and the mysql package.
I would greatly appreciate any help or insights. Thank you in advance.