document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. /**
  2.  * ClicData Auth flow
  3.  * @see https://app.clicdata.com/help/apidocumentation/api-getting-started
  4.  * Using library: https://github.com/gsuitedevs/apps-script-oauth2
  5.  * Resources > Libraries > Find a Library -> Enter: 1B7FSrk5Zi6L1rSxxTDgDEUsPzlukDsi4KGuTMorsTQHhGBzBkMun4iDF
  6.  */
  7. ​
  8. function run() {
  9.     /**
  10.      * Authorizes and makes a request to the ClicData API.
  11.      */
  12. ​
  13.     // Complete all pending spreadsheet actions before adding responseURLs
  14.     SpreadsheetApp.flush();
  15. ​
  16.     // Base Server Address
  17.     var SERVER = \'https://api.clicdata.com/\';
  18. ​
  19.     //Schedule RecId\'s
  20.     var SCHEDULE_ID = \'RecId\';
  21. ​
  22.     // Data Set RecId\'s
  23.     var DATA_ID = \'RecId\';
  24. ​
  25.     // Task Options
  26.     var DATAREFRESH = \'/data/\' + DATA_ID + \'/reload\';
  27.     var RUNSCHEDULE = \'/schedule/\' + SCHEDULE_ID + \'/trigger\';
  28. ​
  29.     var serviceProject = getService();
  30.     Logger.log(serviceProject.hasAccess());
  31.     if (serviceProject.hasAccess()) {
  32.         var url = SERVER + DATAREFRESH; // Replace to POST different commands (see Task Options above)
  33.         Logger.log(serviceProject.getAccessToken());
  34. ​
  35.         // Try to load, if task is already running, wait, then try again
  36.         var runCheck = false // Set runCheck to false to initialize loop
  37.             restartloop: while (runCheck === false) {
  38.                 try {
  39.                     var response = UrlFetchApp.fetch(url, {
  40.                             "method": "POST", // Change method to GET, POST, DELETE or PUT
  41.                             headers: {
  42.                                 Authorization: \'Bearer \' + service.getAccessToken()
  43.                             }
  44.                         });
  45.                     runCheck = true // Stop looping
  46.                 } catch (e) {
  47.                     if (e.message.indexOf(\'data is already being processed or is queued for processing\') > -1) {
  48.                         Utilities.sleep(4000); // pause between refreshes for 4 second (trying to fix error code 400)
  49.                         continue restartloop;
  50.                     } else {
  51.                         // Logs an ERROR message.
  52.                         console.error(\'UrlFetchApp yielded an error: \' + e);
  53.                         return; // Exits function and loop
  54.                         break;
  55.                     }
  56.                 }
  57.             }
  58.             Logger.log(\'Success, data set \' + DATA_ID + \' has been reloaded.\') // Log Success!
  59.     } else {
  60.         Logger.log(service.getLastError());
  61.         // If Refresh Token has expired, reset authorization state then run authorization again (only required on first getService() call
  62.         reset();
  63.         run();
  64. ​
  65.     }
  66. ​
  67. }
  68. ​
  69. function reset() {
  70.     /**
  71.      * Reset the authorization state.
  72.      */
  73. ​
  74.     getService().reset();
  75. }
  76. ​
  77. function getService() {
  78.     /**
  79.      * Configures the service.
  80.      */
  81. ​
  82.     //Client_Credentials id and secret, obtain from ClicData Account settings
  83.     var CLIENT_ID = \'id\';
  84.     var CLIENT_SECRET = \'secret\';
  85. ​
  86.     return OAuth2.createService(\'ClicDataAdmin\')
  87.     // Set the endpoint URLs.
  88.     .setTokenUrl(\'https://api.clicdata.com/oauth20/token\')
  89. ​
  90.     // Set the client ID and secret.
  91.     .setClientId(CLIENT_ID)
  92.     .setClientSecret(CLIENT_SECRET)
  93. ​
  94.     // Sets the custom grant type to use.
  95.     .setGrantType(\'client_credentials\')
  96. ​
  97.     // Set the property store where authorized tokens should be persisted.
  98.     .setPropertyStore(PropertiesService.getUserProperties());
  99. }
');