Requirements

Client wants to send SMS reminder to their registered users. Get MOT expiry date using Gov MOT API (https://developer-portal.driver-vehicle-licensing.api.gov.uk/apis/vehicle-enquiry-service/vehicle-enquiry-service-description.html) and send SMS automatically.

  • 1 reminder 30 days before.

  • 1 reminder 7 days before.

Solution

  • PHP is a server scripting language, and a powerful tool for making dynamic and interactive Web pages.

  • MySQL is a relational database management system based on the Structured Query Language, which is the popular language for accessing and managing the records in the database. MySQL is open-source and free software under the GNU license.

  • The DVLA Vehicle Enquiry API is a RESTful service that provides vehicle details of a specified vehicle. It uses the vehicle registration number as input to search and provide details of the vehicle. The response data is provided in JSON format.

  • Twilio is a centralized messaging platform to engage customers across their preferred channels. Deliver messages to customers across preferred channels with an API for one-way, transactional messaging.

  • As, based on our requirements, we want to continue using PHP hosted in Prostack server and setup cron job to send SMS automatically.

Challenges

  • VES API Usage.

  • Login Page.

  • Search Details.

Outcome

  • We have implemented the live API to retrieve the data. You can submit any UK based vehicle registration number to verify -

    https://mot.scube.co/

  • "Add" details is to add new entries to the database. Through this, we can send the SMS to the users.

  • "List" is to view the the added users.

  • SMS automatic alert functions is ready and tested with a sample account internally.

Technology Used

PHP, MySql, DVLA API, Twilio