Single Attendance Record - User Report API

This API is used to get attendance details of employees from the attendance reports page. Details that are present in the user report like overtime/deviation time, total working hours, etc. for a particular employee and a particular period chosen can be extracted with the help of this API. 

Request URL

https://people.zoho.com/people/api/attendance/getUserReport?sdate=<sdate>&edate=<edate>&empId=<employeeId>&emailId=<emailId>&mapId=<mapId>&dateFormat=<dateFormat>

Header:

Authorization: Zoho-oauthtoken 1000.8cb99dxxxxxxxx9be93.9b8xxxxxxf

​Request Parameters

sdateSpecify the correct start date
edateSpecify the correct end date
empIdSpecify the employee ID of an employee
emailIdSpecify the email ID of an employee
mapIdSpecify the mapper ID of an employee
dateFormatSpecify the date format for the given date. Eg: yyyy-MM-dd (optional)

Note

  • Start date and end date should be in the format specified in the company settings or in the date format you have mentioned in the parameter.
  • Out of the 3 parameters - Emp ID, Email ID & Map ID, at least one of them must be given as input to map the entry of an employee. Mapper ID is the unique ID of your Attendance system like the Biometric system which marks the attendance for a specific employee.

Multiple Attendance Records - User Report API 

This API is used to get the attendance details of 100 employees from the attendance reports page in one request. To fetch the next 100 employees' attendance simply modify startIndex as 100, and 200 for the next 100 employees, and so on.

Request URL

https://people.zoho.com/people/api/attendance/getUserReport?sdate=<sdate>&edate=<edate>>&dateFormat=<dateFormat>&startIndex=<startIndex>

Header:

Authorization: Zoho-oauthtoken 1000.8cb99dxxxxxxxx9be93.9b8xxxxxxf

​Request Parameters

sdateSpecify the correct start date
edateSpecify the correct end date
startIndexSpecify where to start for fetching 100 employee attendance details at once. Example 0, returns the first 100 employees
dateFormatSpecify the date format for the given date. Eg: yyyy-MM-dd (optional)

 Threshold Limit:  100 requests | Lock period: 5 minutes

Threshold Limit - Number of API calls allowed within a minute.
Lock Period - Wait time before consecutive API requests.

Header

CopiedAuthorization: Zoho-oauthtoken 1000.8cb99dxxxxxxxx9be93.9b8xxxxxxf

Sample Response - Single Record

Copied{
    "2020-03-16": {
        "ShiftStartTime": "09:00 AM",
        "Status": "Sick",
        "paidBreakHours": "00:00",
        "OverTime": "00:00",
        "LastOut_Location": "-",
        "ShiftName": "Noon",
        "unPaidBreakHours": "00:00",
        "FirstIn": "16-Mar-2020 09:20 AM",
        "FirstIn_Location": "-",
        "TotalHours": "00:00",
        "WorkingHours": "08:00",
        "LastOut": "16-Mar-2020 09:20 AM",
        "ShiftEndTime": "09:00 PM"
    }
}

Sample Response - Multi Record (100 Users)

Copied{
    "result": [
        {
            "attendanceDetails": {
                "2020-03-21": {
                    "ShiftStartTime": "10:00 PM",
                    "Status": "Absent",
                    "paidBreakHours": "00:00",
                    "LastOut_Location": "-",
                    "ShiftName": "Third",
                    "unPaidBreakHours": "00:00",
                    "FirstIn": "-",
                    "FirstIn_Location": "-",
                    "TotalHours": "00:00",
                    "WorkingHours": "00:00",
                    "LastOut": "-",
                    "DeviationTime": "08:00",
                    "ShiftEndTime": "06:00 AM"
                }
            },
            "employeeDetails": {
                "mail id": "kumar.k@abc.om",
                "erecno": "609835000000452022",
                "last name": "Kumar",
                "first name": "Selva",
                "id": "1"
            }
        },
        {
            "attendanceDetails": {
                "2020-03-21": {
                    "ShiftStartTime": "10:00 PM",
                    "Status": "Absent",
                    "paidBreakHours": "00:00",
                    "LastOut_Location": "-",
                    "ShiftName": "Third",
                    "unPaidBreakHours": "00:00",
                    "FirstIn": "-",
                    "FirstIn_Location": "-",
                    "TotalHours": "00:00",
                    "WorkingHours": "00:00",
                    "LastOut": "-",
                    "DeviationTime": "08:00",
                    "ShiftEndTime": "06:00 AM"
                }
            },
            "employeeDetails": {
                "mail id": "karthiga.g@abc.com",
                "erecno": "609835000000452023",
                "last name": "Selvi",
                "first name": "Karthiga",
                "id": "2"
            }
        }
    ],
    "message": "Success",
    "uri": "/api/attendance/getUserReport",
    "status": 0
}