SICAR V4 functions

These functions appear when you list functions for a device with adapter = "sicarv4" (UI label Sicar V4). Invoke with:

POST /v1/devices/{device_id}/functions/{function_id}
Authorization: Bearer sk_live_…
Content-Type: application/json

{ "input": { ... } }

Write functions (*.create) run a pre-validation SELECT on the device before any INSERT.

Catalog (76)

Function	Description
`device.health`	Agent / database health check
`sicarv4.schema`	List SICAR tables with column names and data types
`sicarv4.products.list`	List SICAR products (tabla articulo)
`sicarv4.products.search`	Search articulo by text (art_id/clave/claveAlterna/descripcion/caracteristicas), ids, status, servicio, existencia, cat_id
`sicarv4.inventory.list`	List SICAR inventory levels (existencia en articulo)
`sicarv4.categories.list`	List SICAR categories (tabla categoria)
`sicarv4.categories.search`	Search categories by cat_id (comma-separated)
`sicarv4.customers.list`	List SICAR customers (tabla cliente)
`sicarv4.customers.search`	Search customers by cli_id (comma-separated)
`sicarv4.departments.list`	List SICAR departments (tabla departamento)
`sicarv4.departments.search`	Search departments by dep_id (comma-separated)
`sicarv4.invoices.list`	List SICAR invoices (tabla factura)
`sicarv4.invoices.search`	Search invoices by fac_id (comma-separated)
`sicarv4.registers.list`	List SICAR cash registers (tabla caja)
`sicarv4.registers.search`	Search cash registers by caj_id (comma-separated)
`sicarv4.cash_cuts.list`	List SICAR cash-register cuts (tabla cortecaja) — newest cor_id first
`sicarv4.cash_cuts.search`	Search cash-register cuts by cor_id (comma-separated)
`sicarv4.cash_cut_payments.list`	List SICAR cash-cut amounts by payment type (tabla cortetipopago)
`sicarv4.cash_cut_payments.search`	Search cash-cut payment rows by cor_id. No row id: every line of that cut
`sicarv4.cash_cut_summaries.list`	List SICAR cash-cut summaries (tabla resumencortecaja) — newest rcc_id first
`sicarv4.cash_cut_summaries.search`	Search cash-cut summaries by rcc_id (comma-separated)
`sicarv4.cash_cut_payment_summaries.list`	List SICAR cash-cut summary lines by payment type (tabla resumentipopago)
`sicarv4.cash_cut_payment_summaries.search`	Search cash-cut payment summaries by rcc_id. No row id: every line of that summary
`sicarv4.tip_cuts.list`	List SICAR tip cuts (tabla cortepropina) — newest cpr_id first
`sicarv4.tip_cuts.search`	Search tip cuts by cpr_id (comma-separated)
`sicarv4.currencies.list`	List SICAR currencies (tabla moneda)
`sicarv4.currencies.search`	Search currencies by mon_id (comma-separated)
`sicarv4.payment_types.list`	List SICAR payment types (tabla tipopago) — tpa_id for sales
`sicarv4.payment_types.search`	Search payment types by tpa_id (comma-separated)
`sicarv4.users.list`	List SICAR users (tabla usuario) — usu_id for historial / quotes / orders
`sicarv4.users.search`	Search users by usu_id (comma-separated)
`sicarv4.sellers.list`	List SICAR sellers (vendedor) without binary columns. Optional status + columns.
`sicarv4.sellers.search`	Search sellers by vnd_id and/or text (nombre\|clave\|alias). Same column projection as list.
`sicarv4.seller_groups.list`	List SICAR seller groups (tabla grupovendedor) — gvn_id for sellers.create
`sicarv4.seller_groups.search`	Search seller groups by gvn_id (comma-separated)
`sicarv4.shifts.list`	List SICAR shifts (tabla turno) — tur_id for sellers.create
`sicarv4.shifts.search`	Search shifts by tur_id (comma-separated)
`sicarv4.positions.list`	List SICAR job positions (tabla puesto) — pue_id for sellers.create
`sicarv4.positions.search`	Search job positions by pue_id (comma-separated)
`sicarv4.vacations.list`	List SICAR vacation policies (tabla vacaciones) — vac_id for sellers.create
`sicarv4.vacations.search`	Search vacation policies by vac_id (comma-separated)
`sicarv4.shifts.create`	Create SICAR shift (turno + historial). Optional for sellers — tur_id is nullable.
`sicarv4.suppliers.list`	List SICAR suppliers (tabla proveedor) — pro_id for purchase orders
`sicarv4.suppliers.search`	Search suppliers by pro_id (comma-separated)
`sicarv4.units.list`	List SICAR units (tabla unidad)
`sicarv4.units.search`	Search units by uni_id (comma-separated)
`sicarv4.taxes.list`	List SICAR taxes (tabla impuesto) — imp_id for products.create / articuloimpuesto
`sicarv4.taxes.search`	Search taxes by imp_id (comma-separated)
`sicarv4.roles.list`	List SICAR roles (tabla rol) — rol_id for users.create / sellers.create
`sicarv4.roles.search`	Search roles by rol_id (comma-separated)
`sicarv4.tax_regimes.list`	List SICAR tax regimes (tabla regimenfiscal) — rgf_id for customers.create
`sicarv4.tax_regimes.search`	Search tax regimes by rgf_id (comma-separated)
`sicarv4.customer_groups.list`	List SICAR customer groups (tabla grupocliente) — grc_id for customers.create
`sicarv4.customer_groups.search`	Search customer groups by grc_id (comma-separated)
`sicarv4.images.search`	Search images by img_id (comma-separated)
`sicarv4.custom.select`	Custom SELECT on a whitelisted table — choose columns, optional ids filter, limit
`sicarv4.custom.query`	Read-only free-form SQL (SELECT / SHOW / DESCRIBE only). INSERT/UPDATE/DELETE/DROP rejected. Mutations use registry *.create functions.
`sicarv4.custom.validate`	Validate read-only SQL only (same policy as custom.query)
`sicarv4.sales.create`	Create SICAR sale (TICKET\|NOTA\|REMISION): folio + venta + lines + taxes + cash + stock. Registry write only — not custom.query.
`sicarv4.sales.list`	List SICAR sales (tabla venta) — newest first
`sicarv4.sales.search`	Search sales by ven_id (comma-separated)
`sicarv4.quotes.create`	Create SICAR quotation (cotización): NO stock/cash. Registry write only — not custom.query.
`sicarv4.quotes.list`	List SICAR quotes (tabla cotizacion) — newest first
`sicarv4.quotes.search`	Search quotes by cot_id (comma-separated)
`sicarv4.purchase_orders.create`	Create SICAR supplier purchase order (pedido). Registry write only — not custom.query.
`sicarv4.purchase_orders.list`	List SICAR purchase orders (tabla pedido) — newest first
`sicarv4.purchase_orders.search`	Search purchase orders by ped_id (comma-separated)
`sicarv4.inventory.adjust`	Adjust SICAR article stock (ajusteinventario): type adjustment\|entry\|exit + cantidad + comentario. Registry write — not custom.query.
`sicarv4.customers.create`	Create SICAR customer (cliente + historial). Registry write — clave unique.
`sicarv4.units.create`	Create SICAR unit (unidad + historial). Registry write — nombre unique.
`sicarv4.products.create`	Create SICAR product (articulo + articuloimpuesto + historial). Registry write — clave unique.
`sicarv4.suppliers.create`	Create SICAR supplier (proveedor + historial). Registry write.
`sicarv4.sellers.create`	Create SICAR seller (vendedor + historial). Registry write — clave unique. Not a login user.
`sicarv4.users.create`	Create SICAR user (usuario + historial). Copies encrypted password from an existing user — no plaintext. Change password in SICAR UI.
`sicarv4.products.with_images`	Articulo LEFT JOIN articuloimagen — product rows with linked image ids (if any)
`sicarv4.product_images.search`	Search articuloimagen by art_id and/or img_id (comma-separated)