I need to build a service wherein i can access the database, get / insert / update values to and from the database and send the response back in Json format. Kindly help me with designing the same.
I am looking for a RESTful service.
You should start from included in Studio examples,
check demo Job with very specific name "demoREST" :-)