app.js

// ----------------------------------------------------------------------------
// Copyright (c) 2015 Microsoft Corporation. All rights reserved.
// ----------------------------------------------------------------------------

// This is a base-level Azure Mobile App SDK.
var express = require('express'),
    azureMobileApps = require('azure-mobile-apps');

var bodyParser = require('body-parser');
// Set up a standard Express app
var app = express();
app.use(bodyParser.json());

// If you are producing a combined Web + Mobile app, then you should handle
// anything like logging, registering middleware, etc. here

// Configuration of the Azure Mobile Apps can be done via an object, the
// environment or an auxiliary file.  For more information, see
// http://azure.github.io/azure-mobile-apps-node/global.html#configuration
var mobile = azureMobileApps({
    // Explicitly enable the Azure Mobile Apps home page
    homePage: true
});

// Import the files from the tables directory to configure the /tables endpoint
mobile.tables.import('./tables');

// Import the files from the api directory to configure the /api endpoint
mobile.api.import('./api');

// Initialize the database before listening for incoming requests
// The tables.initialize() method does the initialization asynchronously
// and returns a Promise.
mobile.tables.initialize()
    .then(function () {
        app.use(mobile);    // Register the Azure Mobile Apps middleware
        app.listen(process.env.PORT || 3000);   // Listen for requests
    });

UpdateHighScore.js

var api = {
    "post": function (req, res, next) {
      
      var sqlstring = 'UPDATE Highscore SET score=@score,playername=@playername WHERE id=@id';
      
        var query= {sql:sqlstring, 
            parameters:[
                {name:'score',value:req.body.score},
                {name:'playername',value:req.body.playername},
                {name:'id',value:req.body.id}]};
                
     req.azureMobile.data.execute(query).then(function(results)
     {
          var sql2 = "SELECT * FROM Highscore WHERE id=@id";
        var query2= {sql:sql2, 
            parameters:[
                {name:'id',value:req.body.id}]};
                
                req.azureMobile.data.execute(query2).then(
                    function(results2)
                    {
                        
                        res.json(results2);
                        }
                    );
     });
        
    }
};

module.exports=api;