Get User by ID API

Overview

Retrieves full user profile details including company, department, assigned band, and reporting manager relationships.

• Endpoint: /api/users/get-by-id
• Method: POST
• Access: Corporate Admin / Manager / User

Request Body Schema

Field	Type	Required	Description
id	String (UUID)	Yes	Target user ID

Request Body Example

{
  "id": "u9876543-21ba-fedc-3210-9876543210fe"
}

Success Response (200 OK)

{
  "success": true,
  "message": "User details retrieved successfully",
  "data": {
    "id": "u9876543-21ba-fedc-3210-9876543210fe",
    "email": "vikram.singh@abbott.com",
    "firstName": "Vikram",
    "lastName": "Singh",
    "employeeBand": "Band 1",
    "band": {
      "id": "b1234567-89ab-cdef-0123-456789abcdef",
      "name": "Band 1",
      "autoApprovalLimit": "7000.00"
    },
    "managedByLinks": [
      {
        "manager": {
          "id": "mgr-uuid",
          "firstName": "Rohit",
          "lastName": "Verma",
          "email": "rohit.verma@abbott.com"
        }
      }
    ]
  }
}

Database Impact

• Tables: users, employee_bands, user_manager_maps
• Operations: SELECT with relational includes.