BAbamboohr
Employee Tables
Public API

Create Table Row (v1)

Changed on

Deprecated. Use Create Table Row (v1.1) instead (create-table-row-v1_1). Add a new row to the specified employee table by submitting field name/value pairs in JSON or XML. Use this endpoint to append records to tabular employee data such as job information or compensation history.

OAuth Scopes: employee, employee.write, employee:assets.write, employee:compensation.write, employee:custom_fields.write, employee:custom_fields_encrypted.write, employee:education.write, employee:emergency_contacts.write, employee:job, employee:job.write, sensitive_employee:creditcards.write

post/api/v1/employees/{id}/tables/{table}

Request

  • Base URL
    https://companySubDomain.bamboohr.com
  • Auth
    • HTTP basic
    • or OAuth 2
      Authorization code/authorize.php
      Token URL/token.php
      Scopesemployee.write
    • or OAuth 2
      Authorization code/authorize.php
      Token URL/token.php
      Scopesemployee:job.write
    • or OAuth 2
      Authorization code/authorize.php
      Token URL/token.php
      Scopesemployee:compensation.write
    • or OAuth 2
      Authorization code/authorize.php
      Token URL/token.php
      Scopesemployee:custom_fields.write
    • or OAuth 2
      Authorization code/authorize.php
      Token URL/token.php
      Scopesemployee:custom_fields_encrypted.write
    • or OAuth 2
      Authorization code/authorize.php
      Token URL/token.php
      Scopesemployee:assets.write
    • or OAuth 2
      Authorization code/authorize.php
      Token URL/token.php
      Scopesemployee:emergency_contacts.write
    • or OAuth 2
      Authorization code/authorize.php
      Token URL/token.php
      Scopessensitive_employee:creditcards.write
    • or OAuth 2
      Authorization code/authorize.php
      Token URL/token.php
      Scopesemployee:education.write
    • or OAuth 2
      Authorization code/authorize.php
      Token URL/token.php
      Scopesemployee
    • or OAuth 2
      Authorization code/authorize.php
      Token URL/token.php
      Scopesemployee:job
  • TypeScript
    A function with typed inputs. Its response is checked against the schema.

Path parameters

idstring required

The employee ID.

tablestring required

The API name of an employee table. Standard table names: jobInfo, compensation, employmentStatus, contacts, emergencyContacts, dependents, earnings, bonus, commission, benefit_class, employeeVisas, employeeEducation, employeePassports, employeeDriverLicenses, employeeCertifications, employeeStockOptions, employeeAssets, employeeCreditCards, employeeCovidTests, employeeCovidVaccinations, employeeCovidVaccinationExemptions, employeeCovidExposures, employeeEquityGrants, employeeProjectPayRates. Custom company-defined tables also accepted — they use a numeric suffix (e.g., custom1, custom42). Use the list-tabular-fields tool (GET /api/v1/meta/tables) to discover custom table names for a specific company.

Example:employeeEducation

The API name of the table to add a row to. See the TableName schema for valid standard values; custom tables use a custom prefix. Use GET /api/v1/meta/tables to discover the complete list.

Request body

datestring date

The effective date for the row in YYYY-MM-DD format.

locationstring

The employee location value for the row.

divisionstring

The division value for the row.

departmentstring

The department value for the row.

jobTitlestring

The job title value for the row.

reportsTostring

The manager or reports-to value for the row.

teamsstring[]

Team values associated with the row.

Response

Row added successfully. No response body is returned.

Changes

  • 922fc15f43a7Revision changes
    • info

      the security scope employee.write was added to the endpoint's security scheme oauth

    • info

      the security scope employee:job was removed from the endpoint's security scheme oauth