reportGenerator route for accessing a sharepoint 2010 list and spitting the data out with HTML

index.coffee

require 'coffee-script'

request = require 'request'

data =
  getData: (cb)->
    username = 'someUser'
    password = 'somePassword'

    proto = 'https://'
    site = 'sharepoint.domain.com/_vti_bin/listdata.svc'

    config =
      url: proto + username + ':' + password + '@' + site + '/' + 'someList?$orderby=someColumn'
      json: true

    request config, (err, res, body)->
      if err
        console.log err

      cb body.d.results

routes =
  index: (req, res)->

    data.getData (dataArray)->

      options =
        title:  'reportGenerator'
        layout: 'layout.jade'
        items:  dataArray

      res.render 'index', options

module.exports = routes