invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

TestExpanded: Knack Tests

insert update delete REST

  • Catalogue : Knack
  • Schéma : Objects
  • Clés primaires : record_id
  • Label: Tests

Permet de récupérer et de modifier des données à l'aide de insert, update et delete.

Source de l'API

  • Point de terminaison : /objects/object_4/records

Colonnes de table

Les colonnes de la table TestExpanded sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données Label Required Marks Documentation
AddressWithGeocoding_city varchar2 itgen_knack_addresswithgeocoding_city
AddressWithGeocoding_latitude decimal itgen_knack_addresswithgeocoding_latitude
AddressWithGeocoding_longitude decimal itgen_knack_addresswithgeocoding_longitude
AddressWithGeocoding_state varchar2 itgen_knack_addresswithgeocoding_state
AddressWithGeocoding_street varchar2 itgen_knack_addresswithgeocoding_street
AddressWithGeocoding_street2 varchar2 itgen_knack_addresswithgeocoding_street2
AddressWithGeocoding_zip varchar2 itgen_knack_addresswithgeocoding_zip
Auto_Increment decimal itgen_knack_auto_increment {"type":"auto_increment","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f689643b3e682001590b4ca","name":"Auto Increment","key":"field_21","object_key":"object_4","relationship":null,"format":null,"default":null,"immutable":null}
Currency decimal itgen_knack_currency {"type":"currency","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6896274395f40015a3df57","name":"Currency","key":"field_19","object_key":"object_4","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":"","immutable":null}
Date_Time datetime itgen_knack_date_time
Email_email varchar2 itgen_knack_email_email
Email_label varchar2 itgen_knack_email_label
Equation decimal itgen_knack_equation
File_data blob itgen_knack_file_data
File_filename varchar2 itgen_knack_file_filename
File_s3 char itgen_knack_file_s3
File_size int32 itgen_knack_file_size
File_thumb_url varchar2 itgen_knack_file_thumb_url
File_type varchar2 itgen_knack_file_type
File_url varchar2 itgen_knack_file_url
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
IntlAddress_city varchar2 itgen_knack_intladdress_city
IntlAddress_state varchar2 itgen_knack_intladdress_state
IntlAddress_street varchar2 itgen_knack_intladdress_street
IntlAddress_street2 varchar2 itgen_knack_intladdress_street2
IntlAddress_zip varchar2 itgen_knack_intladdress_zip
IntlAddressLatLng_latitude decimal itgen_knack_intladdresslatlng_latitude
IntlAddressLatLng_longitude decimal itgen_knack_intladdresslatlng_longitude
IntlAddressWithCountry_city varchar2 itgen_knack_intladdresswithcountry_city
IntlAddressWithCountry_country varchar2 itgen_knack_intladdresswithcountry_country
IntlAddressWithCountry_state varchar2 itgen_knack_intladdresswithcountry_state
IntlAddressWithCountry_street varchar2 itgen_knack_intladdresswithcountry_street
IntlAddressWithCountry_street2 varchar2 itgen_knack_intladdresswithcountry_street2
IntlAddressWithCountry_zip varchar2 itgen_knack_intladdresswithcountry_zip
Link_label varchar2 itgen_knack_link_label
Link_url varchar2 itgen_knack_link_url
Multiple_Choice varchar2 itgen_knack_multiple_choice {"type":"multiple_choice","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f689646b3e682001590b4de","name":"Multiple Choice","key":"field_22","object_key":"object_4","relationship":null,"format":{"input":null,"conn_default":null,"default":"kn-blank","sorting":"alphabetical","type":"single","options":["First Choice","Second Choice","Third Choice"],"format":null,"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}
Name_firstname varchar2 itgen_knack_name_firstname
Name_lastname varchar2 itgen_knack_name_lastname
Name_middlename varchar2 itgen_knack_name_middlename
Name_title varchar2 itgen_knack_name_title
Number decimal itgen_knack_number {"type":"number","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6896244395f40015a3df4e","name":"Number","key":"field_18","object_key":"object_4","relationship":null,"format":{"input":null,"conn_default":null,"default":null,"sorting":null,"type":null,"options":null,"format":"none","mark_decimal":"none","mark_thousands":"none","precision":"2","rounding":"none","show_commas":null,"pre":null,"post":null,"text_format":null,"label":null,"enable_geocoding":false,"equation_type":null},"default":"","immutable":null}
Paragraph_Text varchar2 itgen_knack_paragraph_text {"type":"paragraph_text","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f689601b3e682001590b418","name":"Paragraph Text","key":"field_15","object_key":"object_4","relationship":null,"format":null,"default":"","immutable":null}
Phone varchar2 itgen_knack_phone
Rating decimal itgen_knack_rating {"type":"rating","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6896823758ec001589d9cd","name":"Rating","key":"field_35","object_key":"object_4","relationship":null,"format":{"input":null,"conn_default":null,"default":null,"sorting":null,"type":null,"options":null,"format":null,"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}
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":"696a8b987297df53c6ed6de3","name":"Record ID","key":"field_97","object_key":null,"relationship":null,"format":null,"default":null,"immutable":true}
Rich_Text varchar2 itgen_knack_rich_text {"type":"rich_text","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f689604b3e682001590b425","name":"Rich Text","key":"field_16","object_key":"object_4","relationship":null,"format":null,"default":"","immutable":null}
Signature_base30 varchar2 itgen_knack_signature_base30
Signature_svg varchar2 itgen_knack_signature_svg
Test_Name varchar2 itgen_knack_test_name {"type":"short_text","required":true,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6895f53838c00015ce7fc7","name":"Test Name","key":"field_14","object_key":null,"relationship":null,"format":null,"default":null,"immutable":null}
Text_Formula varchar2 itgen_knack_text_formula {"type":"concatenation","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f68961f4395f40015a3df44","name":"Text Formula","key":"field_17","object_key":"object_4","relationship":null,"format":{"input":null,"conn_default":null,"default":null,"sorting":null,"type":null,"options":null,"format":null,"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":"numeric"},"default":null,"immutable":null}
Timer_from_min datetime itgen_knack_timer_from_min
Timer_stop_count int32 itgen_knack_timer_stop_count
Timer_to_max datetime itgen_knack_timer_to_max
Timer_total_time int64 itgen_knack_timer_total_time
USAddress_city varchar2 itgen_knack_usaddress_city
USAddress_state varchar2 itgen_knack_usaddress_state
USAddress_street varchar2 itgen_knack_usaddress_street
USAddress_street2 varchar2 itgen_knack_usaddress_street2
USAddress_zip varchar2 itgen_knack_usaddress_zip
Yes_No char itgen_knack_yes_no {"type":"boolean","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6896494395f40015a3dfcf","name":"Yes/No","key":"field_23","object_key":"object_4","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}

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :