2024 is the year of the connector - vote here

Explore the Parsley API data model

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

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

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.