Added Multiple Changes and updates to web service

Multiple changes and additions to web service
Multiple changes to web service, new api calls

new api calls, updated sql queries, additional requests, fixes