list_products
Search and retrieve products from inFlow Inventory using optional filters such as SKU, name, barcode, category, active status, or serial tracking. Include related data or counts to narrow results.
Instructions
Search and list products from inFlow Inventory with optional filtering
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sku | No | Filter by SKU | |
| name | No | Filter by product name (partial match) | |
| skip | No | Number of records to skip | |
| sort | No | Property to sort by (e.g., name, sku, modifiedDate) | |
| count | No | Number of records to return (max 100) | |
| smart | No | Smart search across multiple fields (name, description, SKU, barcode) | |
| barcode | No | Filter by barcode | |
| include | No | Related data to include. Options: category, customFields, inventoryLines (serial numbers). Use filter trackSerials=true to get only serialized products. | |
| isActive | No | Filter by active status | |
| sortDesc | No | Sort in descending order | |
| categoryId | No | Filter by category ID | |
| description | No | Filter by description | |
| categoryName | No | Filter by category name (case-insensitive, resolves to categoryId) | |
| includeCount | No | Include total record count in response | |
| trackSerials | No | Filter to only return products that track serial numbers (serial numbers) |