get_order_items
Retrieve order line items filtered by order ID or product ID, with product names included. Get detailed order items for analysis or reporting.
Instructions
List order line items. Filter by order_id and/or product_id. Each row includes the product name via a LEFT JOIN to products. Sorted by id by default.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Max rows to return. | |
| offset | No | Number of rows to skip. | |
| order_id | No | Only items belonging to this order id. | |
| product_id | No | Only items for this product id. |