Output bus timetable data from BODS as API response

Timetables can be downloaded in zip format here:
https://data.bus-data.dft.gov.uk/timetable/download/

The requirement would be to digest this into a database, and create a web based API to query specific timetables for a single bus stop.

The input parameter for the API would be a bus stop NAPTan ID: eg: 340000418PR

The output would be a response with the next timetabled arrival depending on the date/time the request is made.

At a minimum it would return the following fields: Route ID, Destination (if available), Arrival time

example response would be:

route,destination,arrivaltime
X1, Oxford City Centre, 13:01
X3, Barton, 13:04
300, Oxford, 13:05
X3, Abingdon Town Centre, 13:06
X32, John Radcliffe Hospital, 13:07
X32, Wantage, 13:11
X2, Oxford City Centre, 13:14
300, Oxford, 13:15
X2, Didcot, 13:16

I am open to programming language and database. The timetable data is refreshed often so a cron job to update the data would be required.

There are guides and you can register for an API key for free.
https://data.bus-data.dft.gov.uk/api/timetable-openapi/
https://data.bus-data.dft.gov.uk/guide-me/



There is a python client for the Bus Open Data platform here.

https://github.com/department-for-transport-BODS/bods-data-extractor

Any questions please let me know.