zendesk-exporter.js

// Generated by CoffeeScript 2.2.1
var authHeaders, createCSV, creds, fs, getAllUsers, getUsers, rp, userAgent, writeUsersToFile;

fs = require('fs');

rp = require('request-promise');

creds = {
  "subdomain": process.env.ZENDESK_DOMAIN,
  "username": process.env.ZENDESK_USER,
  "token": process.env.ZENDESK_TOKEN
};

userAgent = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.102 Safari/537.36';

authHeaders = {
  'Authorization': 'Basic ' + new Buffer(`${creds.username}/token:${creds.token}`).toString('base64'),
  'user-agent': userAgent
};

// Get 100 Users at each request by default (maximum)
getUsers = function(options) {
  options = options || {};
  options.url = options.url || `https://${creds.subdomain}.zendesk.com/api/v2/users.json`;
  options.method = "GET";
  options.headers = authHeaders;
  options.json = true;
  console.log(`Requesting page: ${options.url}`);
  return rp(options);
};

getAllUsers = function() {
  var zendeskJSON;
  zendeskJSON = {};
  return new Promise(function(resolve, request) {
    // 1. Do a first request and get the count and store the first 100 entries
    return getUsers().then(function(res) {
      var remaining;
      
      // Store first 100 entries
      zendeskJSON = res;
      // 2. Find the number of remaining page numbers
      remaining = (res.count / 100) >> 0; // 1174 / 100
      if (res.count % 100 !== 0) {
        remaining++;
      }
      return remaining;
    }).then(function(remaining) {
      var i, num, ref, sequentialPromise;
      console.log(`Remaining Pages: ${remaining // 11
}`);
      
      // 3. Create a loop with the remaining number pages, decrementing at each step
      // "https://#{creds.subdomain}.zendesk.com/api/v2/users.json?page=2"
      sequentialPromise = Promise.resolve();
      for (num = i = 2, ref = remaining; undefined !== 0 && (2 <= ref ? 2 <= i && i <= ref : 2 >= i && i >= ref); num = 2 <= ref ? ++i : --i) {
        (function(num) {
          return sequentialPromise = sequentialPromise.then(() => {
            return getUsers({
              url: `https://${creds.subdomain}.zendesk.com/api/v2/users.json?page=${num}`
            }).then((res) => {
              console.log(`Number of users per entry: ${res.users.length}`);
              console.log(`Next Page: ${res.next_page}`);
              return zendeskJSON.users = zendeskJSON.users.concat(res.users);
            }).catch(console.log);
          });
        })(num);
      }
      return sequentialPromise.then(function(res) {});
    }).then(function(res) {
      console.log("Number of returned Entries: ", zendeskJSON.users.length);
      console.log("Writing JSON file...");
      return resolve(zendeskJSON);
    }).catch(console.log);
  });
};

// GET ALL USERS AND WRITE TO FILE
writeUsersToFile = function() {
  return getAllUsers().then(function(res) {
    return fs.writeFileSync('zendesk.json', JSON.stringify(res.users, null, '\t'), 'utf8');
  }).catch(console.log);
};

// WiP
createCSV = function() {
  var counter, zendeskUsers;
  zendeskUsers = fs.readFileSync('zendesk.json', 'utf8');
  zendeskUsers = JSON.parse(zendeskUsers);
  counter = 0;
  zendeskUsers.map(function(res) {
    console.log(counter, res.name, res.email);
    return counter++;
  });
  return console.log("Number of returned Entries: ", zendeskUsers.length);
};

// Usage: Get first 100 customers:
// getUsers().then(console.log).catch(console.log)

// Usage: Get all customers and write the data to a JSON file
writeUsersToFile();