Skip to main content
Glama

SupplySlate

by com.supplyslate
OverviewDiscussionsAdmin

upsert_supplier_catalog

Idempotent

Create or update normalized supplier catalog items through a durable manual import with row-level validation, history, evidence scope, availability, and commercial terms.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
itemsYes
idempotency_keyYes

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
catalog_importYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. Changed2 schema fields changed
    • removedOutput schema / properties / import
      Removed value: -{
-  "additionalProperties": {},
-  "properties": {
-    "accepted_rows": {
-      "maximum": 9007199254740991,
-      "minimum": 0,
-      "type": "integer"
-    },
-    "id": {
-      "minLength": 1,
-      "type": "string"
-    },
-    "rejected_rows": {
-      "maximum": 9007199254740991,
-      "minimum": 0,
-      "type": "integer"
-    },
-    "source_type": {
-      "type": "string"
-    },
-    "status": {
-      "type": "string"
-    },
-    "total_rows": {
-      "maximum": 9007199254740991,
-      "minimum": 0,
-      "type": "integer"
-    },
-    "validation_errors": {
-      "items": {},
-      "type": "array"
-    }
-  },
-  "required": [
-    "id",
-    "status",
-    "source_type"
-  ],
-  "type": "object"
-}
    • addedOutput schema / required
      Added value: +[
+  "catalog_import"
+]
  2. Changed16 schema fields changed
    • addedInput schema / properties / idempotency_key
      Added value: +{
+  "maxLength": 160,
+  "minLength": 1,
+  "type": "string"
+}
    • addedInput schema / properties / items / items / properties / availability_status
      Added value: +{
+  "default": "unknown",
+  "enum": [
+    "in_stock",
+    "limited",
+    "backorder",
+    "made_to_order",
+    "unavailable",
+    "unknown"
+  ],
+  "type": "string"
+}
    • removedInput schema / properties / items / items / properties / category_code
      Removed value: -{
-  "maxLength": 100,
-  "type": "string"
-}
    • addedInput schema / properties / items / items / properties / expires_at
      Added value: +{
+  "format": "date-time",
+  "pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z))$",
+  "type": "string"
+}
    • addedInput schema / properties / items / items / properties / fabrication_process_id
      Added value: +{
+  "maxLength": 100,
+  "type": "string"
+}
    • addedInput schema / properties / items / items / properties / lead_time_days
      Added value: +{
+  "maximum": 9007199254740991,
+  "minimum": 0,
+  "type": "integer"
+}
    • addedInput schema / properties / items / items / properties / minimum_order_quantity
      Added value: +{
+  "exclusiveMinimum": 0,
+  "type": "number"
+}
    • addedInput schema / properties / items / items / properties / network_category_code
      Added value: +{
+  "maxLength": 100,
+  "type": "string"
+}
    • addedInput schema / properties / items / items / properties / observed_at
      Added value: +{
+  "format": "date-time",
+  "pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z))$",
+  "type": "string"
+}
    • addedInput schema / properties / items / items / properties / package_multiple
      Added value: +{
+  "exclusiveMinimum": 0,
+  "type": "number"
+}
    • addedInput schema / properties / items / items / properties / price_currency
      Added value: +{
+  "pattern": "^[A-Z]{3}$",
+  "type": "string"
+}
    • addedInput schema / properties / items / items / properties / price_minor
      Added value: +{
+  "maximum": 9007199254740991,
+  "minimum": 0,
+  "type": "integer"
+}
    • addedInput schema / properties / items / items / properties / quantity_available
      Added value: +{
+  "minimum": 0,
+  "type": "number"
+}
    • changedInput schema / properties / items / maxItems
      Previous value: -100New value: +1000
    • changedInput schema / required
      Previous value: -[
-  "items"
-]New value: +[
+  "idempotency_key",
+  "items"
+]
    • changedOutput schema / (root)
      Previous value: -nullNew value: +{
+  "$schema": "https://json-schema.org/draft/2020-12/schema",
+  "additionalProperties": {},
+  "properties": {
+    "catalog_import": {
+      "additionalProperties": {},
+      "properties": {
+        "accepted_rows": {
+          "maximum": 9007199254740991,
+          "minimum": 0,
+          "type": "integer"
+        },
+        "id": {
+          "minLength": 1,
+          "type": "string"
+        },
+        "rejected_rows": {
+          "maximum": 9007199254740991,
+          "minimum": 0,
+          "type": "integer"
+        },
+        "source_type": {
+          "type": "string"
+        },
+        "status": {
+          "type": "string"
+        },
+        "total_rows": {
+          "maximum": 9007199254740991,
+          "minimum": 0,
+          "type": "integer"
+        },
+        "validation_errors": {
+          "items": {},
+          "type": "array"
+        }
+      },
+      "required": [
+        "id",
+        "status",
+        "source_type"
+      ],
+      "type": "object"
+    },
+    "import": {
+      "additionalProperties": {},
+      "properties": {
+        "accepted_rows": {
+          "maximum": 9007199254740991,
+          "minimum": 0,
+          "type": "integer"
+        },
+        "id": {
+          "minLength": 1,
+          "type": "string"
+        },
+        "rejected_rows": {
+          "maximum": 9007199254740991,
+          "minimum": 0,
+          "type": "integer"
+        },
+        "source_type": {
+          "type": "string"
+        },
+        "status": {
+          "type": "string"
+        },
+        "total_rows": {
+          "maximum": 9007199254740991,
+          "minimum": 0,
+          "type": "integer"
+        },
+        "validation_errors": {
+          "items": {},
+          "type": "array"
+        }
+      },
+      "required": [
+        "id",
+        "status",
+        "source_type"
+      ],
+      "type": "object"
+    }
+  },
+  "type": "object"
+}
  3. Added

TDQS

C2.6/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

The description hints at 'row-level validation' and 'durable import' but does not explicitly disclose side effects, partial failure behavior, or system interactions. The annotation idempotentHint=true is already given, and the description does not add any additional behavioral nuance such as rate limits or resource impacts.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single concise sentence without unnecessary filler. It packs multiple concepts (normalization, durable import, validation, history, evidence, availability, commercial terms) into one line, but remains efficient and does not ramble.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's moderate complexity with many item fields, the description lacks essential context about expected output, error handling, or edge cases. It does not mention what the function returns (e.g., success counts, IDs) or how failures are reported (e.g., row-level error details). The description is too high-level to fully orient a user for successful invocation.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters1/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The description provides no explanation of the required parameters (idempotency_key and items) or their purpose. The input schema contains many item properties (e.g., supplier_sku, price_minor, availability_status) but the description mentions only generic terms like 'availability' and 'commercial terms' without mapping them to specific fields. This leaves the parameter meanings largely ambiguous.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the core action: 'Create or update normalized supplier catalog items'. The verb 'upsert' is implicit in the name, and the description confirms both create and update. It distinguishes the resource type (supplier catalog items) from other tools like upsert_bom, though it does not explicitly contrast with related update tools.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description mentions 'durable manual import' but does not specify when to use this tool over alternatives (e.g., update_availability or update_supplier_capabilities). There is no guidance on conditions like bulk operations, data validation needs, or batch scenarios. It leaves the user to infer appropriate use cases.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

All SupplySlate toolsInspect
Try in Browser
One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Glama MCP Gateway

Add one secure layer between your agents and this server.

Resources