`ca_procurement_commodities`

Pack: ca-procurement · Connect: https://pipeworx.io/mcp (see Connect below for a single-pack URL)

No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/ca_procurement_commodities for the schema, then POST the same URL with its arguments for the data.

Rank what the State of California spends the most on, by commodity category (UNSPSC commodity title), from the SCPRS purchase-order data on data.ca.gov. Returns each category with total dollars and purchase-order count, largest first, optionally scoped to a department/agency or fiscal year. Answers “what does California buy the most of”, “top spending categories for the CA Department of Health Care Services”. This is CALIFORNIA STATE data (not federal).

Parameters

Name	Type	Required	Description
`department`	string	no	Optional: restrict to one awarding department/agency (case-insensitive substring).
`fiscal_year`	string	no	Optional exact fiscal year, e.g. “2014-2015”.
`limit`	number,string	no	How many categories to return (default 20, max 100).

Example call

Arguments

{
  "department": "Health Care Services",
  "limit": 20
}

curl

curl -X POST https://gateway.pipeworx.io/ca-procurement/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"ca_procurement_commodities","arguments":{"department":"Health Care Services","limit":20}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('ca_procurement_commodities', {
  "department": "Health Care Services",
  "limit": 20
});

More examples

{
  "fiscal_year": "2014-2015",
  "limit": 15
}

Connect

Add this to your MCP client config — every tool in the catalog, including this one — or use one-click install buttons:

{
  "mcpServers": {
    "pipeworx": {
      "url": "https://pipeworx.io/mcp"
    }
  }
}

Connect to just the ca-procurement pack

{
  "mcpServers": {
    "ca-procurement": {
      "url": "https://gateway.pipeworx.io/ca-procurement/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

ca_procurement_commodities