invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

TestExpanded: Pruebas de Knack

insert update delete REST

  • Catálogo: Knack
  • Esquema: Objects
  • Llaves Primarias: record_id
  • Etiqueta: Pruebas

Permite recuperar y modificar datos utilizando insert, update y delete.

Fuente de la API

  • Punto final: /objects/object_4/records

Columnas de la Tabla

A continuación se muestran las columnas de la tabla TestExpanded. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos 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 automático","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":"Opción múltiple","key":"field_22","object_key":"object_4","relationship":null,"format":{"input":null,"conn_default":null,"default":"kn-blank","sorting":"alphabetical","type":"single","options":["Primera opción","Segunda opción","Tercera opción"],"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 de registro","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":"Nombre de prueba","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":"Fórmula de texto","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}

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: