oAuth.gs

////oAuth related code

//hardcoded here for easily tweaking this. should move this to ScriptProperties or better parameterize them
//step 1. we can actually start directly here if that is necessary
var AUTHORIZE_URL = 'https://api.sandbox.freeagent.com/v2/approve_app'; 
//step 2. after we get the callback, go get token
var TOKEN_URL = 'https://api.sandbox.freeagent.com/v2/token_endpoint'; 

//PUT YOUR OWN SETTINGS HERE
var CLIENT_ID = 'LuiZTBSaJhAko6-yppszRA';
var CLIENT_SECRET='Mf909bkvX27gywIE1IIvfQ';
var REDIRECT_URL= ScriptApp.getService().getUrl();

//this is the user propety where we'll store the token, make sure this is unique across all user properties across all scripts
var tokenPropertyName = 'FREEAGENT_OAUTH_TOKEN6'; 
var baseURLPropertyName = 'FREEAGENT_INSTANCE_URL6';
var refreshTokenPropertyName = 'FREEAGENT_REFRESH_TOKEN6';

var apiurl = 'https://api.sandbox.freeagent.com/v2/';
var perpage = 100;  // max 100
var days = 30;

// Process specific contacts    
var processContactArray = ['LLR', 'Cool Earth'];

var emailArray = 
    {
      'Cool Earth' : "workatveda@gmail.com, mathavan@vedaconsulting.co.uk",
      'LLR'        : "gopi@vedaconsulting.co.uk, kajan@vedaconsulting.co.uk"     
    };
  

// Colorize ranges
minRed = 0;
maxRed = minBlue = 20;
maxBlue = minAmber = 30;
maxAmber = minGreen = 40;

//Title Row styling
titleRowHeight = 30;
titleHorizontalAlignment = "center";
titleVerticalAlignment = "middle";
titleFontSize   = 13;
titleFontFamily = "Times New Roman";
titleFontWeight = "bold";
titleFontColor  = "black";