Hi all, I have set up a pipeline that pulls in all user information but the option to pull in their email is not available. I have an admin role and the API key, etc, can I set this up, if so how? I want to add this column in a table for all users not a one off user query. Kind regards, Joe

[图片] 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 [图片]On another topic 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 On another topic 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 On another topic 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.

Interestingly, something like /admin/users/{id}.json doesn’t return the user’s email as part of the response, but getting a list of users (/admin/users/list/{flag}.json) does. If you pass a parameter like username, you can probably get the specific user.

I want to get a full list of users, their activity on the community and have their email also, it seems it is not an option though.

The data explorer plugin is probably the way to do that. And then you can request a particular query via the API.

Thanks, I had not seen this before, but seems this is not possible there unless I am missing something!

Solved it thanks! You have been amazing!

通过 API 拉取电子邮件

产品支持

Joe_F (Joe Farrar) 2025 年9 月 2 日 13:47 7

解决了，谢谢！

你太棒了！

话题		回复	浏览量
Return emails with list of user from API Development	1	864	2016 年4 月 22 日
API Filter users by emails, including secondary emails Development rest-api	2	488	2024 年2 月 29 日
Run Data Explorer queries with the Discourse API Integrations data-explorer , rest-api , how-to	14	14423	2025 年5 月 6 日
Create a Data Explorer query using the API Integrations data-explorer , rest-api , how-to	3	335	2026 年3 月 29 日
Discourse Data Explorer Plugin official , data-explorer , included-in-core	30	87525	2025 年10 月 22 日

通过 API 拉取电子邮件

相关话题