Currently, the market study shows that 85% of the customers of American Airlines travel only once a year. Therefore, most of these customers are not accustomed to the flight schedule - they don't know when they should get to the airport and in the worst case - have to cancel their travel plans. We aim to solve this by developing a push notification service bot that starts immediately as the customers requests it. We notify the user timely about when to leave their home and where to arrive based on the current traffic, weather, and flight status.

What it does

The user data received by telegram is stored in the DB. A cronjob picks up the new customers from the DB and updates them with the time at which they need to leave based on the inputs given by Google Directions API, Flight Aware API, and Weather API. We made mathematical formulation for time calculation using the driving time, departure time of flight and the predicted weather for the city as our inputs.

How we built it

We used Python to integrate various APIs (Google Maps Directions API, Telegram API, Flight Aware API, Weather API) into Telegram. Our system architecture also involved creating MySQL database on a Python platform which is integrated on API Protocols.

Challenges we ran into

The server-side inputs from telegram to SQL Database while following standard API Protocols proved to be difficult. We tested this service to run in real-time and work as an end-to-end serivce which took a heavy effort from the team.

Accomplishments that we're proud of

We tried to make it very easy and simple to use for the user. All the user has to do is to send a flight number and their street address and wait for three seconds!

What we learned

We learned how to integrate APIs into the service. We also learned the importance of customer service.

What's next for LastMileAA

This service can be extended to optimize customer support by integrating cab services like Uber, baggage claim service, managing the whole itinerary and it could be a portal service.

Share this project: