/accrevocompany-api

Primary LanguageJavaScript

Install tools

install nodejs from https://nodejs.org/en/

install mysql from https://www.mysql.com/downloads/

Set up MySQL

mysql -u username -p DBName < accrevocompany.sql

Set up project

In project folder.

sudo npm -g nodemon
npm install
npm start

Config connection between NodeJS and MySQL in dbconnection.js

Routing

  • home page baseurl/
  • use postman to post 15 column data to companys table and 3 column to companykey in MySQL accrevocompany database baseurl/company alt text
  • get companyname if exist else return null baseurl/company/{companyname}
  • create and get company name's new api key baseurl/company/getnewapikey/{companyname}