This web service must connect to a sql2008 database, read a view and choose to return in json format or xml file, depending on the parameter passaed. To build the webservice you can use a sample view called "ViewTemplate" and use field1, field2....field10 as fields. You must create a return method "Return" that will return the fields of the view. This method has one parameter, FileType, "1" for return xml and "2" for return jason file.
The authentication method at the webservice must be token based that will be validated on the server and generated by the application.