invantive documentation
Forum di supporto InvantiveAccedi / Registrati

Test: test di Knack

insert update delete REST

  • Catalogo: Knack
  • Schema: Objects
  • Chiavi primarie: record_id
  • Etichetta: Test

È possibile recuperare e modificare i dati utilizzando insert, update e delete.

Codice sorgente dell'API

  • Punto finale: /objects/object_4/records

Colonne della tabella

Di seguito sono riportate le colonne della tabella Test. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati 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":"Incremento automatico","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_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_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":"Scelta multipla","key":"field_22","object_key":"object_4","relationship":null,"format":{"input":null,"conn_default":null,"default":"kn-blank","sorting":"alphabetical","type":"single","options":["Prima scelta","Seconda scelta","Terza scelta"],"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":"ID record","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":"Nome test","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":"Formula di testo","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}

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: