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

Contactos: contactos de Knack

insert update delete REST

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

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

Fuente de la API

  • Punto final: /objects/object_7/records

Columnas de la Tabla

A continuación se muestran las columnas de la tabla Contacts. 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
Address_city varchar2 itgen_knack_address_city
Address_state varchar2 itgen_knack_address_state
Address_street varchar2 itgen_knack_address_street
Address_street2 varchar2 itgen_knack_address_street2
Address_zip varchar2 itgen_knack_address_zip
Birthday datetime itgen_knack_birthday
Company_id varchar2 itgen_knack_company_id
Company_identifier varchar2 itgen_knack_company_identifier
Contacts_Name varchar2 itgen_knack_contacts_name {"type":"short_text","required":true,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6a3c27e5aef10018c5203b","name":"Nombre de contacto","key":"field_48","object_key":null,"relationship":null,"format":null,"default":null,"immutable":null}
Email_email varchar2 itgen_knack_email_email
Email_label varchar2 itgen_knack_email_label
Gender varchar2 itgen_knack_gender {"type":"multiple_choice","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6a3c27e5aef10018c5203e","name":"Gender","key":"field_51","object_key":null,"relationship":null,"format":{"input":null,"conn_default":null,"default":"kn-blank","sorting":"alphabetical","type":"single","options":["Female","Male"],"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}
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
Notes varchar2 itgen_knack_notes {"type":"paragraph_text","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6a3c27e5aef10018c52044","name":"Notes","key":"field_56","object_key":null,"relationship":null,"format":null,"default":null,"immutable":null}
Occupation varchar2 itgen_knack_occupation {"type":"short_text","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6a3c27e5aef10018c52040","name":"Occupation","key":"field_52","object_key":null,"relationship":null,"format":null,"default":null,"immutable":null}
Phone varchar2 itgen_knack_phone
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":"696a8b987297df53c6ed6de9","name":"ID de registro","key":"field_100","object_key":null,"relationship":null,"format":null,"default":null,"immutable":true}

Notas de la Versión

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