invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

ProductsExpanded: Knack Products

insert update delete REST

  • Catalogus: Knack
  • Schema: Objects
  • Primaire sleutels: record_id
  • Label: Products

Je kunt gegevens ophalen en wijzigen met insert, update en delete.

API-bron

  • Eindpunt: /objects/object_3/records

Tabelkolommen

De kolommen van de tabel ProductsExpanded worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
Available char itgen_knack_available {"type":"boolean","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f68423c4395f40015a2f020","name":"Available","key":"field_13","object_key":null,"relationship":null,"format":{"input":"dropdown","conn_default":null,"default":"false","sorting":null,"type":null,"options":null,"format":"yes_no","mark_decimal":null,"mark_thousands":null,"precision":null,"rounding":null,"show_commas":null,"pre":null,"post":null,"text_format":null,"label":null,"enable_geocoding":false,"equation_type":null},"default":"false","immutable":null}
Description varchar2 itgen_knack_description {"type":"paragraph_text","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f68423b4395f40015a2f01e","name":"Description","key":"field_11","object_key":null,"relationship":null,"format":null,"default":null,"immutable":null}
Image_data blob itgen_knack_image_data
Image_filename varchar2 itgen_knack_image_filename
Image_s3 char itgen_knack_image_s3
Image_size int32 itgen_knack_image_size
Image_thumb_url varchar2 itgen_knack_image_thumb_url
Image_type varchar2 itgen_knack_image_type
Image_url varchar2 itgen_knack_image_url
Price decimal itgen_knack_price {"type":"currency","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f68423b4395f40015a2f01f","name":"Price","key":"field_12","object_key":null,"relationship":null,"format":{"input":null,"conn_default":null,"default":null,"sorting":null,"type":null,"options":null,"format":"$","mark_decimal":null,"mark_thousands":null,"precision":null,"rounding":null,"show_commas":null,"pre":null,"post":null,"text_format":null,"label":null,"enable_geocoding":false,"equation_type":null},"default":null,"immutable":null}
Product_ID decimal itgen_knack_product_id {"type":"auto_increment","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f68423b4395f40015a2f01c","name":"Product ID","key":"field_9","object_key":null,"relationship":null,"format":null,"default":null,"immutable":null}
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":"696a8b987297df53c6ed6de1","name":"Record ID","key":"field_96","object_key":null,"relationship":null,"format":null,"default":null,"immutable":true}

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: