Reddit

Reddit is a social media and community discussion platform that enables users to participate in forums called subreddits, share content, post links and text, comment on discussions, and engage with communities around specific topics and interests. This data integration platform provides access to Reddit user account data, content management information, moderation capabilities, and community participation metrics.

Category	Other
Direction	Query source
Sign-in	Reddit OAuth2 (Script App)
Query languages	SQLite
Tables	16
Query templates	32
Website	reddit.com

Before you start

Huntbase signs in to Reddit with Reddit OAuth2 (Script App). Create the credential in Reddit first, then keep it to hand for the Connect step.

1. Sign in to Reddit, go to your app preferences at https://www.reddit.com/prefs/apps, and click Create app (or Create another app).
2. Enter a name and choose the script option as the app type.
3. For the redirect URI, enter a placeholder such as http://www.example.com/unused/redirect/uri. It isn't used.
4. Submit the form and note the app's client ID and client secret.

For the vendor's own instructions, see Reddit OAuth2 quick start.

tip

Use a dedicated, read-only credential for Huntbase where the product allows it. Huntbase only needs to read.

Connect Reddit

1. Go to Connections and click New connection, or click New connection on the Reddit product page.
2. On Product, pick Reddit and choose the Owner.
3. On Details, give the connection a Name and, optionally, a Description.
4. On Connect, fill in the settings and credentials described below.
5. On Verify, review the summary and click Create & check.

For everything else on the setup page — saving a draft, I'll do this later, and what each check result means — see Connections.

Credentials

The only Method is Reddit OAuth2 (Script App). Enter a Credential label (for example Production), then fill in:

Field	Required	Notes
Client ID	Yes	Secret — not shown again after you save it.
Client Secret	Yes	Secret — not shown again after you save it.
Username	Yes	Your Reddit username. Secret — not shown again after you save it.
Password	Yes	Your Reddit password. Secret — not shown again after you save it.

Query it

Once connected, Reddit can serve these languages in a query tab, and Scout can use it when you ask in Auto:

Language	Use it for
SQLite	SQL over the 16 tables listed below, alongside every other connected source.

Example: SQLite

Get current Reddit account info — Retrieve information about the currently authenticated Reddit account.

select
  *
from
  reddit_my_info;

Reddit ships with 32 query templates. Find them in Library › Queries — see Query templates.

Tables

Reddit adds 16 tables. Browse their columns from Schema in the query bar's ⋯ menu.

All 16 tables

Table	Contains
reddit_my_blocked	Users blocked by the user account making the call.
reddit_my_comment	Your comments.
reddit_my_friend	Friends of the user account making the call.
reddit_my_info	Information about the user making the query.
reddit_my_moderated_subreddit	Subreddits you are a moderator of.
reddit_my_post	Your posts.
reddit_my_saved_comment	Your saved comments.
reddit_my_saved_post	Your saved posts.
reddit_my_subscribed_subreddit	Subreddits you are subscribed to.
reddit_popular_subreddit	Popular subreddits.
reddit_subreddit_banned	Users banned from the subreddit.
reddit_subreddit_moderator	Moderators of the subreddit.
reddit_subreddit_post_search	Search posts in a subreddit.
reddit_subreddit_search	Search subreddits.
reddit_user	Information about a user.
reddit_user_search	Search Reddit users.

Next steps

• Connections — health, credentials and settings after you connect
• Query languages — syntax, parameters and time ranges
• Chatting with Scout — ask questions without writing a query
• All integrations — the rest of the catalog