How to page beyond openFDA's 25,000-record limit using search_after cursors
The openFDA adverse event API hard-caps the 'skip' parameter at 25,000, blocking developers who try to paginate large datasets with a simple offset loop. The workaround is to follow the 'Link' response header, which carries a 'search_after' cursor that bypasses the cap entirely. However, setting any non-zero 'skip' value silently degrades the cursor to a plain offset link, sending the loop straight back into the 25,000 wall. Without an API key, the maximum usable page size is 999 records — requests for 1,000 or more return a 403 error citing a missing API key, which also doubles as the daily quota-exceeded message. These behaviors were verified against the live API on July 20, 2026, across both drug and device event endpoints.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)
Log in to join the discussion and vote.
Log in