invantive documentation
Invantive Support ForumsLog In / Sign Up

TaskFiles: Gripp CRM Task Files

read only REST

  • Catalog: GrippCrm
  • Schema: GrippCrm
  • Label: Task Files

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.

Table Columns

The columns of the table TaskFiles 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
file_id int32 File ID filters on the platform, writable, id
file_searchname varchar2 File Search Name filters on the platform, writable, searchname
parent_id int32 itgen_gripp_parent_id filters on the platform, writable, ::ancestor.id

Keys

Key Column Refers to Kind Description
TaskFiles_file_id_fk file_id Files.id Key
TaskFiles_parent_id_fk parent_id Tasks.id Key

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 GrippCrm..TaskFiles is renamed to GrippCrm.GrippCrm.TaskFiles

A statement that names GrippCrm..TaskFiles fails after the upgrade; use GrippCrm.GrippCrm.TaskFiles. The table has 3 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