Custom Connector

U.S. Food & Drug Administration (openFDA)

Global

The openFDA Connector facilitates seamless integration with the openFDA API, providing access to a wide range of U.S. FDA datasets — drugs, devices, food, animal and veterinary, tobacco, and other regulatory information. It acts as a proxy for querying adverse events, drug shortages, device clearances, and more. No API key is required.

Type
Virtual machines, Single VM, BYOL
Runs on
Google Compute Engine
Last update
24 Oct 2024
Category
Integration
Overview

Integration Overview

This document provides a detailed guide for each integration point, its purpose, configuration, and workflow support using the openFDA Connector, querying FDA datasets with flexible search parameters and result limits.

  • getAnimalVeterinaryEvents. Adverse event records for animal and veterinary products.
  • getDrugEvents. Adverse event records for drugs.
  • getDrugLabels. Drug labeling information.
  • getDrugNdc. National Drug Code (NDC) records.
  • getDrugEnforcement. Drug enforcement action records.
  • getDrugsFda. Records from the Drugs@FDA database.
  • getDrugShortages. Drug shortage records.
  • getDevice510k. 510(k) premarket notification records.
  • getDeviceClassification. Device classification records.
  • getDeviceEnforcement. Device enforcement action records.
  • getDeviceEvents. Device adverse event records.
  • getDevicePma. Premarket Approval (PMA) records.
  • getDeviceRecalls. Device recall records.
  • getDeviceRegistrationListing. Device registration and listing records.
  • getDeviceCovid19Serology. COVID-19 serology test records.
  • getDeviceUdi. Unique Device Identification (UDI) records.
  • getFoodEnforcement. Food enforcement action records.
  • getFoodEvents. Food adverse event records.
  • getHistoricalDocuments. Historical document records.
  • getNsde. National Surveillance Data Elements records.
  • getSubstance. Substance data records.
  • getUnii. Unique Ingredient Identifier records.
  • getTobaccoProblems. Tobacco problem report records.
Documentation

Detailed Integration Documentation

Animal & Veterinary Adverse Events

ActiongetAnimalVeterinaryEvents
PurposeRetrieves adverse event records for animal and veterinary products.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getAnimalVeterinaryEvents with search=animal.species:dog&limit=5, then process the results for reporting, research, or compliance.

Drug Adverse Events

ActiongetDrugEvents
PurposeRetrieves adverse event records for drugs, supporting pharmacovigilance and safety monitoring.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getDrugEvents with search=patient.drug.medicinalproduct:aspirin&limit=5, then process the results for reporting, research, or compliance.

Drug Labeling Information

ActiongetDrugLabels
PurposeRetrieves drug labeling information for regulatory compliance and product analysis.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getDrugLabels with search=brand_name:Advil&limit=5, then process the results for reporting, research, or compliance.

National Drug Code (NDC)

ActiongetDrugNdc
PurposeRetrieves National Drug Code (NDC) records for drug identification and inventory.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getDrugNdc with search=generic_name:ibuprofen&limit=5, then process the results for reporting, research, or compliance.

Drug Enforcement Actions

ActiongetDrugEnforcement
PurposeRetrieves drug enforcement action records for monitoring regulatory actions.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getDrugEnforcement with search=report_date:[20040101+TO+20131231]&limit=5, then process the results for reporting, research, or compliance.

Drugs@FDA Database

ActiongetDrugsFda
PurposeRetrieves records from the Drugs@FDA database for approval and regulatory analysis.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getDrugsFda with search=brand_name:Tylenol&limit=5, then process the results for reporting, research, or compliance.

Drug Shortages

ActiongetDrugShortages
PurposeRetrieves drug shortage records for tracking supply chain issues.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getDrugShortages with search=shortage_status:Current&limit=5, then process the results for reporting, research, or compliance.

Device 510(k) Clearances

ActiongetDevice510k
PurposeRetrieves 510(k) premarket notification records for medical devices.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getDevice510k with search=advisory_committee:cv&limit=5, then process the results for reporting, research, or compliance.

Device Classifications

ActiongetDeviceClassification
PurposeRetrieves device classification records for regulatory and product development.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getDeviceClassification with search=regulation_number:872.6855&limit=5, then process the results for reporting, research, or compliance.

Device Enforcement Actions

ActiongetDeviceEnforcement
PurposeRetrieves device enforcement action records for monitoring regulatory actions.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getDeviceEnforcement with search=report_date:[20040101+TO+20131231]&limit=5, then process the results for reporting, research, or compliance.

Device Adverse Events

ActiongetDeviceEvents
PurposeRetrieves adverse event records for medical devices for safety monitoring.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getDeviceEvents with search=date_received:[20130101+TO+20141231]&limit=5, then process the results for reporting, research, or compliance.

Premarket Approval (PMA)

ActiongetDevicePma
PurposeRetrieves Premarket Approval (PMA) records for medical devices.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getDevicePma with search=decision_code:APPR&limit=5, then process the results for reporting, research, or compliance.

Device Recalls

ActiongetDeviceRecalls
PurposeRetrieves device recall records for safety and compliance monitoring.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getDeviceRecalls with search=product_code:FOZ&limit=5, then process the results for reporting, research, or compliance.

Device Registration & Listing

ActiongetDeviceRegistrationListing
PurposeRetrieves device registration and listing records.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getDeviceRegistrationListing with search=products.product_code:HQY&limit=5, then process the results for reporting, research, or compliance.

COVID-19 Serology Tests

ActiongetDeviceCovid19Serology
PurposeRetrieves records related to COVID-19 serology tests.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getDeviceCovid19Serology with limit=5, then process the results for reporting, research, or compliance.

Unique Device Identification (UDI)

ActiongetDeviceUdi
PurposeRetrieves Unique Device Identification (UDI) records for device tracking.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getDeviceUdi with search=_exists_:public_device_record_key&limit=5, then process the results for reporting, research, or compliance.

Food Enforcement Actions

ActiongetFoodEnforcement
PurposeRetrieves food enforcement action records for food safety monitoring.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getFoodEnforcement with search=report_date:[20040101+TO+20131231]&limit=5, then process the results for reporting, research, or compliance.

Food Adverse Events

ActiongetFoodEvents
PurposeRetrieves adverse event records related to food products.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getFoodEvents with search=date_started:[20040101+TO+20160101]&limit=5, then process the results for reporting, research, or compliance.

Historical Documents

ActiongetHistoricalDocuments
PurposeRetrieves historical document records for research and regulatory analysis.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getHistoricalDocuments with search=doc_type:pr+AND+year:1919&limit=5, then process the results for reporting, research, or compliance.

National Surveillance Data Elements (NSDE)

ActiongetNsde
PurposeRetrieves NSDE records for regulatory data analysis.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getNsde with limit=5, then process the results for reporting, research, or compliance.

Substance Data

ActiongetSubstance
PurposeRetrieves substance data records for chemical and regulatory analysis.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getSubstance with limit=5, then process the results for reporting, research, or compliance.

Unique Ingredient Identifier (UNII)

ActiongetUnii
PurposeRetrieves UNII records for ingredient tracking and compliance.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getUnii with limit=5, then process the results for reporting, research, or compliance.

Tobacco Problem Reports

ActiongetTobaccoProblems
PurposeRetrieves problem reports for tobacco products for regulatory oversight.
Parameterssearch (optional) – query in field:term format (supports AND/OR, phrase matches, date ranges). limit (optional, 1–1000, default 1).
ConfigurationConfigure the base URL via CONNECTOR_ENV_OPENFDA_BASE_URL (https://api.fda.gov). No API key required.
OutputSuccessful: JSON with results (array of records) and meta (query details and count). Failure: error details (HTTP 400 invalid syntax, 404 invalid fields or no matches).
Workflow exampleExecute getTobaccoProblems with limit=5, then process the results for reporting, research, or compliance.

Example Workflow: Drug Safety and Device Compliance Analysis

Query drug adverse eventsUse getDrugEvents with search=receivedate:[20230601+TO+20250601]&limit=10 to identify safety trends.
Monitor drug shortagesExecute getDrugShortages with search=shortage_status:Current&limit=5 for supply chain management.
Analyze 510(k) clearancesUse getDevice510k with search=advisory_committee:cv&limit=5 for market analysis.
Track device adverse eventsExecute getDeviceEvents with a date range for post-market surveillance.
Enhance reporting with food dataUse getFoodEvents with a date range for public health reports.

Configuration Notes

Base URLSet CONNECTOR_ENV_OPENFDA_BASE_URL to https://api.fda.gov.
Error handlingHandle HTTP 400 (invalid syntax) and 404 (invalid fields or no matches) gracefully; check the response body for error details.
Search fieldsValid fields for the search parameter vary by endpoint — consult the openFDA documentation (open.fda.gov/apis) for dataset-specific fields.
Rate limitsThe openFDA API may impose rate limits for high-volume usage; monitor response headers and implement retry logic if needed.
Support

For technical support, contact custom-connectors-support@isolutions.sa.

free consultation

Schedule a Free Consultation With Our Specialists

Book a free demo
request

Begin Your Adventure With Experienced Professionals

Send request
help desk

Do You Have Questions or Want More Information? Call Now.

Contact support