invantive documentation
Invantive Support ForumsLog In / Sign Up

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: