invantive documentation
Invantive Support ForumsLog In / Sign Up

TaskById: Gripp CRM Task by ID

read only REST

  • Catalog: GrippCrm
  • Schema: GrippCrm
  • Primary Keys: id
  • Label: Task by ID

Can only retrieve data.

API Source

  • Endpoint: api3.php

Performance Characteristics

Characteristic Value
Write rows per minute 8,930

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
task.id ``

Table Columns

The columns of the table TaskById 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
base_offset_enddate int32 Base Offset End Date filters on the platform, writable
checklist varchar2 Checklist filters on the platform, writable
company_discr varchar2 itgen_gripp_company_discr writable, company.discr
company_id int32 Company ID filters on the platform, writable, company.id
company_searchname varchar2 Company Search Name writable, company.searchname
completedon_date datetime Completed on (Date) filters on the platform, writable, completedon.date
completedon_timezone varchar2 Completed on (Time Zone) writable, completedon.timezone
completedon_timezone_type int32 Completed on (Time Zone Type) writable, completedon.timezone_type
content varchar2 Content filters on the platform, writable
createdon_date datetime Created on Date filters on the platform, writable, createdon.date
createdon_timezone varchar2 Created on Time Zone writable, createdon.timezone
createdon_timezone_type int32 Created on Time Zone Type writable, createdon.timezone_type
deadlinedate_date datetime Deadline Date (Date) filters on the platform, writable, deadlinedate.date
deadlinedate_timezone varchar2 Deadline Date (Time Zone) writable, deadlinedate.timezone
deadlinedate_timezone_type int32 Deadline Date (Time Zone Type) writable, deadlinedate.timezone_type
deadlinetime datetime Deadline Time filters on the platform, writable, deadlinetime.date
description varchar2 Description filters on the platform, writable
estimatedhours double Estimated Hours filters on the platform, writable
extendedproperties varchar2 Extended Properties filters on the platform, writable
id int32 ID filters on the platform, writable
isafgerond char Is Completed filters on the platform, writable
number int32 Number filters on the platform, writable
offerprojectbase_discr varchar2 itgen_gripp_offerprojectbase_discr writable, offerprojectbase.discr
offerprojectbase_id int32 Offer Project Base ID filters on the platform, writable, offerprojectbase.id
offerprojectbase_searchname varchar2 Offer Project Base Search Name writable, offerprojectbase.searchname
offerprojectline_discr varchar2 itgen_gripp_offerprojectline_discr writable, offerprojectline.discr
offerprojectline_id int32 Offer Project Line ID filters on the platform, writable, offerprojectline.id
offerprojectline_searchname varchar2 Offer Project Line Search Name writable, offerprojectline.searchname
packet_discr varchar2 itgen_gripp_packet_discr writable, packet.discr
packet_id int32 Packet ID filters on the platform, writable, packet.id
packet_searchname varchar2 Packet Search Name writable, packet.zoeknaam
phase_discr varchar2 itgen_gripp_phase_discr writable, phase.discr
phase_id int32 Phase ID filters on the platform, writable, phase.id
phase_searchname varchar2 Phase Search Name writable, phase.searchname
preferredemployee_discr varchar2 itgen_gripp_preferredemployee_discr writable, preferredemployee.discr
preferredemployee_id int32 Preferred Employee ID filters on the platform, writable, preferredemployee.id
preferredemployee_searchname varchar2 Preferred Employee Search Name writable, preferredemployee.searchname
searchname varchar2 Search Name filters on the platform, writable
startdate_date datetime Start Date Date filters on the platform, writable, startdate.date
startdate_timezone varchar2 Start Date Time Zone writable, startdate.timezone
startdate_timezone_type int32 Start Date Time Zone Type writable, startdate.timezone_type
type_discr varchar2 itgen_gripp_type_discr writable, type.discr
type_id int32 Type ID filters on the platform, writable, type.id
type_searchname varchar2 Type Search Name writable, type.searchname
updatedon_date datetime Updated on Date filters on the platform, writable, updatedon.date
updatedon_timezone varchar2 Updated on Time Zone writable, updatedon.timezone
updatedon_timezone_type int32 Updated on Time Zone Type writable, updatedon.timezone_type

Release Notes

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

Changes of This Table, 26.0 to 27.0

Table function GrippCrm..TaskById is renamed to GrippCrm.GrippCrm.TaskById

A statement that names GrippCrm..TaskById fails after the upgrade; use GrippCrm.GrippCrm.TaskById. The table function has 47 columns. The driver registered its objects without a schema in release 26.0; from 27.0 the schema is GrippCrm.

What to Do

Check statements, views and scripts that use it before the upgrade.

  • can break a statement
  • importance 5

All changes of the driver, 26.0 to 27.0