aca_federal_upper_limit

Pack: medicaid-drug-rebate · 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/aca_federal_upper_limit for the schema, then POST the same URL with its arguments for the data.

ACA Federal Upper Limit (FUL) for multiple-source generic drugs from CMS, “ACA Federal Upper Limits”: the FUL per unit, the weighted average of AMPs it derives from, product group, strength, dosage form, route, package size, A-rated flag. Search by ingredient or NDC. Defaults to the latest monthly file; pass year and month for an earlier one. NDCs here are dashed 5-4-2 in the source; either form is accepted.

Parameters

NameTypeRequiredDescription
ingredientstringnoPart of the ingredient name, e.g. “METFORMIN”.
ndcstringnoNDC, 11 digits or dashed.
strengthstringnoPart of the strength text, e.g. “500MG”.
yearnumbernoFour-digit year of the monthly file. Default: latest.
monthnumbernoMonth 1-12 of the monthly file. Default: latest.
limitnumbernoRows (1-100, default 25).
offsetnumbernoRows to skip.

Example call

Arguments

{
  "ingredient": "METFORMIN",
  "strength": "500MG",
  "limit": 3
}

curl

curl -X POST https://gateway.pipeworx.io/medicaid-drug-rebate/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"aca_federal_upper_limit","arguments":{"ingredient":"METFORMIN","strength":"500MG","limit":3}}}'

TypeScript (@pipeworx/sdk)

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

const result = await pipeworx.call('aca_federal_upper_limit', {
  "ingredient": "METFORMIN",
  "strength": "500MG",
  "limit": 3
});

Response shape

FieldTypeDescription
periodstring
totalnumber
returnednumber
upper_limitsarray
sourcestring
data_as_ofstring
Full JSON Schema
{
  "type": "object",
  "properties": {
    "period": {
      "type": "string"
    },
    "total": {
      "type": "number"
    },
    "returned": {
      "type": "number"
    },
    "upper_limits": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "ndc": {
            "type": "string"
          },
          "ndc_dashed": {
            "type": "string"
          },
          "ingredient": {
            "type": "string"
          },
          "strength": {
            "type": "string"
          },
          "dosage": {
            "type": "string"
          },
          "route": {
            "type": "string"
          },
          "unit_type": {
            "type": "string"
          },
          "package_size": {
            "type": "string"
          },
          "product_group": {
            "type": "string"
          },
          "aca_ful_per_unit": {
            "type": "string"
          },
          "weighted_average_of_amps": {
            "type": "string"
          },
          "a_rated": {
            "type": "boolean"
          },
          "ful_over_175_percent_of_weighted_amp": {
            "type": "boolean"
          },
          "period": {
            "type": "string"
          }
        },
        "additionalProperties": true
      }
    },
    "source": {
      "type": "string"
    },
    "data_as_of": {
      "type": "string"
    }
  },
  "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 medicaid-drug-rebate pack
{
  "mcpServers": {
    "medicaid-drug-rebate": {
      "url": "https://gateway.pipeworx.io/medicaid-drug-rebate/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

Regenerated from source · build November 16, 2026