1.0    Project Overview

In this project,  we will build a web service to retrieve and display expiration dates for some products. This web service will take a list Vehicle Identification Numbers (VINs) as input, and return the expiration dates of each VIN. 

1.1    Competition Task Overview

In this contest, we will build a web service (getExpirationDates()) that takes a list of VINs as input, and outputs expiration dates of each product for each VIN. Detailed requirements and explanations can be found in "Functional Specification.pdf" in the forum, so please read it through before you start working on the tasks.

1.1.1  Overview

The system has 3 telematics products which are VT (Virtual technician), Vis (Visibility Software) and Tablet. Vis includes VT, and Tablet includes Vis and VT, so the products have a hierachy, in which VT is the lowest and Tablet is the highest. The database includes expiration dates of all products, however, the expiration dates of the lower products can be influenced by those of the higher products. Please read section 2.3 of the functional specification to understand the two scenarios.

1.1.2  Web Service

You will need to create a new web service as an add-on on top of existing OwlService. We have run an F2F contest to build a sample service (see here), and the submission can be found in the forum.

The new web service should retrieve the latest expiration date details for each product from the Online Warranty Link (OWL) system. Please read section 2.4 of the functional specification to get more detailed descriptions of the requirements. The details of the database is in section 2.4.6 and the query to get the expiration date against a given VIN is in section 2.4.7.

1.1.3  Error Handling

If the web service gets any error (for instance, invalid VIN, or errors in the database), the exceptions should be logged in the database in table DC_EXPECTION_LOG. Please read section 2.4.2.2 of the functional specification to get all possible exceptions and the details of DC_EXPECTION_LOG table.

1.1.4  Amazon WorkSpace

All the development will be done in amazon workspace. When you are ready to start working on this contest, please request workspace in the contest forum.

Final Submission Guidelines

Updated source code and deployment guide.