Ams Market Report
ams_market_reportRead 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). Every row keeps AMS's own fields: commodity, variety, package or unit, origin, and low / high / mostly / mean price as separate values; nothing is averaged. Optional commodity keeps only rows whose commodity, variety or group contains that word (e.g. "lime"); optional district keeps rows whose district or market location contains that text (e.g. "mexico crossings through texas"). If the report has rows but none match, the result says so and lists the commodities or districts it does carry. Reports are daily: a weekly view is a start_date/end_date range of up to 31 days, newest first. With no dates it returns the most recent report date (looking back up to a week). If AMS has no rows the status is "no_rows_for_request" with the report's last published date, never an empty array. Dates are ISO (2026-10-22).
Example tool call
This call uses example arguments supplied in the tool’s input schema.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"limit": 20,
"district": "mexico crossings through texas",
"end_date": "2026-10-23",
"commodity": "lime",
"report_id": 2402,
"start_date": "2026-10-19"
},
"name": "ams_market_report"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| date | No | One report date, ISO YYYY-MM-DD. | |
| limit | No | Max rows (default 100, max 500). Newest first. | |
| _apiKey | No | Optional. The gateway supplies the platform My Market News key; pass your own only to override. | |
| section | No | Report section name, case-insensitive. Omit to read the data sections (header sections are skipped). | |
| district | No | Keep only rows whose district or market location contains this text, e.g. "mexico crossings through texas" or "mcallen". | |
| end_date | No | Range end, ISO. | |
| commodity | No | Keep only rows whose commodity / variety / group contains this word, e.g. "lime". | |
| report_id | Yes | Report id from ams_market_report_search. | |
| start_date | No | Range start, ISO (use with end_date). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | No | ||
| report | No | ||
| source | Yes | ||
| status | Yes | ok, no_match, no_rows_for_request or no_rows_for_commodity | |
| message | No | ||
| complete | No | ||
| returned | No | ||
| commodity | No | ||
| report_id | No | ||
| requested | No | ||
| row_count | No | ||
| truncated | No | ||
| unit_note | No | ||
| data_as_of | No | ||
| price_note | No | ||
| report_slug | No | ||
| report_title | No | ||
| rows_with_price | No | ||
| commodity_filter | No | ||
| sections_returned | No | ||
| rows_without_price | No | ||
| sections_available | No | ||
| commodities_in_report | No | ||
| report_last_published | No | ||
| report_dates_in_result | No |