Name: Openfda Api Reference
Author: 1102tools

Search skills.../

Openfda Api Reference | Skills Pool

def safety_signal_scan(drug_name):
    """Top reactions, serious/non-serious counts, deaths, trend."""
    results = {}
    results["top_reactions"] = openfda_query("drug/event",
        search=f"patient.drug.openfda.generic_name:{drug_name}",
        count="patient.reaction.reactionmeddrapt.exact", limit=20)
    for severity, label in [(1, "serious"), (2, "non_serious")]:
        r = safe_query("drug/event",
            search=f"patient.drug.openfda.generic_name:{drug_name}+AND+serious:{severity}", limit=1)
        results[f"{label}_count"] = r.get("meta", {}).get("results", {}).get("total", 0)
    r = safe_query("drug/event",
        search=f"patient.drug.openfda.generic_name:{drug_name}+AND+seriousnessdeath:1", limit=1)
    results["death_count"] = r.get("meta", {}).get("results", {}).get("total", 0)
    results["trend"] = openfda_query("drug/event",
        search=f"patient.drug.openfda.generic_name:{drug_name}", count="receivedate")
    return results

import time

def compare_drug_profiles(drug_a, drug_b, n_reactions=15):
    """Compare top adverse reactions between two drugs."""
    profiles = {}
    for drug in [drug_a, drug_b]:
        r = openfda_query("drug/event",
            search=f"patient.drug.openfda.generic_name:{drug}",
            count="patient.reaction.reactionmeddrapt.exact", limit=n_reactions)
        profiles[drug] = {item["term"]: item["count"] for item in r.get("results", [])}
        time.sleep(0.5)
    return profiles

def predicate_search(product_code, limit=20):
    """Find 510(k) cleared devices for predicate identification."""
    clearances = openfda_query("device/510k",
        search=f"product_code:{product_code}+AND+decision_description:SESE",
        limit=limit, sort="decision_date:desc")
    classification = safe_query("device/classification",
        search=f"product_code:{product_code}", limit=1)
    return {"classification": classification.get("results", []),
            "clearances": clearances.get("results", [])}

def recall_scan(product_name, categories=None):
    """Search recalls across drug, device, and food enforcement."""
    if categories is None:
        categories = ["drug", "device", "food"]
    results = {}
    for cat in categories:
        try:
            r = openfda_query(f"{cat}/enforcement",
                search=f"product_description:{product_name}", limit=10)
            results[cat] = r.get("results", [])
        except Exception as e:
            results[cat] = {"error": str(e)}
        time.sleep(0.3)
    return results

# FAERS: serious events in date range
def serious_events(drug_name, start="20240101", end="20241231", limit=10):
    return openfda_query("drug/event",
        search=f"patient.drug.openfda.generic_name:{drug_name}+AND+serious:1+AND+receivedate:[{start}+TO+{end}]",
        limit=limit)

# Drug labeling by brand
def get_label(brand_name):
    return openfda_query("drug/label", search=f'openfda.brand_name:"{brand_name}"', limit=1)

# Label by NDA/ANDA
def label_by_application(app_number):
    return openfda_query("drug/label", search=f'openfda.application_number:"{app_number}"', limit=1)

# Drug approval by brand
def drug_approval(brand_name):
    return openfda_query("drug/drugsfda", search=f'openfda.brand_name:"{brand_name}"', limit=5)

# NDC lookup
def lookup_ndc(ndc):
    return openfda_query("drug/ndc", search=f'product_ndc:"{ndc}"', limit=1)

# Class I drug recalls
def class1_drug_recalls(start="20250101", limit=10):
    return openfda_query("drug/enforcement",
        search=f'classification:"Class I"+AND+report_date:[{start}+TO+20261231]', limit=limit)

# Device events by generic name
def device_events(device_name, limit=10):
    return openfda_query("device/event", search=f'device.generic_name:"{device_name}"', limit=limit)

# 510(k) by applicant
def find_510k(applicant, limit=10):
    return openfda_query("device/510k", search=f"applicant:{applicant}", limit=limit)

# PMA lookup
def find_pma(applicant=None, trade_name=None, limit=10):
    search = f"applicant:{applicant}" if applicant else f"trade_name:{trade_name}" if trade_name else None
    return openfda_query("device/pma", search=search, limit=limit)

# Device classification
def device_classification(product_code):
    return openfda_query("device/classification", search=f"product_code:{product_code}", limit=5)

# UDI lookup
def udi_lookup(brand_name, limit=5):
    return openfda_query("device/udi", search=f'brand_name:"{brand_name}"', limit=limit)

# Food events
def food_events(product_name, limit=10):
    return openfda_query("food/event", search=f'products.name_brand:"{product_name}"', limit=limit)

def paginate_results(endpoint, search, max_results=5000, page_size=100):
    all_results, skip = [], 0
    while skip < max_results and skip < 25000:
        r = openfda_query(endpoint, search=search, limit=page_size, skip=skip)
        batch = r.get("results", [])
        if not batch: break
        all_results.extend(batch)
        total = r.get("meta", {}).get("results", {}).get("total", 0)
        skip += page_size
        if skip >= total: break
        time.sleep(0.3)
    return all_results

{"meta": {"last_updated": "2026-01-27", "results": {"skip": 0, "limit": 10, "total": 419459}},
 "results": [...]}

{"results": [{"term": "NAUSEA", "count": 752669}, {"term": "FATIGUE", "count": 742320}]}

{"results": [{"time": "20240101", "count": 12345}]}

Error	Cause	Fix
404	No matching records	Normal; use safe_query wrapper
409	Rate limit exceeded	Wait; add api_key
400 "Invalid search syntax"	Malformed search	Check colons, brackets, quotes
Count returns single words	Missing `.exact`	Add `.exact` to text fields
Count returns SERVER_ERROR	Missing `.exact` on text field	Hard error; add `.exact`
Count returns 404 on numeric	Used `.exact` on numeric field	Remove `.exact`
Skip exceeds limit	skip+limit > 25,000	Use bulk downloads
Wrong data in results	Wrong field path	Verify at open.fda.gov

Openfda Api Reference

Table of Contents

1. Drug Endpoint Fields

drug/event (FAERS)

Openfda Api Reference

Table of Contents

1. Drug Endpoint Fields

drug/event (FAERS)

drug/label (SPL)

drug/drugsfda (Approvals)

drug/ndc (NDC Directory)

drug/enforcement (Recalls)

2. Device Endpoint Fields

device/event (MAUDE)

device/510k

device/pma

device/classification

device/udi (GUDID)

device/enforcement

3. Food/Tobacco/Other Endpoint Fields

food/event (CAERS)

food/enforcement

tobacco/problem

other/nsde

other/substance

4. Composite Workflows

Safety Signal Scan

Compare Drug Adverse Event Profiles

Predicate Device Finder

Recall Intelligence

Per-Endpoint Query Examples

5. Pagination

6. Response Schemas

Standard response

Count response

Date count response

7. Troubleshooting

Session Logs

OpenClaw Test Heap Leaks

Node Connect

Openclaw Qa Testing

Openclaw Secret Scanning Maintainer

Flags