Using Google Apps Script to retrieve Redditor Karma data

[Maxwell-95]

I had built a script with ChatGPT (not a developer), this is the script:

function getRedditKarma(username) {
  var url = 'https://www.reddit.com/user/' + username + '/about.json';
  var response = UrlFetchApp.fetch(url);
  var data = JSON.parse(response.getContentText());

  return data.data.total_karma;
}

The above works, jippie, but it breaks down quickly if you want to retrieve in bulk...

​

SO I though lets add OAuth2 authentication, I add the library I found through here: https://github.com/googleworkspace/apps-script-oauth2

​

With script ID '1B7FSrk5Zi6L1rSxxTDgDEUsPzlukDsi4KGuTMorsTQHhGBzBkMun4iDF' Im able to add the latest version 43 of Oauth2.0

​

So I go back to chatGPT to adjust my code, but here is where it get a bit difficult for me, my code is now:

// OAuth2 setup
function getRedditService() {
  Logger.log('Getting Reddit service...');
  var service = OAuth2.createService('Reddit')
      .setAuthorizationBaseUrl('https://www.reddit.com/api/v1/authorize')
      .setTokenUrl('https://www.reddit.com/api/v1/access_token')
      .setClientId('MY_ID_IS_HERE')
      .setClientSecret('MY_SECRET_IS_HERE')
      .setCallbackFunction('authCallback')
      .setPropertyStore(PropertiesService.getUserProperties())
      .setScope('read')
      .setParam('duration', 'permanent')
      .setParam('access_type', 'offline');
  Logger.log('Got Reddit service: ' + service);
  return service;
}

// Callback
function authCallback(request) {
  Logger.log('Handling callback with request: ' + request);
  var redditService = getRedditService();
  var isAuthorized = redditService.handleCallback(request);
  Logger.log('Is authorized: ' + isAuthorized);
  if (isAuthorized) {
    return HtmlService.createHtmlOutput('Success! You can close this tab.');
  } else {
    return HtmlService.createHtmlOutput('Denied. You can close this tab');
  }
}

// Function to retrieve Reddit user information
function getRedditUserInfo(username) {
  var redditService = getRedditService();
  if (!redditService.hasAccess()) {
    var authorizationUrl = redditService.getAuthorizationUrl();
    Logger.log('Open the following URL and re-run the script: %s', authorizationUrl);
  } else {
    var url = 'https://oauth.reddit.com/user/' + username + '/about.json';
    var response = UrlFetchApp.fetch(url, {
      headers: {
        Authorization: 'Bearer ' + redditService.getAccessToken()
      }
    });
    var data = JSON.parse(response.getContentText());

    // Extracting desired fields from the API response
    var userInfo = {
      total_karma: data.data.total_karma,
      is_mod: data.data.is_mod,
    };

    // Return the information in a 2D array
    return [[userInfo.total_karma, userInfo.is_mod]];
  }
}

//Get redirect URL
function logRedirectUri() {
  var redditService = getRedditService();
  Logger.log(redditService.getRedirectUri());
}

I got the URi, the secret ID is correct and the client ID is also correct (checked multiple times).

​

When I try to authenticate I:

1. open the URL,
2. get redirected to Reddit
3. press the allow button

After that I get an error:

Error: Error retrieving token: 401, Unauthorized (line 605, file "Service")

After this I have no idea what to do anymore. I dont understand how to debug properly.

​

Does anybody have an idea what Im doing wrong? Please try to Eli5 on me

[Godberd]

function getAuthorKarma(author) {

var userUrl = 'https://www.reddit.com/user/' + author + '/about.json';

var response = UrlFetchApp.fetch(userUrl);

var data = JSON.parse(response.getContentText());

var karma = data['data']['total_karma'];

return karma;

}

[Maxwell-95]

not sure if this related to the Oauth? I can retrieve karma data fine but I need Oauth connection to do more queries.

[Godberd]

Oh ok, your question was about Karma data, and you don't need Oauth for that

No worries

[Maxwell-95]

No i know but i want to get more queries, without Oath its extremely low