BAbamboohr
Time Tracking
Public API

Get Time Tracking Import Row

Changed on

Retrieves a single row of a time tracking import, including anything on it that failed validation and anything the import corrected. Rows of a soft-deleted import are not returned.

OAuth Scopes: time_tracking:imports

get/api/v1/time-tracking/imports/{id}/rows/{rowId}

Request

Path parameters

idinteger required

The import ID.

rowIdinteger required

The import row ID.

Response

Successfully retrieved the row.

idinteger

Identifier for the row.

importIdinteger

Identifier of the import the row belongs to.

rowNumberinteger

Position of the row in the uploaded file, counting the data rows from 1.

employeeNumberstring

Employee number the hours belong to.

dateWorkedstring

Date the hours were worked, as YYYY-MM-DD. A row failing date validation keeps the value the file supplied.

hoursWorkedstring

Hours worked, to at most four decimal places.

rateType'REGULAR' | 'OVERTIME' | 'DOUBLE_TIME' nullable

How the hours are paid. Null when the file supplied a value that is not a recognized rate type.

payRatestring nullable

Hourly rate the hours are paid at.

payCodestring nullable

Pay code applied to the hours.

projectNamestring nullable

Project the hours are tracked against.

taskNamestring nullable

Task the hours are tracked against.

shiftDifferentialNamestring nullable

Shift differential applied to the hours.

holidayNamestring nullable

Company holiday the hours are attributed to.

qualifiedOvertimeHoursstring nullable

Hours that qualify for overtime, to at most four decimal places.

errorsobject nullable

Validation failures keyed by the field that failed, or null when the row is valid.

correctionsobject nullable

Values the import corrected on the caller's behalf, keyed by field, or null when nothing was corrected. Each entry carries the value the file supplied and the corrections applied to it.

timeTrackingIdstring nullable

Identifier of the time tracking record the row created. Null until the import is executed.

Example response

{
  "id": 412,
  "importId": 77,
  "rowNumber": 3,
  "employeeNumber": "134",
  "dateWorked": "2026-05-11",
  "hoursWorked": "7.5",
  "rateType": "REGULAR",
  "payRate": "15.67",
  "payCode": "Holiday",
  "projectName": "Website Redesign",
  "taskName": "Copywriting",
  "shiftDifferentialName": "Night Shift",
  "holidayName": "Independence Day",
  "qualifiedOvertimeHours": "2.25",
  "errors": {
    "dateWorked": "invalidDateHoursWorked"
  },
  "corrections": {
    "hoursWorked": {
      "original": "7.00000",
      "corrections": [
        "hoursWorkedRounded"
      ]
    }
  },
  "timeTrackingId": "import_5f2b1c0d9a8e7f6a5b4c3d2e1f0a9b"
}

Changes