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. |
`` |
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_ |
int32 |
Base Offset End Date | filters on the platform, writable | ||
checklist |
varchar2 |
Checklist | filters on the platform, writable | ||
company_ |
varchar2 |
itgen_gripp_company_discr | writable, company. |
||
company_ |
int32 |
Company ID | filters on the platform, writable, company. |
||
company_ |
varchar2 |
Company Search Name | writable, company. |
||
completedon_ |
datetime |
Completed on (Date) | filters on the platform, writable, completedon. |
||
completedon_ |
varchar2 |
Completed on (Time Zone) | writable, completedon. |
||
completedon_ |
int32 |
Completed on (Time Zone Type) | writable, completedon. |
||
content |
varchar2 |
Content | filters on the platform, writable | ||
createdon_ |
datetime |
Created on Date | filters on the platform, writable, createdon. |
||
createdon_ |
varchar2 |
Created on Time Zone | writable, createdon. |
||
createdon_ |
int32 |
Created on Time Zone Type | writable, createdon. |
||
deadlinedate_ |
datetime |
Deadline Date (Date) | filters on the platform, writable, deadlinedate. |
||
deadlinedate_ |
varchar2 |
Deadline Date (Time Zone) | writable, deadlinedate. |
||
deadlinedate_ |
int32 |
Deadline Date (Time Zone Type) | writable, deadlinedate. |
||
deadlinetime |
datetime |
Deadline Time | filters on the platform, writable, deadlinetime. |
||
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_ |
varchar2 |
itgen_gripp_offerprojectbase_discr | writable, offerprojectbase. |
||
offerprojectbase_ |
int32 |
Offer Project Base ID | filters on the platform, writable, offerprojectbase. |
||
offerprojectbase_ |
varchar2 |
Offer Project Base Search Name | writable, offerprojectbase. |
||
offerprojectline_ |
varchar2 |
itgen_gripp_offerprojectline_discr | writable, offerprojectline. |
||
offerprojectline_ |
int32 |
Offer Project Line ID | filters on the platform, writable, offerprojectline. |
||
offerprojectline_ |
varchar2 |
Offer Project Line Search Name | writable, offerprojectline. |
||
packet_ |
varchar2 |
itgen_gripp_packet_discr | writable, packet. |
||
packet_ |
int32 |
Packet ID | filters on the platform, writable, packet. |
||
packet_ |
varchar2 |
Packet Search Name | writable, packet. |
||
phase_ |
varchar2 |
itgen_gripp_phase_discr | writable, phase. |
||
phase_ |
int32 |
Phase ID | filters on the platform, writable, phase. |
||
phase_ |
varchar2 |
Phase Search Name | writable, phase. |
||
preferredemployee_ |
varchar2 |
itgen_gripp_preferredemployee_discr | writable, preferredemployee. |
||
preferredemployee_ |
int32 |
Preferred Employee ID | filters on the platform, writable, preferredemployee. |
||
preferredemployee_ |
varchar2 |
Preferred Employee Search Name | writable, preferredemployee. |
||
searchname |
varchar2 |
Search Name | filters on the platform, writable | ||
startdate_ |
datetime |
Start Date Date | filters on the platform, writable, startdate. |
||
startdate_ |
varchar2 |
Start Date Time Zone | writable, startdate. |
||
startdate_ |
int32 |
Start Date Time Zone Type | writable, startdate. |
||
type_ |
varchar2 |
itgen_gripp_type_discr | writable, type. |
||
type_ |
int32 |
Type ID | filters on the platform, writable, type. |
||
type_ |
varchar2 |
Type Search Name | writable, type. |
||
updatedon_ |
datetime |
Updated on Date | filters on the platform, writable, updatedon. |
||
updatedon_ |
varchar2 |
Updated on Time Zone | writable, updatedon. |
||
updatedon_ |
int32 |
Updated on Time Zone Type | writable, updatedon. |
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