invantive documentation
Invantive Support ForumsLog In / Sign Up

SubrecipeIngredients: Horeko Subrecipe Ingredients

read only REST

  • Catalog: Horeko
  • Schema: Subrecipe
  • Label: Subrecipe Ingredients

Returns subrecipes Returns list of subrecipes. Available sort options: Id,Name,CreatedOn,LastModifiedOn

Can only retrieve data.

API Source

  • Endpoint: /v4/subrecipes
  • Operation: get /v4/subrecipes

Parameters

Name Data Type Required Default Documentation
ingredientId `` filter subrecipes that contain this ingredient
lastAffectedOn `` filter subrecipes that have been updated after this date (format yyyy-mm-dd hh:mm:ss)
lastUpdatedOn `` filter subrecipes updated after this date (format yyyy-mm-dd hh:mm:ss)
loadChildrenFolders `` check for subrecipes contained into subfolders of the folders in FolderIds
sortBy `` comma separated list of available options for sorting
sortDescending `` true = descending | false = asceding. default is false
subrecipeId `` filter subrecipes that contain this subrecipe
typeId `` subrecipe type id

Table Columns

The columns of the table SubrecipeIngredients 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
CustomerCategories int32 Customer Categories
Description varchar2 Description
ExpirationDays double Expiration (days)
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
LastModifiedOn datetime Last Modified on
LineNumber int32 Line Number
Name varchar2 Name
Name_2 varchar2 itgen_horeko_name_2
Preparation varchar2 Preparation
PreparationTime varchar2 Preparation Time
Presentation varchar2 Presentation
Quantity double Quantity
Recipe varchar2 Recipe
RecipeComments varchar2 Recipe Comments
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
WashingTime varchar2 Washing Time

Release Notes

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