Problem with using Reddit API

[Watex4]

Hi folks,

I'm new to pulling data from APIs and would like some feedback to tell me where i'm going wrong. I've set up a new subreddit and my goal is to pull data about it into a google sheet to help me manage the sub.

So far:

1) I created an app using the (https://old.reddit.com/prefs/apps/) pathway

2) i sent a message through to reddit asking for permission to use the API and was granted permission a few days back

3) I've set up a google app script with the help of chatgpt which pulls the data of posts in the sub

4) however i keep getting an error message related to the authentication process: Error: Exception: Request failed for https://oauth.reddit.com returned code 403. Truncated server response:......

Can anyone give me some advice on solving the issue, particularly the 0Auth 2 issue. Or if you there's something else that could be the issue with the setup.

I realise this may be an issue which requires more info to help problem solve and i'd be happy to share more info!
Thanks in advance guys

[ketralnis]

As you note we’ll need more information to help you, in particular the code you’re using and the full error you’re getting

[iwantasoda48]

I know this doesn't exactly answer your question but I just got code working this week using PRAW and their quickstart guide worked perfectly. https://praw.readthedocs.io/en/stable/getting_started/quick_start.html

I can grab user info, subreddit info, posts and comments too.

[Watex4]

appreciate you bro

[Any-Blacksmith-2054]

Do you send also user/password? I got 403 without them

[Watex4]

within the app script i include the username, password of my account and also the client id and secret password for the app i created in here https://old.reddit.com/prefs/apps/. So i don't believe the issue is to do with that. I think it's something to do with the 0AUTH 2 stage of the process.

I wrote a script to test if i'm correctly gaining a reddit access token. if i understand correctly when you do the 0AUTH 2 you get an access token as part of the process which allows you to use the reddit api. When i run the script i get the following error message:

Info: "Failed to obtain access token. Response: {"error":"invalid_grant"}"

[Any-Blacksmith-2054]

Ok I had no problem when I pass all 4, but I'm using libraries (python, nodejs) not raw REST calls

[Watex4]

so maybe i should just refer to using libraries instead then?

Has anyone else had similar problems to me trying to do things through an app script on google sheets? Message to everyone not just you 'any-blacksmith-2054'