While designing REST API our goals were:

Have we reached these goals? We hope so. Want to query the Default View of a Test table in a Test API database (21995) in HTML format? Open your browser and type:

You’ll be prompted for login (type and password (type pwd) and then there is your data.

Using jQuery? Easy! Create authorization token in database’s setup section, set authtoken variable and let jQuery handle the rest.

var authtoken = "0123456789ABCDEF0123456789ABCDEF";
    "" + authtoken +
    function(data) {
        /* here we have data */

In PHP? Still easy!

$authtoken = "0123456789ABCDEF0123456789ABCDEF";
$data = json_decode(
    "" . $authtoken .

In C#?

string authtoken = "0123456789ABCDEF0123456789ABCDEF";
object data = new JavaScriptSerializer().DeserializeObject(
    new WebClient().DownloadString(
"" + authtoken +

Please note that simplicity does not mean efficiency. Samples above are dead simple but in order to make API operations more effective you may want to enable compression and caching that will require little bit more complicated web client setup.