We want to make accessing data in our portal as easy as possible, that’s why all the data in our Open Data Portal is accessible via an application programming interface (API).
Our Open Data Portal uses a feature-rich registry system called CKAN. CKAN can be accessed by users through browsing and searching the data through the site, or from machine-to-machine through the API.
CKAN has extensive instructions on using its API, we’ve also provided some example code to search and query the API available in a public Gitlab open source code repository. These examples include extracting data for a specific BNF code and looping through multiple months and combining the data into one table.
There is currently a limit on the amount of data that a single API call can return of 100,000 rows. This doesn't prevent aggregations from being calculated and returned from the API via the embedded SQL functionality.
We encourage developers to innovate using the Open Data we release via our Open Data Portal. Are you using, or planning to use the Open Data Portal API? We’d love to hear from you.
If you have any questions, comments, or would like more information we’d love to hear from you too.
Feedback is important to us, and helps us improve the system and services we provide.
We’re still developing our Open Data Portal so please tell us what you think.
You can send your feedback to: firstname.lastname@example.org