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

Pagos: pagos de Knack

insert update delete REST

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

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

Fuente de la API

  • Punto final: /objects/object_9/records

Columnas de la Tabla

A continuación se muestran las columnas de la tabla Payments. 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
Account_id varchar2 itgen_knack_account_id
Account_identifier varchar2 itgen_knack_account_identifier
Amount decimal itgen_knack_amount {"type":"currency","required":true,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6a3cc770ceeb00154427a5","name":"Amount","key":"field_68","object_key":null,"relationship":null,"format":null,"default":null,"immutable":true}
Charge varchar2 itgen_knack_charge {"type":"concatenation","required":true,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6a3cc770ceeb00154427a4","name":"Charge","key":"field_67","object_key":null,"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":true}
Date datetime itgen_knack_date
Description varchar2 itgen_knack_description {"type":"short_text","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6a3cc770ceeb00154427ac","name":"Description","key":"field_75","object_key":null,"relationship":null,"format":null,"default":null,"immutable":true}
ID varchar2 itgen_knack_id {"type":"short_text","required":true,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6a3cc770ceeb00154427aa","name":"ID","key":"field_73","object_key":null,"relationship":null,"format":null,"default":null,"immutable":true}
IP_Address varchar2 itgen_knack_ip_address {"type":"short_text","required":true,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6a3cc770ceeb00154427ab","name":"Dirección IP","key":"field_74","object_key":null,"relationship":null,"format":null,"default":null,"immutable":true}
Notes varchar2 itgen_knack_notes {"type":"short_text","required":false,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6a3cc770ceeb00154427ad","name":"Notes","key":"field_76","object_key":null,"relationship":null,"format":null,"default":null,"immutable":true}
Processor varchar2 itgen_knack_processor {"type":"short_text","required":true,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6a3cc770ceeb00154427a9","name":"Processor","key":"field_72","object_key":null,"relationship":null,"format":null,"default":null,"immutable":true}
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":"696a8b987297df53c6ed6ded","name":"ID de registro","key":"field_102","object_key":null,"relationship":null,"format":null,"default":null,"immutable":true}
Source varchar2 itgen_knack_source {"type":"short_text","required":true,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6a3cc770ceeb00154427a8","name":"Source","key":"field_71","object_key":null,"relationship":null,"format":null,"default":null,"immutable":true}
Status varchar2 itgen_knack_status {"type":"multiple_choice","required":true,"unique":false,"user":false,"conditional":false,"rules":[],"validation":[],"_id":"5f6a3cc770ceeb00154427a7","name":"Estado","key":"field_70","object_key":null,"relationship":null,"format":{"input":null,"conn_default":null,"default":"Pendiente","sorting":null,"type":"single","options":["Pendiente","Completado","Fallido","Pendiente - Modo de prueba","Completado - Modo de prueba","Fallido - Modo de prueba"],"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":true}

Notas de la Versión

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