`ams_market_report`

Pack: usda-market-news · 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/ams_market_report for the schema, then POST the same URL with its arguments for the data.

Read dated rows from one USDA AMS My Market News report (fruit and vegetable shipping-point / terminal / import-crossing prices, grain, hay, cotton and other non-livestock reports).

Parameters

Name	Type	Required	Description
`report_id`	number	yes	Report id from ams_market_report_search.
`commodity`	string	no	Keep only rows whose commodity / variety / group contains this word, e.g. “lime”.
`district`	string	no	Keep only rows whose district or market location contains this text, e.g. “mexico crossings through texas” or “mcallen”.
`section`	string	no	Report section name, case-insensitive. Omit to read the data sections (header sections are skipped).
`date`	string	no	One report date, ISO YYYY-MM-DD.
`start_date`	string	no	Range start, ISO (use with end_date).
`end_date`	string	no	Range end, ISO.
`limit`	number	no	Max rows (default 100, max 500). Newest first.
`_apiKey`	string	no	Optional. The gateway supplies the platform My Market News key; pass your own only to override.

Example call

Arguments

{
  "report_id": 2402,
  "commodity": "lime",
  "district": "mexico crossings through texas",
  "start_date": "2026-10-19",
  "end_date": "2026-10-23",
  "limit": 20
}

curl

curl -X POST https://gateway.pipeworx.io/usda-market-news/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"ams_market_report","arguments":{"report_id":2402,"commodity":"lime","district":"mexico crossings through texas","start_date":"2026-10-19","end_date":"2026-10-23","limit":20}}}'

TypeScript (@pipeworx/sdk)

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

const result = await pipeworx.call('ams_market_report', {
  "report_id": 2402,
  "commodity": "lime",
  "district": "mexico crossings through texas",
  "start_date": "2026-10-19",
  "end_date": "2026-10-23",
  "limit": 20
});

More examples

{
  "report_id": 2711,
  "commodity": "corn",
  "limit": 10
}

Response shape

Always returns: status, source

Field	Type	Description
`status`	string	ok, no_match, no_rows_for_request or no_rows_for_commodity
`source`	string
`data_as_of`	string \| null
`complete`	boolean
`report_id`	number
`report_title`	string
`report_slug`	string \| null
`report`	object
`requested`	object
`commodity`	string
`commodity_filter`	string
`message`	string
`commodities_in_report`	array
`sections_returned`	array
`sections_available`	array
`report_dates_in_result`	object
`row_count`	number
`rows_with_price`	number
`rows_without_price`	number
`returned`	number
`truncated`	string
`price_note`	string
`unit_note`	string
`report_last_published`	string \| null
`rows`	array

Full JSON Schema

{
  "type": "object",
  "properties": {
    "status": {
      "type": "string",
      "description": "ok, no_match, no_rows_for_request or no_rows_for_commodity"
    },
    "source": {
      "type": "string"
    },
    "data_as_of": {
      "type": [
        "string",
        "null"
      ]
    },
    "complete": {
      "type": "boolean"
    },
    "report_id": {
      "type": "number"
    },
    "report_title": {
      "type": "string"
    },
    "report_slug": {
      "type": [
        "string",
        "null"
      ]
    },
    "report": {
      "type": "object",
      "additionalProperties": true
    },
    "requested": {
      "type": "object",
      "additionalProperties": true
    },
    "commodity": {
      "type": "string"
    },
    "commodity_filter": {
      "type": "string"
    },
    "message": {
      "type": "string"
    },
    "commodities_in_report": {
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "sections_returned": {
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "sections_available": {
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "report_dates_in_result": {
      "type": "object",
      "properties": {
        "earliest": {
          "type": [
            "string",
            "null"
          ]
        },
        "latest": {
          "type": [
            "string",
            "null"
          ]
        }
      },
      "additionalProperties": true
    },
    "row_count": {
      "type": "number"
    },
    "rows_with_price": {
      "type": "number"
    },
    "rows_without_price": {
      "type": "number"
    },
    "returned": {
      "type": "number"
    },
    "truncated": {
      "type": "string"
    },
    "price_note": {
      "type": "string"
    },
    "unit_note": {
      "type": "string"
    },
    "report_last_published": {
      "type": [
        "string",
        "null"
      ]
    },
    "rows": {
      "type": "array",
      "items": {
        "type": "object",
        "additionalProperties": true
      }
    }
  },
  "required": [
    "status",
    "source"
  ],
  "additionalProperties": true
}

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 usda-market-news pack

{
  "mcpServers": {
    "usda-market-news": {
      "url": "https://gateway.pipeworx.io/usda-market-news/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

ams_market_report