Pulling Emails via API

[pfaffman (Jay Pfaffman)]

@Joe_F

seems this is not possible there unless I am missing something!

You could probably search here and find some examples or at ask.discourse.com, I asked

@pfaffman

I want to get a full list of users, their activity on the community and have their email using the data explorer plugin and then pull that result with the api

I’m unclear about who this link can work for:
https://ask.discourse.com/discourse-ai/ai-bot/shared-ai-conversations/oeofVCGwHrYuzKrtLV6PeQ

@DiscourseHelper

1. Create a Data Explorer Query

As an admin, create your query in /admin/plugins/explorer. For example, to fetch username, email, and activity information:

SELECT 
  u.id                AS user_id,
  u.username,
  u.email,
  u.created_at,
  u.last_seen_at,
  u.active,
  u.trust_level,
  (
    SELECT COUNT(*)
    FROM posts p
    WHERE p.user_id = u.id
  ) AS post_count,
  (
    SELECT COUNT(*)
    FROM topics t
    WHERE t.user_id = u.id
  ) AS topic_count
FROM users u
WHERE u.id > 0
ORDER BY u.created_at DESC

@DiscourseHelper

2. Run the Query via the API

• Find your query ID in the Data Explorer UI.
• Run your query using a POST request to /admin/plugins/explorer/queries/{query_id}/run.

Example cURL:

curl -X POST "https://your-site-url/admin/plugins/explorer/queries/{query_id}/run" \
  -H "Content-Type: application/json" \
  -H "Api-Key: YOUR_API_KEY" \
  -H "Api-Username: system" \
  -d '{"params":{}}'

• Results will be returned as JSON (default).
• To remove extra relations data, add -F "download=true" or equivalent.