Cointab-Assignment

This assignment involves creating a simple 2-page website using Node.js and a SQL database, adhering to specific business requirements such as fetching data from an API, displaying user information, save the user posts and generate an excel file containing all the user's posts.

Deployed Links

• Backend Deployment Link
• Frontend Deployment Link
• Swagger documentation

Technologies Used

• Node.js
• Express.js
• SQL
• HTML
• CSS
• Javascript

NPM Packages Used

• axios
• dotenv
• express
• cors
• sequelize
• exceljs

API Endpoints:

• GET /user/
  • This endpoint will give list of all the users data
• POST /user/add
  • This endpoint is used to add new user in database
• POST /post/
  • This endpoint is used to add all the posts of a user
• GET /post/
  • This endpoint gives a list of posts for a particular user
• GET /post/download-excel/:userId
  • This endpoint is used to download all the posts of a particular user in an excel sheet

Features

• Add users to database
• Add user's posts to database
• Download all the posts of a particular user in an excel sheet

Some View