Google Sheets Function for fetching Accounts and their current values

up-accounts-usage.md

Up Accounts API

1. Create a new Sheet (or use an existing one)
2. Tools -> Script Editor
3. Copy + Paste the attached .js code snippet (Save)
4. Back on the sheet, paste in =FetchAccounts("up:yeah:THE_REST_OF_YOUR_TOKEN_HERE", 0)
5. Profit

Don't have an API token, get one here.

Still stuck? Check out the Up Bank API Developer Docs

up-accounts.js

function FetchAccounts(token, placeholder) {
  const url = "api.up.com.au/api/v1/accounts"
  const params = {
    'headers': {
      'authorization': 'Bearer ' + token,
    }
  }
  
  const response = UrlFetchApp.fetch(url, params);
      
  const data = JSON.parse(response.getContentText()).data
  
  const result = data.map(function(obj){
    return [obj.attributes.displayName, obj.attributes.balance.valueInBaseUnits / 100]
  })
  
  return result;
}