GET api/Product/GetProducts?LastExecutedDate={LastExecutedDate}&CurrentDate={CurrentDate}&TerminalId={TerminalId}&SharedDB={SharedDB}&TableName={TableName}

{
  "Products": [
    {
      "$id": "2",
      "Id": "1831c08a-5821-4f02-aa2f-86af5d8f04e8",
      "Name": "sample string 2",
      "SKU": "sample string 3",
      "BarCode": "sample string 4",
      "PLU": "sample string 5",
      "GroupId": "5b0d1113-98d6-4ea3-bb2c-299dbd28ce21",
      "SupplierId": "e5b7df8d-c843-4c7b-8eda-c5fd4034590e",
      "SupplierSKU": "sample string 7",
      "BrandId": 8,
      "Description": "sample string 9",
      "LongDescription": "sample string 10",
      "BongTitle": "sample string 11",
      "TextColor": "sample string 12",
      "ColorCode": "sample string 13",
      "IconId": 14,
      "ShowItemButton": true,
      "ShowGroupItem": true,
      "Price": 17.0,
      "PurchasePrice": 18.0,
      "Tax": 19.0,
      "Unit": 0,
      "AskPrice": true,
      "AskWeight": true,
      "PriceLock": true,
      "PrinterId": 23,
      "PlaceHolder": true,
      "AskVolume": true,
      "NeedIngredient": true,
      "Bong": true,
      "Sticky": 28,
      "Seamless": true,
      "AccountingId": 30,
      "ReceiptMethod": 0,
      "ItemType": 0,
      "DiscountAllowed": true,
      "PreparationTime": 0,
      "IngredientPopup": true,
      "DefaultCartQty": 33.0,
      "SortOrder": 34,
      "Active": true,
      "Deleted": true,
      "Weight": 37.0,
      "Availability": true,
      "ServeType": 64,
      "Synced": true,
      "DemandIdControl": true,
      "Discontinued": true,
      "AskPLU": true,
      "NoticeStockLevel": 44.0,
      "DefaultUnit": 0,
      "ManageStock": 45,
      "PriceRek": 46.0,
      "CommentsRequired": true,
      "TicketQty": 48,
      "MinCartQty": 49.0,
      "MinQtyAlert": 50.0,
      "ComissionPercent": 51.0,
      "PantPrice": 52.0,
      "TrackAmount": true,
      "SaleUnitSuffix": "sample string 54",
      "QtyPerSaleUnit": 55.0,
      "AutoClose": true,
      "ButtonTitle": "sample string 57",
      "Created": "2025-04-04T05:34:32.299973+02:00",
      "Updated": "2025-04-04T05:34:32.299973+02:00",
      "UpdatedBy": "f548036f-382f-4f00-b9b6-ecb7c2b4e223",
      "CategoryId": 60,
      "Campaign": {
        "$id": "3",
        "Id": "28645130-fee2-476f-9c20-860fdfe25227",
        "CampaignType": 0,
        "DiscountBy": 0,
        "BuyLimit": 2,
        "FreeOffer": 3,
        "Price": 4.0,
        "DiscountQtyIncrement": 5,
        "Description": "sample string 6",
        "StartDate": "2025-04-04T05:34:32.299973+02:00",
        "EndDate": "2025-04-04T05:34:32.299973+02:00",
        "Deleted": true,
        "Updated": "2025-04-04T05:34:32.299973+02:00",
        "CampaignPriceDetails": [
          {
            "$id": "4",
            "Id": "3f16145c-1e23-4931-9c96-e513d68aaacc",
            "CampaignId": "99b23976-c028-4e41-9dff-894ae3dc3bc6",
            "Quantity": 3,
            "PayPrice": 4.0,
            "Deleted": true,
            "Updated": "2025-04-04T05:34:32.299973+02:00"
          },
          {
            "$ref": "4"
          }
        ]
      },
      "ItemsTags": [
        {
          "$id": "5",
          "Id": "66125d98-f54f-4c5a-9d52-8c3e263c41f1",
          "TagId": "76e032f6-7fb4-40bd-bdf0-40c078649d23",
          "ItemId": "2482205f-fd9d-4ba5-bcd1-ed972ed85aa4",
          "Deleted": true,
          "Synced": true,
          "Updated": "2025-04-04T05:34:32.299973+02:00",
          "TagName": "sample string 7"
        },
        {
          "$ref": "5"
        }
      ],
      "ItemCampaign": {
        "$id": "6",
        "UUID": "a3805a94-9dab-41e7-96c1-c197bd519980",
        "CampaignTypeId": "OPEN",
        "Title": "sample string 2",
        "DiscountBy": 1,
        "FreeOffer": 1,
        "BuyLimit": 1,
        "StartDate": "2025-04-04T05:34:32.299973+02:00",
        "EndDate": "2025-04-04T05:34:32.299973+02:00",
        "PriceEach": 1.0,
        "PriceTotal": 1.0,
        "Grouped": true,
        "CurrencyCode": "sample string 6",
        "IncludesVat": true,
        "CreatedAt": "2025-04-04T05:34:32.299973+02:00",
        "CreatedByUUID": "sample string 9",
        "UpdatedAt": "2025-04-04T05:34:32.299973+02:00",
        "UpdatedByUUID": "sample string 10",
        "DeletedAt": "2025-04-04T05:34:32.299973+02:00",
        "DeletedByUUID": "sample string 11",
        "Synced": true,
        "ItemPrices": [
          {
            "$id": "7",
            "UUID": "cde07b8c-6d4f-4502-beb9-bb27532de39a",
            "PriceListUUID": "b2ee6c69-f11c-4677-be66-de48caa5ba83",
            "ItemGroupUUID": "cb43c4bd-4ed0-46ba-88ca-418a0a194086",
            "AgreementUUID": "787b8863-2c71-4bd3-939b-7c2689e9cd66",
            "CustomerGroupUUID": "125622b1-b2f1-43e9-b2a1-f32cb7906225",
            "CustomerUUID": "234cd867-4b4d-41c2-bfb8-b15fee91b9aa",
            "ProjectUUID": "491f2fcb-fd90-4fbd-9007-ddf0c990ac79",
            "CampaignUUID": "b44bf082-e3b8-4603-914f-80186e6ae071",
            "ItemUUID": "8bddd3b5-f1a4-42e6-a110-745ad815ad35",
            "WildCardSKU": "sample string 4",
            "MinQty": 1.0,
            "MaxQty": 1.0,
            "Price": 1.0,
            "Percentage": 1.0,
            "Type": "sample string 5",
            "RegularPrice": true,
            "ValidFrom": "2025-04-04T05:34:32.299973+02:00",
            "ValidTo": "2025-04-04T05:34:32.299973+02:00",
            "CreatedAt": "2025-04-04T05:34:32.299973+02:00",
            "CreatedByUUID": "sample string 8",
            "UpdatedAt": "2025-04-04T05:34:32.299973+02:00",
            "UpdatedByUUID": "sample string 9",
            "DeletedAt": "2025-04-04T05:34:32.299973+02:00",
            "DeletedByUUID": "sample string 10",
            "Synced": true,
            "ItemName": "sample string 12",
            "CampaignTitle": "sample string 13"
          },
          {
            "$ref": "7"
          }
        ]
      },
      "HasPricePolicy": true,
      "ItemCategory": [
        {
          "$id": "8",
          "Id": 1,
          "ItemId": "0a8560fd-8bcf-40ab-b0c1-745080762042",
          "CategoryId": 3,
          "SortOrder": 4,
          "IsPrimary": true
        },
        {
          "$ref": "8"
        }
      ],
      "ItemIdex": 62,
      "PolicyGroupId": 63,
      "HasCampaign": true,
      "Products": [
        {
          "$ref": "2"
        },
        {
          "$ref": "2"
        }
      ],
      "ColorName": "sample string 64",
      "Type": 65,
      "ImagePath": "sample string 66",
      "ImageVisibility": true,
      "ifExists": "sample string 68",
      "ProductPrices": [
        {
          "$id": "9",
          "Id": 1,
          "ItemId": "6c1ce05e-2e50-470d-ae6f-8d0e28cc18dc",
          "PurchasePrice": 3.0,
          "Price": 4.0,
          "OutletId": "9f3231db-d3d0-4fe8-9bdf-8f4f3adb39bd",
          "PriceMode": 0,
          "Updated": "2025-04-04T05:34:32.299973+02:00"
        },
        {
          "$ref": "9"
        }
      ],
      "Ingredients": [
        {
          "$ref": "2"
        },
        {
          "$ref": "2"
        }
      ],
      "Variants": [
        {
          "$id": "10",
          "Id": 1,
          "ConfigurationId": "22ea2205-f423-448d-bde1-43574343da03",
          "ItemId": "6f7cafcb-4fb8-4b4a-9d9e-967f91488e22",
          "SortOrder": 4,
          "Deleted": true,
          "Updated": "2025-04-04T05:34:32.299973+02:00"
        },
        {
          "$ref": "10"
        }
      ],
      "ItemOption": [
        {
          "$id": "11",
          "Id": "d714a3d4-92aa-4bc9-b1e7-afbd00e2084a",
          "ItemOptionGroupId": "b3bdf82d-419c-4cba-8673-428bd18fa5e3",
          "ItemId": "e9d0412c-806f-478d-a883-1f8bc72b528d",
          "CategoryId": 4,
          "Active": true,
          "Updated": "2025-04-04T05:34:32.299973+02:00"
        },
        {
          "$ref": "11"
        }
      ],
      "ShowOnReceipt": true,
      "QuickAdd": true,
      "HasIngredients": true,
      "CategoryItemGroups": [
        {
          "$id": "12",
          "Id": "65bb5c95-e88e-44d4-8eed-2ceeedcd212c",
          "CategoryId": 2,
          "GroupId": "989275ce-0b23-44c0-88eb-3d8203bb006f",
          "Qty": 4.0,
          "Price": 5.0,
          "Deleted": true,
          "SortOrder": 7,
          "Updated": "2025-04-04T05:34:32.299973+02:00",
          "Description": "sample string 9"
        },
        {
          "$ref": "12"
        }
      ],
      "ItemPricePolicies": [
        {
          "$id": "13",
          "Id": 1,
          "ItemId": "8f8a74a9-46e0-4dc4-83ad-33ac3eea944c",
          "BuyLimit": 3,
          "DiscountAmount": 4.0,
          "Active": true,
          "Deleted": true,
          "Updated": "2025-04-04T05:34:32.299973+02:00",
          "PolicyId": 8
        },
        {
          "$ref": "13"
        }
      ],
      "PriceGroupPolicies": [
        {
          "$id": "14",
          "Id": 1,
          "GroupId": 2,
          "BuyLimit": 3,
          "MaxLimit": 4,
          "DiscountAmount": 5.0,
          "TotalAmount": 6.0,
          "Updated": "2025-04-04T05:34:32.299973+02:00"
        },
        {
          "$ref": "14"
        }
      ],
      "Photo": "QEA=",
      "GroupPrice": 71.0,
      "ExternalId": "sample string 72",
      "IngredientQty": 73.0,
      "StockQty": 74.0,
      "LocalStockNull": true,
      "StockInitialCount": 76.0,
      "Selected": true,
      "ShowWarhouseStock": true,
      "ShowStockQty": true,
      "HideStockQty": false,
      "IsRUT": true,
      "NotSelected": true,
      "IsInActive": true,
      "CreatedBy": "sample string 82",
      "TerminalId": "4a5d88d6-c298-43de-9e74-fe02b0716772",
      "CategoryName": "sample string 83",
      "ShowCategoryName": true,
      "DiscountedPrice": 84.0,
      "Qty": 85.0,
      "ConfigurationId": 86,
      "ItemOptionId": "f3ca476f-afd0-4371-aed6-3cd988a52a8f",
      "PriceAdd": 88.0,
      "PriceRemove": 89.0,
      "FreeQty": 90.0,
      "MinQty": 91.0,
      "MaxQty": 92.0,
      "PLUNumeric": 0,
      "ScalePrice": 93.0,
      "IsManageStock": false,
      "PriceExlTax": 20.23,
      "IndexId": 94,
      "IsSelected": true
    },
    {
      "$ref": "2"
    }
  ],
  "Categories": [
    {
      "$id": "15",
      "Id": 1,
      "Name": "sample string 2",
      "Parant": 3,
      "CategoryLevel": 4,
      "Type": 0,
      "Active": true,
      "Deleted": true,
      "Created": "2025-04-04T05:34:32.299973+02:00",
      "Updated": "2025-04-04T05:34:32.299973+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,
      "IngredientCategoryId": 19,
      "SubCategories": [
        {
          "$ref": "15"
        },
        {
          "$ref": "15"
        }
      ],
      "Children": [
        {
          "$ref": "15"
        },
        {
          "$ref": "15"
        }
      ],
      "Photo": "QEA=",
      "ImageURL": "sample string 20",
      "IsPrimary": true,
      "IsParent": true,
      "IsSelected": true
    },
    {
      "$ref": "15"
    }
  ],
  "ItemCategories": [
    {
      "$ref": "8"
    },
    {
      "$ref": "8"
    }
  ],
  "Accountings": [
    {
      "$id": "16",
      "Id": 1,
      "AcNo": 2,
      "Name": "sample string 3",
      "IsDeleted": true,
      "TAX": 5.0,
      "AccountType": 0,
      "Updated": "2025-04-04T05:34:32.299973+02:00",
      "SortOrder": 7
    },
    {
      "$ref": "16"
    }
  ],
  "ItemCampaigns": [
    {
      "$ref": "6"
    },
    {
      "$ref": "6"
    }
  ],
  "ItemGroups": [
    {
      "$id": "17",
      "Id": 1,
      "ItemId": "8bea173d-fed9-464f-aed7-10b25fd757fa",
      "GroupId": "027f4104-d058-462b-82e6-8a2aa1c098e9",
      "Qty": 4.0,
      "Price": 5.0,
      "Deleted": true,
      "Updated": "2025-04-04T05:34:32.299973+02:00",
      "Description": "sample string 8",
      "Bong": true,
      "PrinterId": 10,
      "ItemType": 0,
      "ServeType": 64,
      "Tax": 12.0,
      "DiscountAllowed": true
    },
    {
      "$ref": "17"
    }
  ],
  "ProductPrices": [
    {
      "$ref": "9"
    },
    {
      "$ref": "9"
    }
  ],
  "PricePolicies": [
    {
      "$ref": "13"
    },
    {
      "$ref": "13"
    }
  ],
  "ItemStocks": [
    {
      "$id": "18",
      "Id": 1,
      "ItemId": "a3fe3b6e-d2ed-426a-a2a3-877c949ade76",
      "Quantity": 3.0,
      "Updated": "2025-04-04T05:34:32.299973+02:00"
    },
    {
      "$ref": "18"
    }
  ],
  "PolicyGroups": [
    {
      "$id": "19",
      "Id": 1,
      "Title": "sample string 2",
      "Updated": "2025-04-04T05:34:32.299973+02:00",
      "GroupPolicies": [
        {
          "$ref": "14"
        },
        {
          "$ref": "14"
        }
      ]
    },
    {
      "$ref": "19"
    }
  ],
  "PriceGroupPolicies": [
    {
      "$ref": "14"
    },
    {
      "$ref": "14"
    }
  ],
  "ItemPolicyGroups": [
    {
      "$id": "20",
      "Id": 1,
      "ItemId": "75622828-a874-4819-833e-8f5e842ceb53",
      "GroupId": 3,
      "Active": true,
      "Deleted": true,
      "Updated": "2025-04-04T05:34:32.299973+02:00"
    },
    {
      "$ref": "20"
    }
  ],
  "ItemIngredients": [
    {
      "$id": "21",
      "Id": 1,
      "ItemId": "a5246fc8-fb47-4ff2-abe7-0b95ec58f287",
      "IngredientId": "41198180-27ce-4071-8511-6a9beeb1be35",
      "ShowOnReceipt": true,
      "QuickAdd": true,
      "Qty": 6.0,
      "Unit": 0,
      "Price": 7.0,
      "SortOrder": 8,
      "Deleted": true,
      "Updated": "2025-04-04T05:34:32.299973+02:00"
    },
    {
      "$ref": "21"
    }
  ],
  "ItemConfigurations": [
    {
      "$ref": "10"
    },
    {
      "$ref": "10"
    }
  ],
  "ItemDiscountedPrices": [
    {
      "$id": "22",
      "Id": 1,
      "ItemId": "1e81319c-a0c4-4454-a9c2-d224c90118c3",
      "Price": 3.0,
      "StartDate": "2025-04-04T05:34:32.299973+02:00",
      "EndDate": "2025-04-04T05:34:32.299973+02:00",
      "Deleted": true,
      "Updated": "2025-04-04T05:34:32.299973+02:00"
    },
    {
      "$ref": "22"
    }
  ],
  "ItemInventories": [
    {
      "$id": "23",
      "ItemInventoryID": "d203b713-1b77-4937-9487-0671a22f4c95",
      "ItemId": "c56d5bee-e384-4a50-9c6d-17157941aa89",
      "WarehouseID": "bd3a358b-0b41-49ad-bf71-c9427cb715d5",
      "WarehouseLocationID": "ced7556b-b377-44ea-828b-e5e8e917b601",
      "StockCount": 5.0,
      "StockReservations": 6.0,
      "Synced": true,
      "Updated": "2025-04-04T05:34:32.299973+02:00",
      "Direction": 9
    },
    {
      "$ref": "23"
    }
  ],
  "ServeTypes": [
    {
      "$id": "24",
      "Id": 64,
      "Name": "sample string 2",
      "SortOrder": 3,
      "ColorCode": "sample string 4",
      "Updated": "2025-04-04T05:34:32.299973+02:00"
    },
    {
      "$ref": "24"
    }
  ],
  "ServeFlows": [
    {
      "$id": "25",
      "Id": 64,
      "Name": "sample string 2",
      "StartAutomatically": true,
      "Updated": "2025-04-04T05:34:32.299973+02:00"
    },
    {
      "$ref": "25"
    }
  ],
  "ServeFlowTypes": [
    {
      "$id": "26",
      "Id": 1,
      "FlowId": 64,
      "ServeTypeId": 64,
      "SortOrder": 4,
      "Deleted": true,
      "Updated": "2025-04-04T05:34:32.299973+02:00"
    },
    {
      "$ref": "26"
    }
  ],
  "ItemPrinters": [
    {
      "$id": "27",
      "Id": "7c7c1ceb-90ba-4008-b968-2c177785aa56",
      "ItemId": "305ae774-f063-4320-9375-08fbcd880b5d",
      "OutletId": "1fe0709c-4121-40dd-9607-ee9f2069e13b",
      "TerminalId": "a4b9fa22-b2a5-4df8-bc34-929ad6680284",
      "PrinterId": 5,
      "Updated": "2025-04-04T05:34:32.299973+02:00"
    },
    {
      "$ref": "27"
    }
  ],
  "PriceLists": [
    {
      "$id": "28",
      "Id": "f665465b-8b78-4b17-b435-cfc1bed23d34",
      "Code": "sample string 2",
      "Name": "sample string 3",
      "Comment": "sample string 4",
      "IsDefault": true,
      "Deleted": true,
      "Updated": "2025-04-04T05:34:32.299973+02:00"
    },
    {
      "$ref": "28"
    }
  ],
  "ItemPriceLists": [
    {
      "$id": "29",
      "Id": "07691539-9847-4ab0-b3b3-55123be7115f",
      "PriceListId": "4eea509b-c367-46b9-8f39-382e528ff1ed",
      "ItemId": "8f2ce150-2921-4db1-9463-38ecf006ce0e",
      "Price": 4.0,
      "Quantity": 5.0,
      "ValidFrom": "2025-04-04T05:34:32.299973+02:00",
      "ValidTo": "2025-04-04T05:34:32.299973+02:00",
      "Deleted": true,
      "Updated": "2025-04-04T05:34:32.299973+02:00",
      "Code": "sample string 10",
      "Name": "sample string 11"
    },
    {
      "$ref": "29"
    }
  ],
  "CampaignMasters": [
    {
      "$ref": "3"
    },
    {
      "$ref": "3"
    }
  ],
  "CampaignPriceDetails": [
    {
      "$ref": "4"
    },
    {
      "$ref": "4"
    }
  ],
  "ProductCampaigns": [
    {
      "$id": "30",
      "Id": "54d199a8-2f25-4718-bb16-96d6f2154ce2",
      "ItemId": "4e2511d1-1e09-4948-bc14-5b36d16a3c2d",
      "CampaignId": "610d1e74-d4ba-4432-a18d-0b84ed0662ee",
      "StartDate": "2025-04-04T05:34:32.299973+02:00",
      "EndDate": "2025-04-04T05:34:32.299973+02:00",
      "Active": true,
      "Updated": "2025-04-04T05:34:32.299973+02:00"
    },
    {
      "$ref": "30"
    }
  ],
  "CategoryItemGroups": [
    {
      "$ref": "12"
    },
    {
      "$ref": "12"
    }
  ],
  "ItemOptionGroups": [
    {
      "$id": "31",
      "Id": "7ed7eadd-252b-4fb8-8492-300cabf2a1a2",
      "Name": "sample string 2",
      "Description": "sample string 3",
      "FreeQty": 4.0,
      "PriceAdd": 5.0,
      "PriceRemove": 6.0,
      "MinQty": 7.0,
      "MaxQty": 8.0,
      "Placement": 0,
      "SortOrder": 9,
      "Deleted": true,
      "Updated": "2025-04-04T05:34:32.299973+02:00"
    },
    {
      "$ref": "31"
    }
  ],
  "ItemOptions": [
    {
      "$ref": "11"
    },
    {
      "$ref": "11"
    }
  ],
  "ItemOptionGroupOptions": [
    {
      "$id": "32",
      "Id": "039d1dc7-4bc7-4195-9ed9-aa0b1c9bb6c2",
      "ItemOptionGroupId": "83bc41af-de26-4a1f-a2a2-563f17298c6a",
      "ItemId": "718ed5cd-21bb-49e3-adf6-ffb6cf293f3f",
      "UsePriceFromGroup": true,
      "PriceAdd": 5.0,
      "PriceRemove": 6.0,
      "Active": true,
      "SortOrder": 8,
      "Updated": "2025-04-04T05:34:32.299973+02:00"
    },
    {
      "$ref": "32"
    }
  ],
  "ItemOutletStatuses": [
    {
      "$id": "33",
      "Id": "83dc6ee6-5b98-46a3-b0aa-a3edfe67489d",
      "ItemId": "13aafd28-05a7-4c7c-9051-18b9ac1f404f",
      "OutletId": "ea91824c-ab38-49d5-afae-15e480b9234d",
      "Active": true,
      "Updated": "2025-04-04T05:34:32.299973+02:00"
    },
    {
      "$ref": "33"
    }
  ],
  "ItemTags": [
    {
      "$ref": "5"
    },
    {
      "$ref": "5"
    }
  ],
  "Tags": [
    {
      "$id": "34",
      "Id": "9fba6a9c-3933-436a-8b96-712927bf2cc3",
      "Name": "sample string 2",
      "ItemAssignable": true,
      "OrderAssignable": true,
      "Action": "sample string 5",
      "Deleted": true,
      "Synced": true,
      "Updated": "2025-04-04T05:34:32.299973+02:00",
      "Assignable": "Item"
    },
    {
      "$ref": "34"
    }
  ],
  "IconStores": [
    {
      "$id": "35",
      "Id": 1,
      "Type": 0,
      "Title": "sample string 2",
      "Photo": "QEA=",
      "Created": "2025-04-04T05:34:32.299973+02:00",
      "Updated": "2025-04-04T05:34:32.299973+02:00",
      "ImageToShow": "QEA=",
      "PhotoURL": "data:image/png;base64,QEA="
    },
    {
      "$ref": "35"
    }
  ],
  "ItemLanguageTexts": [
    {
      "$id": "36",
      "Id": "3b41ec13-56b5-41fe-9b5e-a89cc9e0fa4b",
      "ItemId": "904d6b98-6124-4d38-9f7c-3bfdd6c006da",
      "LanguageId": 3,
      "Name": "sample string 4",
      "ShortDescription": "sample string 5",
      "LongDescription": "sample string 6",
      "Updated": "2025-04-04T05:34:32.299973+02:00"
    },
    {
      "$ref": "36"
    }
  ]
}