invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectProjectLinesByProjectId: Gripp CRM Project Project Lines by Project ID

read only REST

  • Catalog: GrippCrm
  • Schema: GrippCrm
  • Label: Project Project Lines by Project 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
project.id ``

Table Columns

The columns of the table ProjectProjectLinesByProjectId 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
_ordering int32 Ordering writable
additionalsubject varchar2 Additional Subject writable
amount double Amount writable
buyingprice double Buying Price writable
contractline_discr varchar2 itgen_gripp_contractline_discr writable, contractline.discr
contractline_id int32 Contract Line ID writable, contractline.id
contractline_searchname varchar2 Contract Line Search Name writable, contractline.searchname
convertto_discr varchar2 itgen_gripp_convertto_discr writable, convertto.discr
convertto_id int32 Convert to ID writable, convertto.id
convertto_searchname varchar2 Convert to Search Name writable, convertto.searchname
createdon_date datetime Created on Date 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
description varchar2 Description writable
discount double Discount writable
extendedproperties varchar2 Extended Properties writable
groupcategory_discr varchar2 itgen_gripp_groupcategory_discr writable, groupcategory.discr
groupcategory_id int32 Group Category ID writable, groupcategory.id
groupcategory_searchname varchar2 Group Category Search Name writable, groupcategory.searchname
hidedetails char Hide Details writable
hidefortimewriting char Hide for Time Writing writable
id int32 ID writable
internalnote varchar2 Internal Note writable
invoicebasis_discr varchar2 itgen_gripp_invoicebasis_discr writable, invoicebasis.discr
invoicebasis_id int32 Invoice Basis ID writable, invoicebasis.id
invoicebasis_searchname varchar2 Invoice Basis Search Name writable, invoicebasis.searchname
offerprojectbase_discr varchar2 itgen_gripp_offerprojectbase_discr writable, offerprojectbase.discr
offerprojectbase_id int32 Offer Project Base ID writable, offerprojectbase.id
offerprojectbase_searchname varchar2 Offer Project Base Search Name writable, offerprojectbase.searchname
parent_id int32 itgen_gripp_parent_id filters on the platform, writable, ::ancestor.id
product_discr varchar2 itgen_gripp_product_discr writable, product.discr
product_id int32 Product ID writable, product.id
product_searchname varchar2 Product Search Name writable, product.searchname
rowtype_discr varchar2 itgen_gripp_rowtype_discr writable, rowtype.discr
rowtype_id int32 Rowtype ID writable, rowtype.id
rowtype_searchname varchar2 Rowtype Search Name writable, rowtype.searchname
searchname varchar2 Search Name writable
sellingprice double Selling Price writable
unit_discr varchar2 itgen_gripp_unit_discr writable, unit.discr
unit_id int32 Unit ID writable, unit.id
unit_searchname varchar2 Unit Search Name writable, unit.searchname
updatedon_date datetime Updated on Date 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
vat_discr varchar2 itgen_gripp_vat_discr writable, vat.discr
vat_id int32 VAT ID writable, vat.id
vat_searchname varchar2 VAT Search Name writable, vat.searchname

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

A statement that names GrippCrm..ProjectProjectLinesByProjectId fails after the upgrade; use GrippCrm.GrippCrm.ProjectProjectLinesByProjectId. 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