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, read the docs 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

MenuItem

Column Type Relates to Notes
RemoteID string - -
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 - -
Price decimal - -
LastModified datetime - -
IsRecipeActive boolean - -

MenuItemNutrient

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

MenuItemCharacteristic

Column Type Relates to Notes
RemoteID string - -
MenuItemRemoteID string MenuItem → RemoteID -
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 -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
MenuItemID long MenuItem → ID -
Value string - -

Sale

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

SaleLine

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

Menu

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

MenuSection

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

MenuItemTag

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

MenuSectionItem

Column Type Relates to Notes
RemoteID string - -
MenuSectionRemoteID string MenuSection → RemoteID -
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 Interactive ERD Querying Parsley using regular SQL