get_rows
Pack: healthdata · Endpoint: https://gateway.pipeworx.io/healthdata/mcp
No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/get_rows for the schema, then POST the same URL with its arguments for the data.
Read actual rows from a HealthData.gov dataset by its Socrata 4x4 id. Optional SoQL where (e.g. “state = ‘CA’”) and order (e.g. “date DESC”). Use get_dataset first to see the column names. This returns the DATA, not a download link.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
id | string | yes | Socrata 4x4, e.g. “g62h-syeh”. |
limit | number | no | Rows to return, 1-1000 (default 20). |
offset | number | no | Skip this many rows (default 0). |
where | string | no | SoQL filter, e.g. “state = ‘CA’”. |
order | string | no | SoQL ordering, e.g. “date DESC”. |
Example call
Arguments
{
"id": "g62h-syeh",
"limit": 5
}curl
curl -X POST https://gateway.pipeworx.io/healthdata/mcp \
-H 'Content-Type: application/json' \
-d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"get_rows","arguments":{"id":"g62h-syeh","limit":5}}}'TypeScript (@pipeworx/sdk)
import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();
const result = await pipeworx.call('get_rows', {
"id": "g62h-syeh",
"limit": 5
});More examples
{
"id": "g62h-syeh",
"limit": 10,
"where": "state = 'CA'",
"order": "date DESC"
}Connect
Add this to your MCP client config, or use one-click install buttons:
{
"mcpServers": {
"healthdata": {
"url": "https://gateway.pipeworx.io/healthdata/mcp"
}
}
}See Getting Started for client-specific install steps.