Unstable CSV API for Google Docs Spreadsheet - migrate to Google Sheets API

[barbeau]

I tried to run this script today, and got a parsing error. After I looked into it, apparently the "gid" parameter in the Google URL to return the contents of the OBA Server Directory (Google Doc Spreadsheet) is broken.

URL:
https://docs.google.com/spreadsheet/ccc?key=0AsoU647elPShdHlYc0RJbkEtZnVvTW11WE5NbHNiMXc&pli=1&gid=0&output=csv

You should be able to change this gid to return different tabs, but no matter what the value was it was always returning the first tab in visible order in the spreadsheet (which was the instructions, not the actual directory). As a workaround, I simply moved the directory tab to be the first tab in visible order, and the above URL seems to work again.

We should look at changing to the now available Google Sheets API, since this is likely a more stable way to export the data:
https://developers.google.com/google-apps/spreadsheets/