# Real time table data and update

**URL:** <https://opendataforum.transport.nsw.gov.au/t/real-time-table-data-and-update/1156>\
**Category:** Real-time Public Transport\
**Created:** [February 6, 2018, 7:02am UTC](https://opendataforum.transport.nsw.gov.au/t/real-time-table-data-and-update/1156 "2018-02-06T07:02:06Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![saravanan](https://avatars.discourse-cdn.com/v4/letter/s/eb8c5e/32.png) [@saravanan](https://opendataforum.transport.nsw.gov.au/u/saravanan)\
**Post date:** [February 6, 2018, 7:02am UTC](https://opendataforum.transport.nsw.gov.au/t/real-time-table-data-and-update/1156/1 "2018-02-06T07:02:06Z")

</div>

Hi, We are trying to integrate our app with real time table data for Sydney Trains. We plan to use following API to get the daily real time table data (Public Transport - Timetables - For Realtime ([Explore API - Public Transport - Timetables - For Realtime | TfNSW Open Data Hub and Developer Portal](https://opendata.transport.nsw.gov.au/node/332/exploreapi)).

1. Can you please clarify whether this above API provides complete timetable data (trips) for a specified day. At what time we can call this API to get the complete time table daily? Can you please let me know whether this API provides data from 00:00 AM to 11:59 PM daily?
2. Can we call the following API (Public Transport - Realtime Trip Updates API ([https://opendata.transport.nsw.gov.au/node/328/exploreapi](https://opendata.transport.nsw.gov.au/node/328/exploreapi)) to get the early arrival, delay time, stopping changes, platform changes? If so, at what interval do we need to call this API to get the updated details(for example: 10s seconds interval)?

---

<div class="post-metadata">

**Author:** ![alejandro.felman](https://avatars.discourse-cdn.com/v4/letter/a/bbe5ce/32.png) [@alejandro.felman](https://opendataforum.transport.nsw.gov.au/u/alejandro.felman)\
**Post date:** [February 6, 2018, 11:13pm UTC](https://opendataforum.transport.nsw.gov.au/t/real-time-table-data-and-update/1156/2 "2018-02-06T23:13:54Z")

</div>

Hi @saravanan, that API provides the static timetable + route shapes. You might need to combine a few APIs/datasets to achieve what you’re trying to do. Have a look at the [complete GTFS file](https://opendata.transport.nsw.gov.au/node/334/exploreapi) too and yes the Trip Updates API will give you stopping patterns and real-time data. I strongly recommend you read all the technical documentation and the Google GTFS spec, which can be found on our [documentation](https://opendata.transport.nsw.gov.au/documentation) page. The documents outline the structure of each API / feed and what data they each contain.

If you have any more specific questions regarding development hopefully another developer can help you out.

Thanks,  
Alex