TimelineEntryById: Gripp CRM Timeline Entry by ID
read only REST
- Catalog:
GrippCrm - Schema:
GrippCrm - Primary Keys:
id - Label: Timeline Entry 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 |
|---|---|---|---|---|
timelineentry. |
`` |
Table Columns
The columns of the table TimelineEntryById 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 |
|---|---|---|---|---|---|
appointmenttype_ |
varchar2 |
itgen_gripp_appointmenttype_discr | writable, appointmenttype. |
||
appointmenttype_ |
int32 |
Appointment Type ID | filters on the platform, writable, appointmenttype. |
||
appointmenttype_ |
varchar2 |
Appointment Type Search Name | writable, appointmenttype. |
||
calendaritem_ |
varchar2 |
itgen_gripp_calendaritem_discr | writable, calendaritem. |
||
calendaritem_ |
int32 |
Calendar Item ID | filters on the platform, writable, calendaritem. |
||
calendaritem_ |
varchar2 |
Calendar Item Search Name | writable, calendaritem. |
||
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. |
||
contact_ |
varchar2 |
itgen_gripp_contact_discr | writable, contact. |
||
contact_ |
int32 |
Contact ID | filters on the platform, writable, contact. |
||
contact_ |
varchar2 |
Contact Search Name | writable, contact. |
||
contract_ |
varchar2 |
itgen_gripp_contract_discr | writable, contract. |
||
contract_ |
int32 |
Contract ID | filters on the platform, writable, contract. |
||
contract_ |
varchar2 |
Contract Search Name | writable, contract. |
||
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. |
||
date_ |
datetime |
Date Date | filters on the platform, writable, date. |
||
date_ |
varchar2 |
Date Time Zone | writable, date. |
||
date_ |
int32 |
Date Time Zone Type | writable, date. |
||
employee_ |
varchar2 |
itgen_gripp_employee_discr | writable, employee. |
||
employee_ |
int32 |
Employee ID | filters on the platform, writable, employee. |
||
employee_ |
varchar2 |
Employee Search Name | writable, employee. |
||
extendedproperties |
varchar2 |
Extended Properties | filters on the platform, writable | ||
id |
int32 |
ID | filters on the platform, writable | ||
invoice_ |
varchar2 |
itgen_gripp_invoice_discr | writable, invoice. |
||
invoice_ |
int32 |
Invoice ID | filters on the platform, writable, invoice. |
||
invoice_ |
varchar2 |
Invoice Search Name | writable, invoice. |
||
message |
varchar2 |
Message | filters on the platform, writable | ||
offer_ |
varchar2 |
itgen_gripp_offer_discr | writable, offer. |
||
offer_ |
int32 |
Offer ID | filters on the platform, writable, offer. |
||
offer_ |
varchar2 |
Offer Search Name | writable, offer. |
||
project_ |
varchar2 |
itgen_gripp_project_discr | writable, project. |
||
project_ |
int32 |
Project ID | filters on the platform, writable, project. |
||
project_ |
varchar2 |
Project Search Name | writable, project. |
||
purchaseinvoice_ |
varchar2 |
itgen_gripp_purchaseinvoice_discr | writable, purchaseinvoice. |
||
purchaseinvoice_ |
int32 |
Purchase Invoice ID | filters on the platform, writable, purchaseinvoice. |
||
purchaseinvoice_ |
varchar2 |
Purchase Invoice Search Name | writable, purchaseinvoice. |
||
purchaseorder_ |
varchar2 |
itgen_gripp_purchaseorder_discr | writable, purchaseorder. |
||
purchaseorder_ |
int32 |
Purchase Order ID | filters on the platform, writable, purchaseorder. |
||
purchaseorder_ |
varchar2 |
Purchase Order Search Name | writable, purchaseorder. |
||
searchname |
varchar2 |
Search Name | filters on the platform, writable | ||
showinplanning |
char |
Show in Planning | filters on the platform, writable | ||
starred |
char |
Starred | filters on the platform, writable | ||
subject |
varchar2 |
Subject | filters on the platform, writable | ||
task_ |
varchar2 |
itgen_gripp_task_discr | writable, task. |
||
task_ |
int32 |
Task ID | filters on the platform, writable, task. |
||
task_ |
varchar2 |
Task Search Name | writable, task. |
||
timelinetype_ |
varchar2 |
itgen_gripp_timelinetype_discr | writable, timelinetype. |
||
timelinetype_ |
int32 |
Timeline Type ID | filters on the platform, writable, timelinetype. |
||
timelinetype_ |
varchar2 |
Timeline Type Search Name | writable, timelinetype. |
||
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..TimelineEntryById is renamed to GrippCrm.GrippCrm.TimelineEntryById
A statement that names GrippCrm..TimelineEntryById fails after the upgrade; use GrippCrm.GrippCrm.TimelineEntryById. The table function has 55 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