In short, we need a Webservice prototype that can receive JSON request, process the request and reply it back in JSON, too. The Webservice will have MySQL as its DB. All of this should be implemented in Amazon Web Services.
In detail, functionalities that the Webservice must be able to do include, but not limited to, the followings:
1. Receive and respond to JSON request.
2. Integrated with MySQL
3. Request example can be:
4. Process the request above. What I mean by process is, of course, parse the parameters supplied, make the appropriate DB manipulation, and create the responds.
For example, if it's an addToDB request, then it will only add a row to the DB and the respond should be a simple string: "Success" or something like this.
If it's a searchInDB, then it will search the DB and return the result.
All of the responds must be in JSON form.
5. As this is only a prototype, the DB only has one table.
One last thing to remember, this is a prototype with the main objective is to know if this Webservice can be integrated with the client. We expect there will be a continuation of this project if the prototype is successful. Of course, in the next project, the winner of this project will be given extra priority. So, please make this into your consideration.
Please ask if you need further clarification.