Explore the Parsley Data Model

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

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	-	-
Price	decimal	-	-
LastModified	datetime	-	-
IsRecipeActive	boolean	-	-

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	-

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	-

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	-	-

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

Explore the Parsley API data model

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