Implement the Client Enquiry POST API Nodejs service and persist the data in MySQL Database.

Job ID: 35323807

Budget: $10 – $30 USD

Implement the Client Enquiry POST REST API which takes input fields ‘Name’, ‘Phone Number’, ‘Email Address’, ‘Email Subject’, and ‘Email Description’ as a payload and saves them to the MySQL Database.

Acceptance Criteria:
Client name: ‘Name’ - This text field is mandatory, and the minimum length of the field value is at least 4 characters.
Client Phone number: ‘Phone’ - This text field is mandatory. Phone number validation is required and should have a length between 10 to 13 digits. The input type must be a number.
Client Email ID: ‘Email Address' - This field is mandatory and the input type should be text with email validation parameters
‘Email Subject’ - This is a mandatory text field. Maximum length must be 256 characters.
‘Email Description' - This is a mandatory text box.

Create a Relational MySQL Database with
Database Name: tek_innovate_db
Table Name: client_enquiry
Columns name: name, phone, email_address, email_subject, email_description

The above must work when tested in any REST clients such as Postman or Advanced Rest Client.
The inputs must be saved to MySQL Database
The data should be viewed/ retrieved using MySQL WorkBench or SQL Pro or any similar tool.

Push the code to Github after completion.

Technologies: NodeJS service, MySQL, REST

Out of Scope: UI work
Related categories: MySQL Node.js RESTful API