---
title: "DishRecipeIngredients (Horeko)"
description: "Dish Recipe Ingredients"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/horeko/Horeko.Dish.DishRecipeIngredients
original: https://documentation.invantive.eu/en/datamodels/horeko/Horeko.Dish.DishRecipeIngredients
updated: 2025-06-11T11:15:01Z
license: https://documentation.invantive.eu/en/
---

# DishRecipeIngredients: Horeko Dish Recipe Ingredients

`read only` `REST`

- Catalog: `Horeko`
- Schema: `Dish`
- Label: Dish Recipe Ingredients

Returns dishes
Returns list of dishes. Available sort options: Id,Name,NumberOfPersons,ArticleNumber,CreatedOn,LastModifiedOn

Can only retrieve data.

## API Source

- Endpoint: `/v4/dishes`
- Operation: `get /v4/dishes`

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `ingredientId` | `` | [ ] |  | filter dishes that contain this ingredient |
| `lastAffectedOn` | `` | [ ] |  | filter dishes which recipes are update after this date (format yyyy-mm-dd hh:mm:ss) |
| `lastUpdatedOn` | `` | [ ] |  | filter dishes updated after this date (format yyyy-mm-dd hh:mm:ss) |
| `loadChildrenFolders` | `` | [ ] |  | check if dishes are contained into subfolders of the folders above |
| `pluNumber` | `` | [ ] |  | article number |
| `sortBy` | `` | [ ] |  | comma separated list of available options for sorting |
| `sortDescending` | `` | [ ] |  | true = descending \| false = asceding. default is false |
| `subrecipeId` | `` | [ ] |  | filter dishes that contain this subrecipe |
| `typeId` | `` | [ ] |  | type id |

## Table Columns

The columns of the table `DishRecipeIngredients` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `Amount` | `double` | Amount | [ ] |  |  |
| `CreatedOn` | `datetime` | Created on | [ ] |  |  |
| `Description` | `varchar2` | Description | [ ] |  |  |
| `Folder_Id` | `int32` | Folder ID | [ ] |  |  |
| `Folder_Name` | `varchar2` | Folder Name | [ ] |  |  |
| `HTMLDescription` | `varchar2` | HTML Description | [ ] |  |  |
| `Id` | `int32` | ID | [ ] |  |  |
| `Id_2` | `int32` | itgen_horeko_id_2 | [ ] |  |  |
| `IsValid` | `char` | Is Valid | [ ] |  |  |
| `LaborPreparationTime` | `varchar2` | Labor Preparation Time | [ ] |  |  |
| `LaborWashingTime` | `varchar2` | Labor Washing Time | [ ] |  |  |
| `LastModifiedOn` | `datetime` | Last Modified on | [ ] |  |  |
| `LineNumber` | `int32` | Line Number | [ ] |  |  |
| `Name` | `varchar2` | Name | [ ] |  |  |
| `Name_2` | `varchar2` | itgen_horeko_name_2 | [ ] |  |  |
| `NumberOfPersons` | `int32` | Number of Persons | [ ] |  |  |
| `PluNumber` | `varchar2` | PLU Number | [ ] |  |  |
| `PreparationDescription` | `varchar2` | Preparation Description | [ ] |  |  |
| `RecipeComments` | `varchar2` | Recipe Comments | [ ] |  |  |
| `ServingDescription` | `varchar2` | Serving Description | [ ] |  |  |
| `Type_Id` | `int32` | Type ID | [ ] |  |  |
| `Type_Id_2` | `int32` | itgen_horeko_type_id_2 | [ ] |  |  |
| `Type_Name` | `varchar2` | Type Name | [ ] |  |  |
| `Type_Name_2` | `varchar2` | itgen_horeko_type_name_2 | [ ] |  |  |
| `Unit` | `int32` | Unit | [ ] |  |  |
| `UnitType_Id` | `int32` | Unit Type ID | [ ] |  |  |
| `UnitType_Name` | `varchar2` | Unit Type Name | [ ] |  |  |
| `UsableAmount` | `double` | Usable Amount | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Horeko](/en/release-notes/drivers?driver=horeko)

