xero-api-apps-script

Integrating Xero.com REST API with Google Apps Script

How to use this Script

1. Create a new Google Spreadsheet.
2. From Spreadsheet menu go to Tools >> Script Editor.
3. In the Script, copy and add following files. Add new script file for each of the following: a) rsa/jsbn.gs b) rsa/jsbn2.gs c) rsa/rsa.gs d) rsa/rsa2.gs e) rsa/base64.gs f) rsa/crypto-comp-core.gs g) rsa/crypto-comp-sha1.gs h) rsa/rsapem-1.1.gs i) rsa/rsasign-1.2.gs j) rsa/asn1hex-1.1.gs k) rsa/x509-1.1.gs l) rsa/crypto-1.1.gs m) Xero.gs
4. Add code in Code.gs to existing Code.gs file.
5. Refresh spreadsheet.
6. From Custom menu XERO go to Xero Settings. Add details for Private App.
7. We have only tested this script with Private App and "Manual Download Invoices".