> ## 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.products.with_images

> Articulo LEFT JOIN articuloimagen — product rows with linked image ids (if any)

# `sicarv4.products.with_images`

Articulo LEFT JOIN articuloimagen — product rows with linked image ids (if any)

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

## Parameters

| Name      | Kind          | Required | Notes                                                             |
| --------- | ------------- | -------- | ----------------------------------------------------------------- |
| `columns` | `column_list` | No       | Optional articulo columns. "\*" or e.g. art\_id,clave,descripcion |
| `ids`     | `id_list`     | No       | Optional. Comma-separated product ids                             |
| `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.products.with_images" \
  -H "Authorization: Bearer $ORQUESTR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"input":{"columns":"*","ids":"1,2,3","limit":"50"}}'
```