sicarv4.products.search
Search articulo by text (art_id/clave/claveAlterna/descripcion/caracteristicas), ids, status, servicio, existencia, cat_id
| Adapter | sicarv4 |
| Operation | db.query |
| SQL policy | read |
Parameters
| Name | Kind | Required | Notes | ||||
|---|---|---|---|---|---|---|---|
q | string | No | Optional. Whitespace-separated terms AND’d; each matches art_id|clave|claveAlterna|descripcion|caracteristicas (LIKE) | ||||
ids | id_list | No | Optional. Comma-separated art_id exact filter | ||||
status | string | No | 1=activo, 0=inactivo, -1=eliminado, all=sin filtro. options: `all \ | 1 \ | 0 \ | -1` | |
servicio | string | No | 0=producto, 1=servicio, all=sin filtro. options: `all \ | 0 \ | 1` | ||
existencia_op | string | No | Comparador de stock; requiere existencia si no es all. options: `all \ | gt \ | gte \ | lt \ | lte` |
existencia | string | No | Cantidad (requerida si existencia_op ≠ all) | ||||
cat_id | id_list | No | Optional. Comma-separated category ids | ||||
limit | limit | No | Optional. Default 1000000, max 1000000. default 1000000. max 1000000 |
Example
curl -s -X POST "$API/v1/devices/$DEVICE_ID/functions/sicarv4.products.search" \
-H "Authorization: Bearer $ORQUESTR_API_KEY" \
-H "Content-Type: application/json" \
-d '{"input":{"q":"coca 600","ids":"1,2,3","status":"1","servicio":"0","existencia_op":"gte","existencia":"1","limit":"50"}}'

