fda_nsde
Search comprehensive FDA drug product data using NDC codes or marketing status to find active or discontinued medications.
Instructions
Search NDC SPL Data Elements — comprehensive drug product data. Use 'missing:marketing_end_date' for products still on market. Use 'exists:marketing_end_date' for discontinued products.
Example searches:
'package_ndc:"55700-019-60"' — by NDC
'missing:"marketing_end_date"' — currently marketed products
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| search | No | OpenFDA search query. Examples: 'field:value', 'field:"Exact Phrase"', 'field:[20200101+TO+20231231]', '_exists_:field'. Combine with '+AND+', '+OR+', '+NOT+'. | |
| limit | No | Max results (default 10, max 100) |