Skip to main content

OpenFDA

Availability
Available CoreAvailable StandardAvailable PlusAvailable ProAvailable Enterprise FlexAvailable PyAirbyte
Connector type (beta)
Available Data replicationNot available Agent(learn more)
Support Level
Marketplace
Connector Version
0.0.68 (last updated 4 days ago)
Sync Success Rate
Low
Usage Rate
Low
Data workers used
0.2 per sync (Learn more)
Definition ID
b97d588f-d49f-440c-9158-9dd33c59fd26

OpenFDA provides access to a number of high-value, high priority and scalable structured datasets, including adverse events, drug product labeling, and recall enforcement reports. With this conenctor we can fetch data from the streams like Drugs , Animal and Veterinary Adverse Events and Food Adverse Events etc. Docs:https://open.fda.gov/apis/

Configuration​

InputTypeDescriptionDefault Value
api_keystringAPI Key. Optional openFDA API key. Without a key openFDA allows 240 requests per minute and 1,000 requests per day per IP address; with a key the daily quota is 120,000 requests. Get a key at https://open.fda.gov/apis/authentication/.

Streams​

Stream NamePrimary KeyPaginationSupports Full SyncSupports Incremental
Animal and Veterinary Adverse Eventsunique_aer_id_numberDefaultPaginator✅❌
Tobacco Problem Reportsreport_idDefaultPaginator✅❌
Food Adverse Eventsreport_numberDefaultPaginator✅❌
Food Enforcement Reportsrecall_numberDefaultPaginator✅❌
Drug Adverse EventsDefaultPaginator✅❌
Drug Product LabellingDefaultPaginator✅❌
Drug NDC Libraryproduct_idDefaultPaginator✅❌
Drug recall Enforcement ReportsDefaultPaginator✅❌
DrugsDefaultPaginator✅❌

IP allow list​

If you use Airbyte Cloud and your organization restricts access to specific IPs, add the Airbyte Cloud IP addresses to your allow list.

Reference​

Config fields reference

Field
Type
Property name
string
api_key

Changelog​

Expand to review
VersionDatePull RequestSubject
0.0.682026-10-1388722Update dependencies
0.0.672026-10-0788214Use openFDA search_after Link-header pagination so streams with more than 25,000 records no longer fail with Skip value must 25000 or less; use page size 1000; add optional api_key to raise rate limits
0.0.662026-10-0687984Update dependencies
0.0.652026-09-2987291Update dependencies
0.0.642026-09-2286735Update dependencies
0.0.632026-09-1586160Update dependencies
0.0.622026-09-0885605Update dependencies
0.0.612026-08-1884713Update dependencies
0.0.602026-08-1184068Update dependencies
0.0.592026-08-0483559Update dependencies
0.0.582026-07-2883043Update dependencies
0.0.572026-07-2182535Update dependencies
0.0.562026-07-1481901Update dependencies
0.0.552026-06-3081179Update dependencies
0.0.542026-06-2380601Update dependencies
0.0.532026-06-1679966Update dependencies
0.0.522026-06-0979441Update dependencies
0.0.512026-06-0278880Update dependencies
0.0.502026-04-2877391Update dependencies
0.0.492026-04-2175670Update dependencies
0.0.482026-03-1774971Update dependencies
0.0.472026-03-1074627Update dependencies
0.0.462026-03-0374225Update dependencies
0.0.452026-02-0372586Update dependencies
0.0.442026-01-2072185Update dependencies
0.0.432026-01-1471674Update dependencies
0.0.422025-12-1870469Update dependencies
0.0.412025-11-2570134Update dependencies
0.0.402025-11-1869691Update dependencies
0.0.392025-10-2969018Update dependencies
0.0.382025-10-2168287Update dependencies
0.0.372025-10-1467747Update dependencies
0.0.362025-10-0767334Update dependencies
0.0.352025-09-3066385Update dependencies
0.0.342025-09-0965788Update dependencies
0.0.332025-08-2365231Update dependencies
0.0.322025-08-0964703Update dependencies
0.0.312025-08-0264180Update dependencies
0.0.302025-07-2663927Update dependencies
0.0.292025-07-1963439Update dependencies
0.0.282025-07-1263185Update dependencies
0.0.272025-07-0562547Update dependencies
0.0.262025-06-2862399Update dependencies
0.0.252025-06-2161914Update dependencies
0.0.242025-06-1460545Update dependencies
0.0.232025-05-1060129Update dependencies
0.0.222025-05-0359467Update dependencies
0.0.212025-04-2759108Update dependencies
0.0.202025-04-1958494Update dependencies
0.0.192025-04-1257905Update dependencies
0.0.182025-04-0557299Update dependencies
0.0.172025-03-2956748Update dependencies
0.0.162025-03-2256180Update dependencies
0.0.152025-03-0855524Update dependencies
0.0.142025-03-0155023Update dependencies
0.0.132025-02-2354576Update dependencies
0.0.122025-02-1553956Update dependencies
0.0.112025-02-0853479Update dependencies
0.0.102025-02-0153028Update dependencies
0.0.92025-01-2552491Update dependencies
0.0.82025-01-1851872Update dependencies
0.0.72025-01-1151368Update dependencies
0.0.62024-12-2850718Update dependencies
0.0.52024-12-2150285Update dependencies
0.0.42024-12-1449668Update dependencies
0.0.32024-12-1249351Update dependencies
0.0.22024-12-1149090Starting with this version, the Docker image is now rootless. Please note that this and future versions will not be compatible with Airbyte versions earlier than 0.64
0.0.12024-10-23Initial release by @ombhardwajj via Connector Builder
Was this page helpful?