MarketMan

The MarketMan connector lets your workflows interact with the MarketMan restaurant inventory management platform. Manage inventory, place orders, track waste, view reports, and more.

For the full API reference, see the MarketMan API documentation.

Connection setup

Get API credentials from MarketMan

Contact MarketMan or your account manager to obtain your API Partner Key and API Partner Password.

Find your Buyer/Vendor GUIDs

Use the get-authorised-accounts tool (or the MarketMan API) to retrieve the GUIDs for the buyers and vendors you want to manage.

Add the connection in Spojit

Go to Connections in Spojit, click Add Connection, select MarketMan, and enter:

API Key: Your API partner key
API Password: Your API partner password
Buyer GUID (optional): Default buyer for buyer-side operations
Vendor GUID (optional): Default vendor for vendor-side operations

MarketMan’s API has a limit of 500 calls per 24 hours per API consumer. All dates use the format yyyy/mm/dd hh:mm:ss.

Tools

Auth & Accounts

get-token: Get access token

Get a MarketMan access token. Mainly for debugging; authentication is handled automatically.No parameters required.Example response:

{
  "IsSuccess": true,
  "Token": "eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCJ9...",
  "ErrorMessage": null,
  "ErrorCode": null
}

get-authorised-accounts: List accessible accounts

List all buyer and vendor accounts accessible with your API credentials.No parameters required.Example response:

{
  "IsSuccess": true,
  "Buyers": [
    {
      "BuyerGuid": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
      "BuyerName": "Downtown Bistro",
      "ChainGuid": "00000000-0000-0000-0000-000000000000",
      "ChainName": null
    },
    {
      "BuyerGuid": "b2c3d4e5-f6a7-8901-bcde-f12345678901",
      "BuyerName": "Airport Cafe",
      "ChainGuid": "c3d4e5f6-a7b8-9012-cdef-123456789012",
      "ChainName": "City Restaurants Group"
    }
  ],
  "Vendors": [
    {
      "VendorGuid": "d4e5f6a7-b8c9-0123-defa-234567890123",
      "VendorName": "Fresh Produce Co."
    }
  ]
}

get-chain-buyers: Get chain buyers

Get all buyers in a chain (for chain/HQ accounts).

string

Buyer GUID. Uses the default from your connection if not provided.

Example request:

{
  "buyerGuid": "c3d4e5f6-a7b8-9012-cdef-123456789012"
}

Example response:

{
  "IsSuccess": true,
  "Buyers": [
    {
      "BuyerGuid": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
      "BuyerName": "Downtown Bistro"
    },
    {
      "BuyerGuid": "b2c3d4e5-f6a7-8901-bcde-f12345678901",
      "BuyerName": "Airport Cafe"
    }
  ]
}

Buyer: Inventory

get-inventory-items: Get inventory items

Get all inventory items for a buyer, including stock levels and details.

string

Buyer GUID. Uses the default from your connection if not provided.

Example response:

{
  "IsSuccess": true,
  "Items": [
    {
      "ItemGuid": "e5f6a7b8-c9d0-1234-efab-345678901234",
      "ItemName": "Whole Milk",
      "CategoryID": 1,
      "CategoryName": "Dairy",
      "QuantityOnHand": 24.0,
      "UnitOfMeasure": "Gallon",
      "StorageAreaName": "Walk-in Cooler",
      "LastPurchasePrice": 3.49,
      "AveragePrice": 3.52,
      "TotalValue": 84.48
    },
    {
      "ItemGuid": "f6a7b8c9-d012-3456-fabc-456789012345",
      "ItemName": "All-Purpose Flour",
      "CategoryID": 2,
      "CategoryName": "Dry Goods",
      "QuantityOnHand": 50.0,
      "UnitOfMeasure": "lb",
      "StorageAreaName": "Dry Storage",
      "LastPurchasePrice": 0.75,
      "AveragePrice": 0.72,
      "TotalValue": 36.00
    }
  ]
}

get-items: Get all items

Get all items (ingredients, products) for a buyer.

string

Buyer GUID.

Example response:

{
  "IsSuccess": true,
  "Items": [
    {
      "ID": 10001,
      "Name": "Whole Milk",
      "CategoryID": 1,
      "CategoryName": "Dairy",
      "UnitOfMeasure": "Gallon",
      "MinOnHand": 10,
      "MaxOnHand": 50,
      "IsActive": true
    },
    {
      "ID": 10002,
      "Name": "Espresso Beans",
      "CategoryID": 3,
      "CategoryName": "Coffee",
      "UnitOfMeasure": "lb",
      "MinOnHand": 5,
      "MaxOnHand": 30,
      "IsActive": true
    }
  ]
}

get-inventory-counts: Get inventory counts

Get inventory count records for a buyer.

string

Buyer GUID.

string

Start date (yyyy/mm/dd hh:mm:ss).

string

End date (yyyy/mm/dd hh:mm:ss).

Example request:

{
  "dateTimeFromUTC": "2025/03/01 00:00:00",
  "dateTimeToUTC": "2025/03/31 23:59:59"
}

Example response:

{
  "IsSuccess": true,
  "InventoryCounts": [
    {
      "CountID": 5001,
      "CountDateUTC": "2025/03/15 08:00:00",
      "CountType": "Full",
      "UserName": "John Doe",
      "Items": [
        {
          "ItemName": "Whole Milk",
          "CountQuantity": 22.0,
          "UnitOfMeasure": "Gallon",
          "StorageAreaName": "Walk-in Cooler"
        },
        {
          "ItemName": "All-Purpose Flour",
          "CountQuantity": 48.0,
          "UnitOfMeasure": "lb",
          "StorageAreaName": "Dry Storage"
        }
      ]
    }
  ]
}

set-inventory-count: Create inventory count

Create a new inventory count.

string

Buyer GUID.

object

required

Inventory count data object.

Example request:

{
  "countData": {
    "CountDateUTC": "2025/04/01 08:00:00",
    "Items": [
      {
        "ItemID": 10001,
        "CountQuantity": 20.0,
        "StorageAreaID": 1
      },
      {
        "ItemID": 10002,
        "CountQuantity": 12.0,
        "StorageAreaID": 2
      }
    ]
  }
}

Example response:

{
  "IsSuccess": true,
  "CountID": 5010
}

get-menu-items: Get menu items

Get all menu items for a buyer.

string

Buyer GUID.

Example response:

{
  "IsSuccess": true,
  "MenuItems": [
    {
      "MenuItemID": 201,
      "MenuItemName": "Cappuccino",
      "MenuItemCategoryName": "Hot Drinks",
      "SalePrice": 4.50,
      "CostPrice": 1.20,
      "FoodCostPercentage": 26.67,
      "IsActive": true,
      "Ingredients": [
        { "ItemName": "Espresso Beans", "Quantity": 0.04, "UnitOfMeasure": "lb" },
        { "ItemName": "Whole Milk", "Quantity": 0.06, "UnitOfMeasure": "Gallon" }
      ]
    },
    {
      "MenuItemID": 202,
      "MenuItemName": "Caesar Salad",
      "MenuItemCategoryName": "Salads",
      "SalePrice": 12.00,
      "CostPrice": 3.85,
      "FoodCostPercentage": 32.08,
      "IsActive": true
    }
  ]
}

get-waste-events: Get waste events

Get waste events for a buyer within a date range.

string

Buyer GUID.

string

Start date.

string

End date.

Example request:

{
  "dateTimeFromUTC": "2025/03/01 00:00:00",
  "dateTimeToUTC": "2025/03/31 23:59:59"
}

Example response:

{
  "IsSuccess": true,
  "WasteEvents": [
    {
      "WasteEventID": 301,
      "WasteDateUTC": "2025/03/10 14:30:00",
      "WasteReason": "Expired",
      "UserName": "Sarah Miller",
      "Items": [
        {
          "ItemName": "Whole Milk",
          "Quantity": 2.0,
          "UnitOfMeasure": "Gallon",
          "Cost": 6.98
        }
      ],
      "TotalCost": 6.98
    }
  ]
}

Buyer: Orders

get-orders-by-delivery-date: Get orders by delivery date

Get all orders within a delivery date range.

string

Buyer GUID.

string

required

Start date (yyyy/mm/dd hh:mm:ss).

string

required

End date.

string

Filter: Approved, Sent, or Pending.

Example request:

{
  "dateTimeFromUTC": "2025/04/01 00:00:00",
  "dateTimeToUTC": "2025/04/07 23:59:59",
  "orderStatus": "Sent"
}

Example response:

{
  "IsSuccess": true,
  "Orders": [
    {
      "OrderGuid": "a1b2c3d4-0001-0000-0000-000000000001",
      "OrderNumber": "PO-2025-0401",
      "VendorName": "Fresh Produce Co.",
      "VendorGuid": "d4e5f6a7-b8c9-0123-defa-234567890123",
      "OrderStatus": "Sent",
      "SentDateUTC": "2025/03/30 10:00:00",
      "DeliveryDateUTC": "2025/04/02 06:00:00",
      "TotalPrice": 245.80,
      "Comment": "Please deliver before 7am",
      "Items": [
        {
          "CatalogItemCode": "FP-TOM-001",
          "ItemName": "Roma Tomatoes",
          "Quantity": 20,
          "UnitOfMeasure": "lb",
          "Price": 2.49,
          "TotalPrice": 49.80
        },
        {
          "CatalogItemCode": "FP-LET-001",
          "ItemName": "Romaine Lettuce",
          "Quantity": 10,
          "UnitOfMeasure": "head",
          "Price": 1.99,
          "TotalPrice": 19.90
        }
      ]
    }
  ]
}

get-orders-by-sent-date: Get orders by sent date

Get all orders within a sent date range.

string

required

Start date.

string

required

End date.

Example request:

{
  "dateTimeFromUTC": "2025/03/25 00:00:00",
  "dateTimeToUTC": "2025/03/31 23:59:59"
}

Example response:

{
  "IsSuccess": true,
  "Orders": [
    {
      "OrderGuid": "a1b2c3d4-0001-0000-0000-000000000001",
      "OrderNumber": "PO-2025-0401",
      "VendorName": "Fresh Produce Co.",
      "OrderStatus": "Sent",
      "SentDateUTC": "2025/03/30 10:00:00",
      "DeliveryDateUTC": "2025/04/02 06:00:00",
      "TotalPrice": 245.80
    }
  ]
}

get-catalog-items: Get vendor catalog items

Get all vendor catalog items available for ordering.

string

Buyer GUID.

string

Filter by specific vendor.

Example request:

{
  "vendorGuid": "d4e5f6a7-b8c9-0123-defa-234567890123"
}

Example response:

{
  "IsSuccess": true,
  "CatalogItems": [
    {
      "CatalogItemCode": "FP-TOM-001",
      "CatalogItemName": "Roma Tomatoes",
      "VendorGuid": "d4e5f6a7-b8c9-0123-defa-234567890123",
      "VendorName": "Fresh Produce Co.",
      "Price": 2.49,
      "UnitOfMeasure": "lb",
      "MinOrderQuantity": 5,
      "IsActive": true
    },
    {
      "CatalogItemCode": "FP-LET-001",
      "CatalogItemName": "Romaine Lettuce",
      "VendorGuid": "d4e5f6a7-b8c9-0123-defa-234567890123",
      "VendorName": "Fresh Produce Co.",
      "Price": 1.99,
      "UnitOfMeasure": "head",
      "MinOrderQuantity": 1,
      "IsActive": true
    }
  ]
}

create-order: Create order

Create a new purchase order and send it to a vendor.

string

required

Vendor GUID to send the order to.

array

required

Array of { CatalogItemCode, Quantity } objects.

string

Order status (e.g., Sent).

string

Delivery date.

string

Order comment (up to 800 characters).

Example request:

{
  "vendorGuid": "d4e5f6a7-b8c9-0123-defa-234567890123",
  "catalogItems": [
    { "CatalogItemCode": "FP-TOM-001", "Quantity": 20 },
    { "CatalogItemCode": "FP-LET-001", "Quantity": 10 }
  ],
  "orderStatus": "Sent",
  "deliveryDateUTC": "2025/04/05 06:00:00",
  "comment": "Please deliver before 7am"
}

Example response:

{
  "IsSuccess": true,
  "OrderGuid": "b2c3d4e5-0002-0000-0000-000000000002",
  "OrderNumber": "PO-2025-0405"
}

Buyer: Categories, Vendors & Users

get-categories: Get categories

Get all buyer categories.Example response:

{
  "IsSuccess": true,
  "Categories": [
    { "ID": 1, "Name": "Dairy" },
    { "ID": 2, "Name": "Dry Goods" },
    { "ID": 3, "Name": "Coffee" },
    { "ID": 4, "Name": "Produce" },
    { "ID": 5, "Name": "Meat & Poultry" },
    { "ID": 6, "Name": "Cleaning Supplies" }
  ]
}

set-category: Create/update category

string

required

Category name.

string

Category ID. Omit to create, include to update.

Example request (create):

{
  "name": "Beverages"
}

Example response:

{
  "IsSuccess": true,
  "ID": 7
}

get-vendors: Get connected vendors

Get all vendors connected to the buyer account.Example response:

{
  "IsSuccess": true,
  "Vendors": [
    {
      "VendorGuid": "d4e5f6a7-b8c9-0123-defa-234567890123",
      "VendorName": "Fresh Produce Co.",
      "ContactEmail": "orders@freshproduce.com",
      "ContactPhone": "555-0100",
      "MinimumOrder": 50.00,
      "DeliveryDays": "Mon,Wed,Fri"
    },
    {
      "VendorGuid": "e5f6a7b8-c9d0-1234-efab-345678901234",
      "VendorName": "Metro Meats",
      "ContactEmail": "sales@metromeats.com",
      "ContactPhone": "555-0200",
      "MinimumOrder": 100.00,
      "DeliveryDays": "Tue,Thu"
    }
  ]
}

get-buyer-users: Get buyer users

Get all users for a buyer.Example response:

{
  "IsSuccess": true,
  "Users": [
    {
      "UserGuid": "f6a7b8c9-d012-3456-fabc-456789012345",
      "UserName": "John Doe",
      "Email": "john@downtownbistro.com",
      "Role": "Admin",
      "IsActive": true
    },
    {
      "UserGuid": "a7b8c9d0-1234-5678-abcd-567890123456",
      "UserName": "Sarah Miller",
      "Email": "sarah@downtownbistro.com",
      "Role": "Manager",
      "IsActive": true
    }
  ]
}

Buyer: Reports & Documents

get-actual-theo-data: Actual vs Theoretical data

Get Actual vs Theoretical inventory data for variance analysis.

string

Start date.

string

End date.

Example request:

{
  "fromDateUTC": "2025/03/01 00:00:00",
  "toDateUTC": "2025/03/31 23:59:59"
}

Example response:

{
  "IsSuccess": true,
  "Items": [
    {
      "ItemName": "Whole Milk",
      "CategoryName": "Dairy",
      "ActualUsage": 120.0,
      "TheoreticalUsage": 115.5,
      "Variance": 4.5,
      "VariancePercentage": 3.90,
      "VarianceCost": 15.84,
      "UnitOfMeasure": "Gallon"
    },
    {
      "ItemName": "Espresso Beans",
      "CategoryName": "Coffee",
      "ActualUsage": 28.0,
      "TheoreticalUsage": 26.5,
      "Variance": 1.5,
      "VariancePercentage": 5.66,
      "VarianceCost": 18.75,
      "UnitOfMeasure": "lb"
    }
  ]
}

get-menu-profitability: Menu profitability report

Get menu profitability report data.Example response:

{
  "IsSuccess": true,
  "MenuItems": [
    {
      "MenuItemName": "Cappuccino",
      "CategoryName": "Hot Drinks",
      "SalePrice": 4.50,
      "CostPrice": 1.20,
      "Profit": 3.30,
      "FoodCostPercentage": 26.67,
      "QuantitySold": 520,
      "TotalRevenue": 2340.00,
      "TotalCost": 624.00,
      "TotalProfit": 1716.00
    },
    {
      "MenuItemName": "Caesar Salad",
      "CategoryName": "Salads",
      "SalePrice": 12.00,
      "CostPrice": 3.85,
      "Profit": 8.15,
      "FoodCostPercentage": 32.08,
      "QuantitySold": 180,
      "TotalRevenue": 2160.00,
      "TotalCost": 693.00,
      "TotalProfit": 1467.00
    }
  ]
}

get-docs-by-doc-date: Get documents by date

Get invoices and delivery notes within a date range.

string

required

Start date.

string

required

End date.

Example request:

{
  "dateTimeFromUTC": "2025/03/01 00:00:00",
  "dateTimeToUTC": "2025/03/31 23:59:59"
}

Example response:

{
  "IsSuccess": true,
  "Documents": [
    {
      "DocGuid": "c3d4e5f6-0003-0000-0000-000000000003",
      "DocNumber": "INV-2025-0315",
      "DocType": "Invoice",
      "DocDateUTC": "2025/03/15 00:00:00",
      "VendorName": "Fresh Produce Co.",
      "TotalAmount": 245.80,
      "Items": [
        {
          "ItemName": "Roma Tomatoes",
          "Quantity": 20,
          "UnitOfMeasure": "lb",
          "Price": 2.49,
          "TotalPrice": 49.80
        }
      ]
    }
  ]
}

Vendor

vendor-get-products: Get product catalog

Get the vendor’s product catalog.

string

Vendor GUID.

Example response:

{
  "IsSuccess": true,
  "Products": [
    {
      "ProductGuid": "e5f6a7b8-0004-0000-0000-000000000004",
      "ProductName": "Roma Tomatoes",
      "ProductCode": "FP-TOM-001",
      "Price": 2.49,
      "UnitOfMeasure": "lb",
      "CategoryName": "Vegetables",
      "IsActive": true,
      "MinOrderQuantity": 5
    },
    {
      "ProductGuid": "f6a7b8c9-0005-0000-0000-000000000005",
      "ProductName": "Romaine Lettuce",
      "ProductCode": "FP-LET-001",
      "Price": 1.99,
      "UnitOfMeasure": "head",
      "CategoryName": "Vegetables",
      "IsActive": true,
      "MinOrderQuantity": 1
    }
  ]
}

vendor-set-product: Create/update product

object

required

Product data object.

Example request:

{
  "productData": {
    "ProductName": "Organic Basil",
    "ProductCode": "FP-BAS-001",
    "Price": 3.99,
    "UnitOfMeasure": "bunch",
    "CategoryName": "Herbs",
    "IsActive": true,
    "MinOrderQuantity": 2
  }
}

Example response:

{
  "IsSuccess": true,
  "ProductGuid": "a7b8c9d0-0006-0000-0000-000000000006"
}

vendor-get-orders-by-delivery-date: Get vendor orders

Get vendor orders within a delivery date range.

string

required

Start date.

string

required

End date.

Example request:

{
  "dateTimeFromUTC": "2025/04/01 00:00:00",
  "dateTimeToUTC": "2025/04/07 23:59:59"
}

Example response:

{
  "IsSuccess": true,
  "Orders": [
    {
      "OrderGuid": "a1b2c3d4-0001-0000-0000-000000000001",
      "OrderNumber": "PO-2025-0401",
      "BuyerName": "Downtown Bistro",
      "OrderStatus": "Sent",
      "DeliveryDateUTC": "2025/04/02 06:00:00",
      "TotalPrice": 245.80,
      "Items": [
        {
          "ProductCode": "FP-TOM-001",
          "ProductName": "Roma Tomatoes",
          "Quantity": 20,
          "UnitOfMeasure": "lb",
          "Price": 2.49,
          "TotalPrice": 49.80
        }
      ]
    }
  ]
}

vendor-get-customers: Get connected customers

Get customers (buyers) connected to the vendor.Example response:

{
  "IsSuccess": true,
  "Customers": [
    {
      "BuyerGuid": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
      "BuyerName": "Downtown Bistro",
      "ContactEmail": "orders@downtownbistro.com",
      "ContactPhone": "555-0300"
    },
    {
      "BuyerGuid": "b2c3d4e5-f6a7-8901-bcde-f12345678901",
      "BuyerName": "Airport Cafe",
      "ContactEmail": "orders@airportcafe.com",
      "ContactPhone": "555-0400"
    }
  ]
}

Advanced

raw-request: Execute any API endpoint

Execute any MarketMan API endpoint not covered by other tools. Authentication is handled automatically, and BuyerGuid/VendorGuid are auto-injected from your connection defaults.See the MarketMan API documentation for the full endpoint reference.

string

required

API path relative to /v3/ (e.g., buyers/webhooks/CreateWebhook).

object

Request body as JSON.

Example request:

{
  "path": "buyers/inventory/GetTransfers",
  "body": {
    "DateTimeFromUTC": "2025/03/01 00:00:00",
    "DateTimeToUTC": "2025/03/31 23:59:59"
  }
}

Example response:

{
  "IsSuccess": true,
  "Transfers": [
    {
      "TransferID": 801,
      "TransferDateUTC": "2025/03/10 11:00:00",
      "FromLocation": "Downtown Bistro",
      "ToLocation": "Airport Cafe",
      "Items": [
        {
          "ItemName": "Espresso Beans",
          "Quantity": 5.0,
          "UnitOfMeasure": "lb"
        }
      ]
    }
  ]
}

Overview

Integrations

Remote MCP Servers

Databases

Data Processing

Text and Strings

Numbers and Dates

Files and Media

Encoding and Validation

Developer Tools

Connection setup

Tools

Auth & Accounts

Buyer: Inventory

Buyer: Orders

Buyer: Categories, Vendors & Users

Buyer: Reports & Documents

Vendor

Advanced

​Connection setup

​Tools

​Auth & Accounts

​Buyer: Inventory

​Buyer: Orders

​Buyer: Categories, Vendors & Users

​Buyer: Reports & Documents

​Vendor

​Advanced

Connection setup

Tools

Auth & Accounts

Buyer: Inventory

Buyer: Orders

Buyer: Categories, Vendors & Users

Buyer: Reports & Documents

Vendor

Advanced