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 |
|---|---|---|---|---|
ingredient |
`` | filter subrecipes that contain this ingredient | ||
last |
`` | filter subrecipes that have been updated after this date (format yyyy-mm-dd hh:mm:ss) | ||
last |
`` | filter subrecipes updated after this date (format yyyy-mm-dd hh:mm:ss) | ||
load |
`` | check for subrecipes contained into subfolders of the folders in FolderIds | ||
sortBy |
`` | comma separated list of available options for sorting | ||
sort |
`` | true = descending | false = asceding. default is false | ||
subrecipe |
`` | 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 | |||
Created |
datetime |
Created on | |||
Customer |
int32 |
Customer Categories | |||
Description |
varchar2 |
Description | |||
Expiration |
double |
Expiration (days) | |||
Folder_ |
int32 |
Folder ID | |||
Folder_ |
varchar2 |
Folder Name | |||
HTML |
varchar2 |
HTML Description | |||
Id |
int32 |
ID | |||
Id_2 |
int32 |
itgen_horeko_id_2 | |||
Is |
char |
Is Valid | |||
Last |
datetime |
Last Modified on | |||
Line |
int32 |
Line Number | |||
Name |
varchar2 |
Name | |||
Name_2 |
varchar2 |
itgen_horeko_name_2 | |||
Preparation |
varchar2 |
Preparation | |||
Preparation |
varchar2 |
Preparation Time | |||
Presentation |
varchar2 |
Presentation | |||
Quantity |
double |
Quantity | |||
Recipe |
varchar2 |
Recipe | |||
Recipe |
varchar2 |
Recipe Comments | |||
Type_ |
int32 |
Type ID | |||
Type_ |
int32 |
itgen_horeko_type_id_2 | |||
Type_ |
varchar2 |
Type Name | |||
Type_ |
varchar2 |
itgen_horeko_type_name_2 | |||
Unit |
int32 |
Unit | |||
Unit |
int32 |
Unit Type ID | |||
Unit |
varchar2 |
Unit Type Name | |||
Washing |
varchar2 |
Washing Time |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: