invantive documentation
Invantive Support ForumsLog In / Sign Up

ContractRatesBasic: Horeko Contract Rates (basic)

read only REST

  • Catalog: Horeko
  • Schema: Contracts
  • Label: Contract Rates (basic)

Returns rates Returns list of rates. Available sort options: Id, StartDate, EndDate, HourlyRate, ContractId.

Can only retrieve data.

API Source

  • Endpoint: /v4/contracts/rates
  • Operation: get /v4/contracts/rates

Parameters

Name Data Type Required Default Documentation
activeDate `` get only rates that are active for this specific date (format yyyy-mm-dd hh:mm:ss)
sortBy `` comma separated list of available options for sorting
sortDescending `` true = descending | false = asceding. default is false

Table Columns

The columns of the table ContractRatesBasic 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
ContractId int32 Contract ID
CreateDate datetime Create Date
EndDate datetime End Date
HourlyRate double Hourly Rate
Id int32 ID
StartDate datetime Start Date
UpdateDate datetime Update date

Release Notes

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