{"info":{"_postman_id":"81197865-4763-4782-9318-48f572e7e95f","name":"Users CRUD API","description":"

📘 Users CRUD API – Postman Collection

This Postman collection documents a RESTful API for managing users, built with Node.js, Express, and Sequelize, and deployed on Render. It provides full CRUD functionality to create, read, update, and delete user records stored in a PostgreSQL database.

🔧 Base URL

https://users-crud-api-gikf.onrender.com\n\n

📁 Available Endpoints

GET /api/users – Retrieve all users
\n
GET /api/users/:id – Retrieve a single user by ID
\n
POST /api/users – Create a new user
\n
PUT /api/users/:id – Update an existing user
\n
DELETE /api/users/:id – Delete a user by ID
\n

📦 Features

JSON-formatted request and response bodies
\n
Input validation and error handling
\n
Modular architecture ready for production
\n
Environment variable support via .env
\n
Scalable deployment on Render
\n

🔐 Optional Enhancements

This API is ready for integration with authentication systems such as JWT or OAuth, and can be extended with role-based access control, pagination, and filtering.

\n","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"48309056","collectionId":"81197865-4763-4782-9318-48f572e7e95f","publishedId":"2sB3WtsJn4","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"FF6C37"},"publishDate":"2025-11-11T02:31:43.000Z"},"item":[{"name":"Get All Users","id":"c9429921-8382-49a8-b082-4b5bab50e908","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"/api/users","description":"

Description:

Retrieve all users from database.

Correct Response:

[\n     {\n        \"id\": 2,\n        \"first_name\": \"Mali\",\n        \"last_name\": \"Bb\",\n        \"email\": \"mali.bb@example.com\",\n        \"password\": \"123456\",\n        \"birthday\": \"2025-11-10T00:00:00.000Z\",\n        \"image_url\": \"https://avatar.iran.liara.run/public/girl?username=MaliBb\",\n        \"createdAt\": \"2025-11-11T00:33:34.248Z\",\n        \"updatedAt\": \"2025-11-11T00:33:34.248Z\"\n    }\n]\n\n

\n","urlObject":{"path":["api","users"],"host":[""],"query":[],"variable":[]}},"response":[],"_postman_id":"c9429921-8382-49a8-b082-4b5bab50e908"},{"name":"Create User","id":"7b2c79dd-01be-4561-9119-0f75a70ac79e","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"first_name\": \"Demian\",\r\n \"last_name\": \"Williams\",\r\n \"email\": \"willdam@example.com\",\r\n \"password\": \"262207\",\r\n \"birthday\": \"2007-08-17\",\r\n \"image_url\": \"\"\r\n}","options":{"raw":{"language":"json"}}},"url":"/api/users","description":"

Description:

Create a new user into database.

Correct Response:

{\n    \"message\": \"User created\",\n    \"user\": {\n        \"id\": 24,\n        \"first_name\": \"Demian\",\n        \"last_name\": \"Williams\",\n        \"email\": \"willdam@example.com\",\n        \"password\": \"262207\",\n        \"birthday\": \"2007-08-17T00:00:00.000Z\",\n        \"image_url\": \"https://ui-avatars.com/api/?name=Demian+Williams\",\n        \"updatedAt\": \"2025-11-11T01:59:28.063Z\",\n        \"createdAt\": \"2025-11-11T01:59:28.063Z\"\n    }\n}\n\n

\n","urlObject":{"path":["api","users"],"host":[""],"query":[],"variable":[]}},"response":[],"_postman_id":"7b2c79dd-01be-4561-9119-0f75a70ac79e"},{"name":"Get One User","id":"57e92b56-7bc9-41d2-b638-5e835971239f","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"body":{"mode":"raw","raw":"{\r\n \"first_name\": \"Mali\",\r\n \"last_name\": \"Bb\",\r\n \"email\": \"mali@example.com\",\r\n \"password\": \"123456\",\r\n \"birthday\": \"05/03/25\"\r\n}"},"url":"/api/users/2","description":"

Description:

Retrieve one user by id from database.

Correct Response:

{\n    \"message\": \"User found\",\n    \"user\": {\n        \"id\": 2,\n        \"first_name\": \"Mali\",\n        \"last_name\": \"Bb\",\n        \"email\": \"mali.bb@example.com\",\n        \"password\": \"123456\",\n        \"birthday\": \"2025-11-10T00:00:00.000Z\",\n        \"image_url\": \"https://avatar.iran.liara.run/public/girl?username=MaliBb\",\n        \"createdAt\": \"2025-11-11T00:33:34.248Z\",\n        \"updatedAt\": \"2025-11-11T00:33:34.248Z\"\n    }\n}\n\n

\n","urlObject":{"path":["api","users","2"],"host":[""],"query":[],"variable":[]}},"response":[],"_postman_id":"57e92b56-7bc9-41d2-b638-5e835971239f"},{"name":"Delete User","id":"9fd25c36-466e-44e6-ba03-8e9390e1a2d5","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"body":{"mode":"raw","raw":"{\r\n \"first_name\": \"Mali\",\r\n \"last_name\": \"Bb\",\r\n \"email\": \"mali@example.com\",\r\n \"password\": \"123456\",\r\n \"birthday\": \"05/03/25\"\r\n}"},"url":"/api/users/2","description":"

Description:

Delete one user by id into database.

Correct Response:

{\n    \"message\": \"User deleted\"\n}\n\n

\n","urlObject":{"path":["api","users","2"],"host":[""],"query":[],"variable":[]}},"response":[],"_postman_id":"9fd25c36-466e-44e6-ba03-8e9390e1a2d5"},{"name":"Update User","id":"d6f774aa-384b-49cd-89c7-504d98be15a3","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[],"body":{"mode":"raw","raw":"{\r\n \"first_name\": \"Sofía\",\r\n \"last_name\": \"Reyes\",\r\n \"email\": \"sofi.reyes@example.com\",\r\n \"password\": \"129875\",\r\n \"birthday\": \"1999-08-14\"\r\n}","options":{"raw":{"language":"json"}}},"url":"/api/users/3","description":"

Description:

Update an existing user.

Correct Response:

{\n    \"message\": \"User updated\",\n    \"user\": {\n        \"id\": 3,\n        \"first_name\": \"Sofía\",\n        \"last_name\": \"Reyes\",\n        \"email\": \"sofi.reyes@example.com\",\n        \"password\": \"129875\",\n        \"birthday\": \"1999-08-14T00:00:00.000Z\",\n        \"image_url\": \"https://ui-avatars.com/api/?name=Sofía+Reyes\",\n        \"createdAt\": \"2025-11-11T00:35:13.176Z\",\n        \"updatedAt\": \"2025-11-11T02:22:56.322Z\"\n    }\n}\n\n

\n","urlObject":{"path":["api","users","3"],"host":[""],"query":[],"variable":[]}},"response":[],"_postman_id":"d6f774aa-384b-49cd-89c7-504d98be15a3"}],"event":[{"listen":"prerequest","script":{"id":"0c36e023-ada6-42ce-bd3f-c91909098b68","type":"text/javascript","packages":{},"requests":{},"exec":[""]}},{"listen":"test","script":{"id":"df5f898a-787b-4a2f-8c81-152d2af0e1e3","type":"text/javascript","packages":{},"requests":{},"exec":[""]}}],"variable":[{"key":"BASE_URL","value":""}]}