invantive documentation
Invantive Support ForumsLog In / Sign Up

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.id ``

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_discr varchar2 itgen_gripp_appointmenttype_discr writable, appointmenttype.discr
appointmenttype_id int32 Appointment Type ID filters on the platform, writable, appointmenttype.id
appointmenttype_searchname varchar2 Appointment Type Search Name writable, appointmenttype.searchname
calendaritem_discr varchar2 itgen_gripp_calendaritem_discr writable, calendaritem.discr
calendaritem_id int32 Calendar Item ID filters on the platform, writable, calendaritem.id
calendaritem_searchname varchar2 Calendar Item Search Name writable, calendaritem.searchname
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
contact_discr varchar2 itgen_gripp_contact_discr writable, contact.discr
contact_id int32 Contact ID filters on the platform, writable, contact.id
contact_searchname varchar2 Contact Search Name writable, contact.searchname
contract_discr varchar2 itgen_gripp_contract_discr writable, contract.discr
contract_id int32 Contract ID filters on the platform, writable, contract.id
contract_searchname varchar2 Contract Search Name writable, contract.searchname
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
date_date datetime Date Date filters on the platform, writable, date.date
date_timezone varchar2 Date Time Zone writable, date.timezone
date_timezone_type int32 Date Time Zone Type writable, date.timezone_type
employee_discr varchar2 itgen_gripp_employee_discr writable, employee.discr
employee_id int32 Employee ID filters on the platform, writable, employee.id
employee_searchname varchar2 Employee Search Name writable, employee.searchname
extendedproperties varchar2 Extended Properties filters on the platform, writable
id int32 ID filters on the platform, writable
invoice_discr varchar2 itgen_gripp_invoice_discr writable, invoice.discr
invoice_id int32 Invoice ID filters on the platform, writable, invoice.id
invoice_searchname varchar2 Invoice Search Name writable, invoice.searchname
message varchar2 Message filters on the platform, writable
offer_discr varchar2 itgen_gripp_offer_discr writable, offer.discr
offer_id int32 Offer ID filters on the platform, writable, offer.id
offer_searchname varchar2 Offer Search Name writable, offer.searchname
project_discr varchar2 itgen_gripp_project_discr writable, project.discr
project_id int32 Project ID filters on the platform, writable, project.id
project_searchname varchar2 Project Search Name writable, project.searchname
purchaseinvoice_discr varchar2 itgen_gripp_purchaseinvoice_discr writable, purchaseinvoice.discr
purchaseinvoice_id int32 Purchase Invoice ID filters on the platform, writable, purchaseinvoice.id
purchaseinvoice_searchname varchar2 Purchase Invoice Search Name writable, purchaseinvoice.searchname
purchaseorder_discr varchar2 itgen_gripp_purchaseorder_discr writable, purchaseorder.discr
purchaseorder_id int32 Purchase Order ID filters on the platform, writable, purchaseorder.id
purchaseorder_searchname varchar2 Purchase Order Search Name writable, purchaseorder.searchname
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_discr varchar2 itgen_gripp_task_discr writable, task.discr
task_id int32 Task ID filters on the platform, writable, task.id
task_searchname varchar2 Task Search Name writable, task.searchname
timelinetype_discr varchar2 itgen_gripp_timelinetype_discr writable, timelinetype.discr
timelinetype_id int32 Timeline Type ID filters on the platform, writable, timelinetype.id
timelinetype_searchname varchar2 Timeline Type Search Name writable, timelinetype.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..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

All changes of the driver, 26.0 to 27.0