invantive documentation
Invantive Support ForumsLog In / Sign Up

Employees: Robaws Employees

insert update delete REST

  • Catalog: Robaws
  • Schema: Employees
  • Primary Keys: id
  • Label: Employees

Search

Can retrieve data and change data using insert, update and delete.

API Source

  • Endpoint: /api/v2/employees
  • Operation: get /api/v2/employees

Performance Characteristics

Characteristic Value
Average access latency (ms) 104
Full scan rows per minute 16,530
Point query rows per minute 750
Write rows per minute 539

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
searchText ``
sort ``
updatedFrom ``
withArchived ``

Table Columns

The columns of the table Employees are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
archivedAt datetime Archived at filters on the platform, writable, archivedAt
bankAccountNumber varchar2 Bank Account Number filters on the platform, writable, bankAccountNumber
civilStatus varchar2 Civil Status filters on the platform, writable, civilStatus
collaborationEndDate datetime Collaboration End Date filters on the platform, writable, collaborationEndDate
collaborationStartDate datetime Collaboration Start Date filters on the platform, writable, collaborationStartDate
companyId varchar2 Company ID filters on the platform, writable, companyId
competenceLevel varchar2 Competence Level filters on the platform, writable, competenceLevel
costPerHour decimal Cost per Hour filters on the platform, writable, costPerHour
createdAt datetime Created at filters on the platform, writable, createdAt
dateOfBirth datetime Date of Birth filters on the platform, writable, dateOfBirth
defaultStockLocationId varchar2 Default Stock Location ID filters on the platform, writable, defaultStockLocationId
defaultTimeOperationId varchar2 Default Time Operation ID filters on the platform, writable, defaultTimeOperationId
deletedAt datetime Deleted at filters on the platform, writable, deletedAt
dimonaExpirationDate datetime Dimona Expiration Date filters on the platform, writable, dimonaExpirationDate
dimonaNumber varchar2 Dimona Number filters on the platform, writable, dimonaNumber
distance decimal Distance filters on the platform, writable, distance
domicileAddress_addressLine1 varchar2 Domicile Address Line 1 filters on the platform, writable, domicileAddress.addressLine1
domicileAddress_addressLine2 varchar2 Domicile Address Line 2 filters on the platform, writable, domicileAddress.addressLine2
domicileAddress_city varchar2 Domicile Address City filters on the platform, writable, domicileAddress.city
domicileAddress_country varchar2 Domicile Address Country filters on the platform, writable, domicileAddress.country
domicileAddress_latitude double Domicile Address Latitude filters on the platform, writable, domicileAddress.latitude
domicileAddress_longitude double Domicile Address Longitude filters on the platform, writable, domicileAddress.longitude
domicileAddress_postalCode varchar2 Domicile Address Postal Code filters on the platform, writable, domicileAddress.postalCode
driverLicense varchar2 Driver License filters on the platform, writable, driverLicense
email varchar2 Email filters on the platform, writable, email
emergencyTel varchar2 In Case of Emergency Phone filters on the platform, writable, emergencyTel
employeeRoleId varchar2 Employee Role ID filters on the platform, writable, employeeRoleId
employerId varchar2 Employer ID filters on the platform, writable, employerId
extraFields varchar2 Extra Fields writable The JSON text of the nested object.
fullName varchar2 Full Name filters on the platform, writable, fullName
grossSalary decimal Gross Salary filters on the platform, writable, grossSalary
gsm varchar2 Mobile filters on the platform, writable, gsm
id varchar2 ID filters on the platform, writable, id
identityCardExpirationDate datetime Identity Card Expiration Date filters on the platform, writable, identityCardExpirationDate
identityCardNumber varchar2 Identity Card Number filters on the platform, writable, identityCardNumber
independentRegistration char Independent Registration filters on the platform, writable, independentRegistration
limosaExpirationDate datetime Limosa Expiration Date filters on the platform, writable, limosaExpirationDate
limosaNumber varchar2 Limosa Number filters on the platform, writable, limosaNumber
lockedAt datetime Locked at filters on the platform, writable, lockedAt
name varchar2 Name filters on the platform, writable, name
nationality varchar2 Nationality filters on the platform, writable, nationality
nssoIdNumber varchar2 NSSO ID Number filters on the platform, writable, nssoIdNumber
nssoPayment char NSSO Payment filters on the platform, writable, nssoPayment
nssoPaymentExpirationDate datetime NSSO Payment Expiration Date filters on the platform, writable, nssoPaymentExpirationDate
numberOfDependents int32 Number of Dependents filters on the platform, writable, numberOfDependents
planningGroup varchar2 Planning Group filters on the platform, writable, planningGroup
position varchar2 Position filters on the platform, writable, position
secondment char Secondment filters on the platform, writable, secondment
status varchar2 Status filters on the platform, writable, status
statute varchar2 Statute filters on the platform, writable, statute
subType varchar2 Sub Type filters on the platform, writable, subType
surname varchar2 Last Name filters on the platform, writable, surname
tel varchar2 Phone filters on the platform, writable, tel
type varchar2 Type filters on the platform, writable, type
updatedAt datetime Updated at filters on the platform, writable, updatedAt
weeklyScheduleId varchar2 Weekly Schedule ID filters on the platform, writable, weeklyScheduleId

Keys

Key Column Refers to Kind Description
Employees_companyId_fk companyId Companies.id Key
Employees_defaultStockLocationId_fk defaultStockLocationId StockLocations.id Key
Employees_employeeRoleId_fk employeeRoleId EmployeeRoles.id Key
Employees_employerId_fk employerId Suppliers.id Key

Referenced By

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: