GET api/Product/GetProducts?LastExecutedDate={LastExecutedDate}&CurrentDate={CurrentDate}&TerminalId={TerminalId}&SharedDB={SharedDB}
Get Product and categories updated in btween a date range
Request Information
URI Parameters
Name | Description | Type | Additional information |
---|---|---|---|
LastExecutedDate | date |
None. |
|
CurrentDate | date |
None. |
|
TerminalId | globally unique identifier |
None. |
|
SharedDB | boolean |
None. |
Body Parameters
None.
Response Information
Resource Description
Model of ProductData that includes List of Products, Categories and Item Campaing , Accouting
ProductDataName | Description | Type | Additional information |
---|---|---|---|
Products | Collection of Product |
None. |
|
Categories | Collection of Category |
None. |
|
ItemCategories | Collection of ItemCategory |
None. |
|
Accountings | Collection of Accounting |
None. |
|
ItemCampaigns | Collection of ItemCampaign |
None. |
|
ItemGroups | Collection of ItemGroup |
None. |
|
ProductPrices | Collection of ProductPrice |
None. |
|
PricePolicies | Collection of Item_PricePolicy |
None. |
|
ItemStocks | Collection of ItemStock |
None. |
|
PolicyGroups | Collection of PolicyGroup |
None. |
|
PriceGroupPolicies | Collection of PriceGroupPolicy |
None. |
|
ItemPolicyGroups | Collection of Item_PolicyGroup |
None. |
|
ItemIngredients | Collection of ItemIngredient |
None. |
|
ItemConfigurations | Collection of ItemConfiguration |
None. |
|
ItemDiscountedPrices | Collection of ItemDiscountedPrice |
None. |
|
ItemInventories | Collection of ItemInventory |
None. |
|
CampaignPriceLists | Collection of CampaignPriceList |
None. |
|
ServeTypes | Collection of ServeType |
None. |
|
ServeFlows | Collection of ServeFlow |
None. |
|
ServeFlowTypes | Collection of ServeFlowType |
None. |
|
ItemPrinters | Collection of ItemPrinter |
None. |
|
PriceLists | Collection of PriceList |
None. |
|
ItemPriceLists | Collection of ItemPriceList |
None. |
|
CampaignMasters | Collection of CampaignMaster |
None. |
|
CampaignPriceDetails | Collection of CampaignPriceDetail |
None. |
|
ProductCampaigns | Collection of ProductCampaign |
None. |
|
CategoryItemGroups | Collection of CategoryItemGroup |
None. |
|
ItemOptionGroups | Collection of ItemOptionGroup |
None. |
|
ItemOptions | Collection of ItemOption |
None. |
|
ItemOptionGroupOptions | Collection of ItemOptionGroupOption |
None. |
|
ItemOutletStatuses | Collection of ItemOutletStatus |
None. |
Response Formats
application/json, text/json
Sample:
{ "Products": [ { "$id": "2", "Id": "5b30bced-3a6f-40d9-9dcc-4d3c87fbced6", "SKU": "sample string 2", "Name": "sample string 3", "Description": "sample string 4", "LongDescription": "sample string 5", "BarCode": "sample string 6", "Price": 7.0, "PurchasePrice": 8.0, "Tax": 9.0, "BrandId": 10, "PLU": "sample string 11", "Unit": 0, "AskPrice": true, "AskWeight": true, "PriceLock": true, "ColorCode": "sample string 15", "PrinterId": 16, "PlaceHolder": true, "AskVolume": true, "NeedIngredient": true, "Bong": true, "Sticky": 21, "Seamless": true, "ShowItemButton": true, "ShowGroupItem": true, "AccountingId": 25, "ReceiptMethod": 0, "ItemType": 0, "DiscountAllowed": true, "PreparationTime": 0, "IngredientPopup": true, "DefaultCartQty": 28.0, "SortOrder": 29, "IconId": 30, "Active": true, "Deleted": true, "Weight": 33.0, "Availability": true, "TextColor": "sample string 35", "ServeType": 64, "BongTitle": "sample string 37", "Synced": true, "DemandIdControl": true, "Discontinued": true, "AskPLU": true, "SupplierId": "d3a576a8-aea4-4818-b0b2-5bc261375533", "SupplierSKU": "sample string 44", "DefaultUnit": 0, "ManageStock": 45, "PriceRek": 46.0, "CommentsRequired": true, "TicketQty": 48, "MinCartQty": 49.0, "MinQtyAlert": 50.0, "GroupId": "d489fa46-1045-4bc7-ae22-9ffbfda4f0d5", "ComissionPercent": 51.0, "PantPrice": 52.0, "TrackAmount": true, "SaleUnitSuffix": "sample string 54", "QtyPerSaleUnit": 55.0, "Created": "2024-05-16T19:34:37.2370444+02:00", "Updated": "2024-05-16T19:34:37.2370444+02:00", "UpdatedBy": "06961fe7-82bf-43c0-9a1f-e07843d76e2f", "CategoryId": 58, "Campaign": { "$id": "3", "Id": "2b69a8d5-e15b-4a03-905c-4ef4512eedba", "CampaignType": 0, "DiscountBy": 0, "BuyLimit": 2, "FreeOffer": 3, "Price": 4.0, "DiscountQtyIncrement": 5, "Description": "sample string 6", "StartDate": "2024-05-16T19:34:37.2370444+02:00", "EndDate": "2024-05-16T19:34:37.2370444+02:00", "Deleted": true, "Updated": "2024-05-16T19:34:37.2370444+02:00", "CampaignPriceDetails": [ { "$id": "4", "Id": "a62de18b-5460-4faf-bb32-e83b86af62c2", "CampaignId": "9564ee38-9148-46d5-8c7e-11b5fd87f995", "Quantity": 3, "PayPrice": 4.0, "Deleted": true, "Updated": "2024-05-16T19:34:37.2370444+02:00" }, { "$ref": "4" } ] }, "HasPricePolicy": true, "ItemCategory": [ { "$id": "5", "Id": 1, "ItemId": "a0909f4d-a12f-4c38-8d1e-6ebca03627ed", "CategoryId": 3, "SortOrder": 4, "IsPrimary": true }, { "$ref": "5" } ], "ItemIdex": 60, "PolicyGroupId": 61, "HasCampaign": true, "Products": [ { "$ref": "2" }, { "$ref": "2" } ], "ColorName": "sample string 62", "Type": 63, "ImagePath": "sample string 64", "ImageVisibility": true, "ifExists": "sample string 66", "ProductPrices": [ { "$id": "6", "Id": 1, "ItemId": "b5f0042a-94c8-4492-addd-05d5face7e45", "PurchasePrice": 3.0, "Price": 4.0, "OutletId": "d27db0ed-c4c9-453d-a2fd-b1828b8b32dc", "PriceMode": 0, "Updated": "2024-05-16T19:34:37.2370444+02:00" }, { "$ref": "6" } ], "Ingredients": [ { "$ref": "2" }, { "$ref": "2" } ], "Variants": [ { "$id": "7", "Id": 1, "ConfigurationId": "3e4eb67e-f1b3-4f2a-84a6-1e7237ecac6d", "ItemId": "798c713b-3de8-4a26-ab30-41f523c325e0", "SortOrder": 4, "Deleted": true, "Updated": "2024-05-16T19:34:37.2370444+02:00" }, { "$ref": "7" } ], "ItemOption": [ { "$id": "8", "Id": "db4f7a51-6f6e-40bf-a4ba-8bbe6c27ac68", "ItemOptionGroupId": "6ee422ed-94b5-42b0-9bce-7159f2b9c598", "ItemId": "2562530e-b7dc-4eb7-847a-d78f68561efd", "CategoryId": 4, "Active": true, "Updated": "2024-05-16T19:34:37.2370444+02:00" }, { "$ref": "8" } ], "ShowOnReceipt": true, "QuickAdd": true, "HasIngredients": true, "CategoryItemGroups": [ { "$id": "9", "Id": "c77845ad-41c2-454f-a371-4dfa77c9ff3e", "CategoryId": 2, "GroupId": "81d371b8-ba1f-4bdd-bb10-3af3017ccf09", "Qty": 4.0, "Price": 5.0, "Deleted": true, "SortOrder": 7, "Updated": "2024-05-16T19:34:37.2370444+02:00", "Description": "sample string 9" }, { "$ref": "9" } ], "ItemPricePolicies": [ { "$id": "10", "Id": 1, "ItemId": "526369c5-db5b-4277-8399-5698492b63b2", "BuyLimit": 3, "DiscountAmount": 4.0, "Active": true, "Deleted": true, "Updated": "2024-05-16T19:34:37.2370444+02:00", "PolicyId": 8 }, { "$ref": "10" } ], "PriceGroupPolicies": [ { "$id": "11", "Id": 1, "GroupId": 2, "BuyLimit": 3, "MaxLimit": 4, "DiscountAmount": 5.0, "TotalAmount": 6.0, "Updated": "2024-05-16T19:34:37.2370444+02:00" }, { "$ref": "11" } ], "Photo": "QEA=", "GroupPrice": 69.0, "ExternalId": "sample string 70", "IngredientQty": 71.0, "StockQty": 72.0, "StockInitialCount": 73.0, "Selected": true, "ShowWarhouseStock": true, "ShowStockQty": true, "HideStockQty": false, "IsRUT": true, "NotSelected": true, "IsInActive": true, "CreatedBy": "sample string 79", "TerminalId": "f1de9838-1346-4071-81c6-c327be05849b", "CategoryName": "sample string 80", "ShowCategoryName": true, "DiscountedPrice": 81.0, "Qty": 82.0, "ConfigurationId": 83, "ItemOptionId": "963f27e0-9e7c-4ee2-9c90-0157703e05f1", "PriceAdd": 85.0, "PriceRemove": 86.0, "FreeQty": 87.0, "PLUNumeric": 0, "ScalePrice": 88.0, "PriceExlTax": 7.63 }, { "$ref": "2" } ], "Categories": [ { "$id": "12", "Id": 1, "Name": "sample string 2", "Parant": 3, "CategoryLevel": 4, "Type": 0, "Active": true, "Deleted": true, "Created": "2024-05-16T19:34:37.2370444+02:00", "Updated": "2024-05-16T19:34:37.2370444+02:00", "ColorCode": "sample string 8", "TextColorCode": "sample string 9", "ItemColorCode": "sample string 10", "ApplyItemColor": true, "SortOrder": 12, "IconId": 13, "ReportOrder": 14, "AccountingId": 15, "SortItemByName": true, "ComissionPercent": 17.0, "ShowButton": true, "SubCategories": [ { "$ref": "12" }, { "$ref": "12" } ], "Children": [ { "$ref": "12" }, { "$ref": "12" } ], "Photo": "QEA=", "ImageURL": "sample string 19", "IsPrimary": true, "IsParent": true, "IsSelected": true }, { "$ref": "12" } ], "ItemCategories": [ { "$ref": "5" }, { "$ref": "5" } ], "Accountings": [ { "$id": "13", "Id": 1, "AcNo": 2, "Name": "sample string 3", "IsDeleted": true, "TAX": 5.0, "AccountType": 0, "Updated": "2024-05-16T19:34:37.2380513+02:00", "SortOrder": 7 }, { "$ref": "13" } ], "ItemCampaigns": [ { "$id": "14", "Id": 1, "ItemId": "d5fcfd80-1db7-4cca-8402-13fe4e65b621", "CampaignId": 3, "StartDate": "2024-05-16T19:34:37.239048+02:00", "EndDate": "2024-05-16T19:34:37.239048+02:00", "Active": true, "Updated": "2024-05-16T19:34:37.239048+02:00" }, { "$ref": "14" } ], "ItemGroups": [ { "$id": "15", "Id": 1, "ItemId": "e93eb44b-d471-4cd9-ba6e-39408af270be", "GroupId": "4a8daba3-a7ae-4d4d-8cd1-cc376f83d44f", "Qty": 4.0, "Price": 5.0, "Deleted": true, "Updated": "2024-05-16T19:34:37.2400481+02:00", "Description": "sample string 8", "Bong": true, "PrinterId": 10, "ItemType": 0, "ServeType": 64, "Tax": 12.0, "DiscountAllowed": true }, { "$ref": "15" } ], "ProductPrices": [ { "$ref": "6" }, { "$ref": "6" } ], "PricePolicies": [ { "$ref": "10" }, { "$ref": "10" } ], "ItemStocks": [ { "$id": "16", "Id": 1, "ItemId": "45ec7ebd-4b06-4169-8d7a-d2ea32c3617a", "Quantity": 3.0, "Updated": "2024-05-16T19:34:37.2420492+02:00" }, { "$ref": "16" } ], "PolicyGroups": [ { "$id": "17", "Id": 1, "Title": "sample string 2", "Updated": "2024-05-16T19:34:37.2420492+02:00", "GroupPolicies": [ { "$ref": "11" }, { "$ref": "11" } ] }, { "$ref": "17" } ], "PriceGroupPolicies": [ { "$ref": "11" }, { "$ref": "11" } ], "ItemPolicyGroups": [ { "$id": "18", "Id": 1, "ItemId": "905c1839-e504-4be4-bea0-8f6ccb0ba256", "GroupId": 3, "Active": true, "Deleted": true, "Updated": "2024-05-16T19:34:37.2430485+02:00" }, { "$ref": "18" } ], "ItemIngredients": [ { "$id": "19", "Id": 1, "ItemId": "b7820cac-99d6-43d9-a48a-a6caec9bc5d5", "IngredientId": "8f9356e2-cd2a-4d1f-97c2-7ac93ee5d78e", "ShowOnReceipt": true, "QuickAdd": true, "Qty": 6.0, "Unit": 0, "Price": 7.0, "SortOrder": 8, "Deleted": true, "Updated": "2024-05-16T19:34:37.2450465+02:00" }, { "$ref": "19" } ], "ItemConfigurations": [ { "$ref": "7" }, { "$ref": "7" } ], "ItemDiscountedPrices": [ { "$id": "20", "Id": 1, "ItemId": "5e368999-7943-48d7-9ade-755b2e5af539", "Price": 3.0, "StartDate": "2024-05-16T19:34:37.2460484+02:00", "EndDate": "2024-05-16T19:34:37.2460484+02:00", "Deleted": true, "Updated": "2024-05-16T19:34:37.2460484+02:00" }, { "$ref": "20" } ], "ItemInventories": [ { "$id": "21", "ItemInventoryID": "1ad11dac-083c-4323-9f4d-631f831b1d7c", "ItemId": "d5f1f506-eddb-41fd-8ebf-48b8f2679bbb", "WarehouseID": "01936ab4-0d0f-42ac-8bdc-085ab17b3f04", "WarehouseLocationID": "6539f13e-74ed-4b77-bbb5-87d877c6038d", "StockCount": 5.0, "StockReservations": 6.0, "Synced": true, "Updated": "2024-05-16T19:34:37.2460484+02:00", "Direction": 9 }, { "$ref": "21" } ], "CampaignPriceLists": [ { "$id": "22", "Id": 1, "CampaignId": 2, "Quantity": 3, "PayPrice": 4.0, "Deleted": true, "Updated": "2024-05-16T19:34:37.248049+02:00" }, { "$ref": "22" } ], "ServeTypes": [ { "$id": "23", "Id": 64, "Name": "sample string 2", "SortOrder": 3, "ColorCode": "sample string 4", "Updated": "2024-05-16T19:34:37.248049+02:00" }, { "$ref": "23" } ], "ServeFlows": [ { "$id": "24", "Id": 64, "Name": "sample string 2", "StartAutomatically": true, "Updated": "2024-05-16T19:34:37.2490478+02:00" }, { "$ref": "24" } ], "ServeFlowTypes": [ { "$id": "25", "Id": 1, "FlowId": 64, "ServeTypeId": 64, "SortOrder": 4, "Deleted": true, "Updated": "2024-05-16T19:34:37.2490478+02:00" }, { "$ref": "25" } ], "ItemPrinters": [ { "$id": "26", "Id": "35c8e1e5-07b3-4323-ba02-95b6586873ba", "ItemId": "216e17f6-d751-4bff-8f40-ca66940c7d76", "OutletId": "bc7f3f7a-8d99-4b37-a599-7648e1b3b76a", "TerminalId": "d2d9d30d-b8cf-434e-a49f-22662fa78b76", "PrinterId": 5, "Updated": "2024-05-16T19:34:37.2510489+02:00" }, { "$ref": "26" } ], "PriceLists": [ { "$id": "27", "Id": "1c79fa21-f6e2-469f-a3c8-ab8f8f7cc768", "Code": "sample string 2", "Name": "sample string 3", "Comment": "sample string 4", "IsDefault": true, "Deleted": true, "Updated": "2024-05-16T19:34:37.2520494+02:00" }, { "$ref": "27" } ], "ItemPriceLists": [ { "$id": "28", "Id": "ccda46ad-da50-475d-9747-795ac4b659fa", "PriceListId": "f3615ef2-cdde-40ff-bf01-66dc5d69214d", "ItemId": "ff2983cb-fb68-42bb-9d09-12fb16d6b909", "Price": 4.0, "Quantity": 5.0, "ValidFrom": "2024-05-16T19:34:37.2520494+02:00", "ValidTo": "2024-05-16T19:34:37.2520494+02:00", "Deleted": true, "Updated": "2024-05-16T19:34:37.2530466+02:00", "Code": "sample string 10", "Name": "sample string 11" }, { "$ref": "28" } ], "CampaignMasters": [ { "$ref": "3" }, { "$ref": "3" } ], "CampaignPriceDetails": [ { "$ref": "4" }, { "$ref": "4" } ], "ProductCampaigns": [ { "$id": "29", "Id": "3cdad3da-df3c-4e9a-ba75-2f741f28234e", "ItemId": "dc8b998f-5f21-46af-b23f-a383303d84d2", "CampaignId": "ad8bab5d-3f2b-475d-bcb8-ab5092fd7a1d", "StartDate": "2024-05-16T19:34:37.2540492+02:00", "EndDate": "2024-05-16T19:34:37.2540492+02:00", "Active": true, "Updated": "2024-05-16T19:34:37.2540492+02:00" }, { "$ref": "29" } ], "CategoryItemGroups": [ { "$ref": "9" }, { "$ref": "9" } ], "ItemOptionGroups": [ { "$id": "30", "Id": "15ec023a-86b2-45b6-9911-863d827b0f49", "Name": "sample string 2", "Description": "sample string 3", "FreeQty": 4.0, "PriceAdd": 5.0, "PriceRemove": 6.0, "Placement": 0, "Deleted": true, "Updated": "2024-05-16T19:34:37.2550489+02:00" }, { "$ref": "30" } ], "ItemOptions": [ { "$ref": "8" }, { "$ref": "8" } ], "ItemOptionGroupOptions": [ { "$id": "31", "Id": "a4cf2f26-e7ae-4d35-a149-703e8525f5a4", "ItemOptionGroupId": "24ef277e-346a-4fbf-81df-5f6cdfd77dc7", "ItemId": "02e9e49b-c2ba-43b6-90bb-68b9abf2787f", "UsePriceFromGroup": true, "PriceAdd": 5.0, "PriceRemove": 6.0, "Active": true, "Updated": "2024-05-16T19:34:37.2560494+02:00" }, { "$ref": "31" } ], "ItemOutletStatuses": [ { "$id": "32", "Id": "241cc13a-0220-4816-a0b7-87fedcc4c1fa", "ItemId": "a2323422-5ab5-4553-a96f-8bb79d6aef5f", "OutletId": "ac2e77f6-c173-438e-a68f-21507044a58f", "Active": true, "Updated": "2024-05-16T19:34:37.2570491+02:00" }, { "$ref": "32" } ] }