invantive documentation
Invantive Support ForumsLog In / Sign Up

testpho: Knack testphos

insert update delete REST

  • Catalog: Knack
  • Schema: Objects
  • Primary Keys: record_id
  • Label: testphos

Can retrieve data and change data using insert, update and delete.

API Source

  • Endpoint: /objects/object_12/records

Table Columns

The columns of the table testpho 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
datefield datetime itgen_knack_datefield
record_id varchar2 itgen_knack_record_id
Record_ID_1 varchar2 itgen_knack_record_id_1 {"type":"short_text","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"696a8b987297df53c6ed6df3","name":"Record ID","key":"field_105","object_key":null,"relationship":null,"format":null,"default":null,"immutable":true}
Revenue_FY0_Criteria_#1 varchar2 {res:itgen_knack_revenue_fy0_criteria_#1} {"type":"short_text","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"6418457016ee4400280d2a0c","name":"Revenue FY0 Criteria #1","key":"field_93","object_key":null,"relationship":null,"format":null,"default":null,"immutable":null}
text varchar2 itgen_knack_text {"type":"short_text","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5fc8c1038c3dfe001deaceca","name":"text","key":"field_91","object_key":"object_12","relationship":null,"format":null,"default":"","immutable":null}

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: