Submit Expense Reports With One Message: Use Twilio MMS and Concur API To Make Expense Reports A Breeze

// After setting up Twilio to call our node.js app 
// ('/receiveMMS') when an SMS/MMS is received,
// the snippet below will get the Twilio-hosted
// MMS image URL and the message body, which
// represent the image receipt and expense amt

app.post('/receiveMMS', function (req, res) {

   fromTwilio.mediaUrl = req.body.MediaUrl0;
   fromTwilio.msgBody = +req.body.Body;  

   ....

});

// *Post image to Concur using Concur module*
// The snippet below takes the Twilio-hosted MMS image URL
// and passes it to be uploaded to Concur

function(callback) {

   options = {
   oauthToken:concurToken,
   imageURL: fromTwilio.mediaUrl
};

concur.receipt.send(options)
   .then(function(imageId) {
      console.log(imageId);
      callback(null, imageId);
   })
  .fail(function(error) {
      console.log(error);
      ///TODO: handle error
  });
},

// *Create expense entry and link image to it*

function(imageId, callback) {

    // Check if text message was included in MMS
    if (isNaN(fromTwilio.msgBody)) callback(null, "Receipt uploaded, expense entry skipped!");

    var now = new Date();
    var year = now.getFullYear();
    var month = now.getMonth();
    var date = now.getDate();

    var fullDate = year + '-' + (month +1) + '-' + date;

    // Populate QuickExpense JSON payload with
    // expense amount text sent through Twilio MMS
    var concurBody = {
        CurrencyCode: "USD",
        TransactionAmount: fromTwilio.msgBody,
        TransactionDate: fullDate,
        ReceiptImageID: imageId
    }

    var postData = JSON.stringify(concurBody);

    // Authorization parameters for Concur API
    var headers = {
        'Content-Type': 'application/json',
        'Content-Length': postData.length,
        'Authorization': 'OAuth ' + concurToken,
        'Accept' : 'application/json'
    };

    // Point call to QuickExpense Concur API
    var options = {
        host: 'www.concursolutions.com',
        port: 443,
        path: '/api/v3.0/expense/quickexpenses',
        method: 'POST',
        headers: headers
    };

    // Setup the request.
    var req = https.request(options, function (res) {
        res.setEncoding('utf-8');

        var responseString = '';

        res.on('data', function (data) {
            responseString += data;
        });

        res.on('end', function () {
            //console.log("Response: " + responseString);
            callback(null, "Receipt uploaded, expense entry created!");
        });
    });

    req.on('error', function (e) {
        // TODO: handle error.
    });

    req.write(postData);
    req.end();
}

// *Builds the TwiML (XML) request that this app sends back to Twilio, to be relayed back as SMS to user*
// Sample usage: sendTwiml(res, "Receipt uploaded, expense entry created!")

function sendTwiml(res, message) {
    var twiml = '<!--?xml version="1.0" encoding="UTF-8" ?-->' + message + '';
    res.send(twiml, {
        'Content-Type': 'text/xml'
    }, 200);
}