invantive documentation
Invantive Support ForumsLog In / Sign Up

Employees: Visma.net Financials Employees

insert REST

  • Catalog: VismaNet
  • Schema: Employee
  • Label: Employees

Get a range of employees - ScreenId=EP203000 Request page size must be lower or equal to the allowed max page size which is returned as part of the metadata information. If requested page size is greater than allowed max page size, request will be limited to max page size Change log: 2021-October:Added forced pagination

Can retrieve data and change data using insert.

API Source

  • Endpoint: /v1/employee
  • Operation: get /v1/employee

Performance Characteristics

Characteristic Value
Average access latency (ms) 155
Full scan rows per minute 29,100
Point query rows per minute 387

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
greaterThanValue `` Greater-than value. The item which is the object for this, varies from API to API.
lastModifiedDateTime `` This value, generated by the system, indicates the last time the record was modified. Use it to retrieve all records that have been modified since that time, up to the present. Accepted format: * yyyy-MM-dd * yyyy-MM-dd HH:mm:ss * yyyy-MM-dd HH:mm:ss.FFF * yyyy-MM-ddTHH:mm:ss * yyyy-MM-ddTHH:mm:ss.FFF Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.
lastModifiedDateTimeCondition `` This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.
linkedToUser `` If the employee is linked to a user.

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
COMPANY_CODE varchar2(30) Company Code writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) Company Name writable Name of the partition.
address_addressId int32 Address ID filters on the platform, writable, address.addressId
address_addressLine1 varchar2 Address Line 1 filters on the platform, writable, address.addressLine1 Address 1 > The first line of the customer's/supplier's/company's/employee's contact address.
address_addressLine2 varchar2 Address Line 2 filters on the platform, writable, address.addressLine2 Address 2 > The second line of the address.
address_addressLine3 varchar2 Address Line 3 filters on the platform, writable, address.addressLine3 Address 3 > The third line of the address.
address_city varchar2 City filters on the platform, writable, address.city City > The city.
address_country_errorInfo varchar2 itgen_vnet_address_country_errorinfo filters on the platform, writable, address.country.errorInfo
address_country_id varchar2 Country ID filters on the platform, writable, address.country.id Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166.
address_country_metadata_maxPageSize int64 itgen_vnet_address_country_metadata_maxpagesize filters on the platform, writable, address.country.metadata.maxPageSize
address_country_metadata_totalCount int64 itgen_vnet_address_country_metadata_totalcount filters on the platform, writable, address.country.metadata.totalCount
address_country_name varchar2 Country Name filters on the platform, writable, address.country.name Mandatory field: Country name* > The complete name of the country.
address_county_id varchar2 County ID filters on the platform, writable, address.county.id Click the magnifier > The identifier
address_county_name varchar2 County Name filters on the platform, writable, address.county.name Click the magnifier > The displayed name
address_postalCode varchar2 Postal Code filters on the platform, writable, address.postalCode Postcode > The postcode.
branch_name varchar2 Branch Name filters on the platform, writable, branch.name Click the magnifier. > The name.
branch_number varchar2 Branch Number filters on the platform, writable, branch.number Click the magnifier. > The identifier.
calendarID varchar2 Calendar ID filters on the platform, writable, calendarID
contact_attention varchar2 itgen_vnet_contact_attention filters on the platform, writable, contact.attention Attention > The attention line as it is used in your customer's/supplier's/company's business letters. The intention of this line is to direct the letter to the right person if the letter is not addressed to any specific person.
contact_contactId int32 Contact ID filters on the platform, writable, contact.contactId
contact_email varchar2 Contact Email filters on the platform, writable, contact.email Email > The email address of the customer/supplier/company as a business entity.
contact_employeeContact varchar2 Contact Employee Contact filters on the platform, writable, contact.employeeContact Employee contact > The link to the contact record associated with the employee.
contact_fax varchar2 Contact Fax filters on the platform, writable, contact.fax Fax > The fax number.
contact_firstName varchar2 Contact First Name filters on the platform, writable, contact.firstName First name > The first name of the employee.
contact_lastName varchar2 Contact Last Name filters on the platform, writable, contact.lastName Mandatory field: Last name* > The last name of the employee.
contact_midName varchar2 Contact Middle Name filters on the platform, writable, contact.midName Middle name > The middle name of the employee.
contact_name varchar2 Contact Name filters on the platform, writable, contact.name Name > The legal name of to appear on the documents.
contact_phone1 varchar2 Contact Phone 1 filters on the platform, writable, contact.phone1 Phone 1 > The default phone number.
contact_phone2 varchar2 Contact Phone 2 filters on the platform, writable, contact.phone2 Phone 2 > An additional phone number.
contact_phone3 varchar2 Contact Phone 3 filters on the platform, writable, contact.phone3 Phone 3 > An additional phone number of the employee.
contact_title varchar2 Contact Title filters on the platform, writable, contact.title Title > The courtesy title to be used for the employee.
contact_web varchar2 Contact Website filters on the platform, writable, contact.web Web > The website of the company, if one exists.
department varchar2 Department filters on the platform, writable, department Mandatory field: General information tab > Employee section > Department* > The department the employee works for.
employeeClass_description varchar2 Employee Class Description filters on the platform, writable, employeeClass.description Click on the magnifier. > The description.
employeeClass_id varchar2 Employee Class ID filters on the platform, writable, employeeClass.id Click on the magnifier. > The identifier.
employeeId int32 Employee ID filters on the platform, writable, employeeId Mandatory field: The top part > Employee ID* > The unique identifier, which is assigned to the employee in accordance with the configuration of the EMPLOYEE segmented key.
employeeLogin varchar2 Employee Login filters on the platform, writable, employeeLogin
employeeName varchar2 Employee Name filters on the platform, writable, employeeName The top part > Employee name > The name of this employee.
employeeNumber varchar2 Employee Number filters on the platform, writable, employeeNumber General information tab > Employee settings section > Employee ref. no. > A reference number for the employee.
employeeUserId guid Employee User ID filters on the platform, writable, employeeUserId Employee internal user ID. This is the ID of the user linked to the employee
errorInfo varchar2 Error Message filters on the platform, writable, errorInfo
lastModifiedDateTime datetime Last Modified filters on the platform, writable, lastModifiedDateTime
metadata_maxPageSize int64 Metadata Max Pagesize filters on the platform, writable, metadata.maxPageSize
metadata_totalCount int64 Total Count filters on the platform, writable, metadata.totalCount
status varchar2 Status filters on the platform, writable, status Mandatory field: The top part > Status > The status of the employee. The following options are available: Active, On hold, Hold payments, Inactive, One-time.
timeStamp blob Timestamp filters on the platform, writable, timeStamp Identifier that represents a specific version of the resource. It helps to prevent simultaneous updates of the resource from overwriting each other (by using ETags and If-Match headers)

Keys

Key Column Refers to Kind Description
Employees_branch_number_fk branch_number Branches.number Key

Release Notes

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