Explore the Parsley API data model

See how the various Parsley endpoints relate to each other, using our handy Entity Relationship Diagram

Try our interactive ERD Or, browse below

Pulling data from the Parsley API is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SyncHub, we not only sync your Parsley API endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

Endpoints

Menu

Documentation: https://app.swaggerhub.com/apis/parsleysoftware/parsley/1.3.2#/menus/get_menus

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
LastModified datetime - -
DefaultedLastModified datetime - -

MenuItem

Documentation: https://app.swaggerhub.com/apis/parsleysoftware/parsley/1.3.2#/menu_items/get_menu_items

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Description string - -
IsPackaged boolean - -
ServiceSizeAmount decimal - -
ServiceSizePlusIndeterminate boolean - -
NutritionalInfoIncomplete boolean - -
Ingredients string - -
Photo string - -
ItemNumber string - -
Type string - -
Price decimal - -
LastModified datetime - -
IsRecipeActive boolean - -
DefaultedLastModified datetime - -

Sale

Documentation: https://app.swaggerhub.com/apis/parsleysoftware/parsley/1.3.2#/sales/get_sales

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Time datetime - -

MenuSection

Column Type Relates to Notes
RemoteID string - -
MenuRemoteID string Menu → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
MenuID long Menu → ID -

MenuStation

Column Type Relates to Notes
RemoteID string - -
MenuRemoteID string Menu → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
MenuID long Menu → ID -
Iterator int - -

MenuItemTag

Column Type Relates to Notes
RemoteID string - -
MenuItemRemoteID string MenuItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MenuItemID long MenuItem → ID -
Tag string - -

SaleLine

Column Type Relates to Notes
RemoteID string - -
SaleRemoteID string Sale → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SaleID long Sale → ID -
MenuItem long MenuItem → ID -
Amount decimal - -

MenuSectionItem

Column Type Relates to Notes
RemoteID string - -
MenuSectionRemoteID string MenuSection → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long MenuItem → ID -

MenuStationSection

Column Type Relates to Notes
RemoteID string - -
MenuStationRemoteID string MenuStation → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Iterator int - -

MenuItemCharacteristic

Column Type Relates to Notes
RemoteID string - -
MenuItemRemoteID string MenuItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
MenuItemID long MenuItem → ID -
Value string - -

MenuItemAllergen

Column Type Relates to Notes
RemoteID string - -
MenuItemRemoteID string MenuItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
MenuItemID long MenuItem → ID -
Value string - -

MenuItemNutrient

Column Type Relates to Notes
RemoteID string - -
MenuItemRemoteID string MenuItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
MenuItemID long MenuItem → ID -
NutrientID long - -
Value decimal - -
Unit string - -

MenuStationSectionItem

Column Type Relates to Notes
RemoteID string - -
MenuStationSectionRemoteID string MenuStationSection → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long MenuItem → ID -

Need more?

SyncHub lives and breathes APIs and data. Keep exploring using the links below.

Connect your own Parsley data Querying Parsley using regular SQL