> ## Documentation Index
> Fetch the complete documentation index at: https://docs.orquestr.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# sicarv4.custom.select

> Custom SELECT on a whitelisted table — choose columns, optional ids filter, limit

# `sicarv4.custom.select`

Custom SELECT on a whitelisted table — choose columns, optional ids filter, limit

|                |            |
| -------------- | ---------- |
| **Adapter**    | `sicarv4`  |
| **Operation**  | `db.query` |
| **SQL policy** | `read`     |

## Parameters

| Name      | Kind          | Required | Notes                                                             |              |            |                 |            |         |           |           |                   |             |            |             |                  |              |           |             |        |                  |                 |          |           |               |          |               |           |              |                  |                 |                     |                   |
| --------- | ------------- | -------- | ----------------------------------------------------------------- | ------------ | ---------- | --------------- | ---------- | ------- | --------- | --------- | ----------------- | ----------- | ---------- | ----------- | ---------------- | ------------ | --------- | ----------- | ------ | ---------------- | --------------- | -------- | --------- | ------------- | -------- | ------------- | --------- | ------------ | ---------------- | --------------- | ------------------- | ----------------- |
| `table`   | `table`       | Yes      | Whitelisted SICAR table. options: \`articulo \\                   | categoria \\ | cliente \\ | departamento \\ | factura \\ | caja \\ | moneda \\ | imagen \\ | articuloimagen \\ | tipopago \\ | usuario \\ | vendedor \\ | grupovendedor \\ | proveedor \\ | unidad \\ | impuesto \\ | rol \\ | regimenfiscal \\ | grupocliente \\ | turno \\ | puesto \\ | vacaciones \\ | venta \\ | cotizacion \\ | pedido \\ | cortecaja \\ | cortetipopago \\ | cortepropina \\ | resumencortecaja \\ | resumentipopago\` |
| `columns` | `column_list` | No       | Optional. "\*" or comma-separated, e.g. art\_id,clave,descripcion |              |            |                 |            |         |           |           |                   |             |            |             |                  |              |           |             |        |                  |                 |          |           |               |          |               |           |              |                  |                 |                     |                   |
| `ids`     | `id_list`     | No       | Comma-separated, e.g. 1,2,3                                       |              |            |                 |            |         |           |           |                   |             |            |             |                  |              |           |             |        |                  |                 |          |           |               |          |               |           |              |                  |                 |                     |                   |
| `limit`   | `limit`       | No       | Optional. Default 1000, max 1000000. default 1000. max 1000000    |              |            |                 |            |         |           |           |                   |             |            |             |                  |              |           |             |        |                  |                 |          |           |               |          |               |           |              |                  |                 |                     |                   |

## Example

```bash theme={"system"}
curl -s -X POST "$API/v1/devices/$DEVICE_ID/functions/sicarv4.custom.select" \
  -H "Authorization: Bearer $ORQUESTR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"input":{"table":"articulo","columns":"*","ids":"1,2,3","limit":"50"}}'
```