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

[imagem] 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 [imagem]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!

Puxando E-mails via API

Suporte ao Produto

Joe_F (Joe Farrar) 2 Setembro , 2025 13:47 7

Resolvido, obrigado!

Você foi incrível!

Tópico		Respostas	Vistas
Return emails with list of user from API Development	1	863	22 Abril , 2016
API Filter users by emails, including secondary emails Development rest-api	2	483	29 Fevereiro , 2024
Run Data Explorer queries with the Discourse API Integrations data-explorer , rest-api , how-to	14	14369	6 Maio , 2025
Create a Data Explorer query using the API Integrations data-explorer , rest-api , how-to	3	312	29 Março , 2026
Discourse Data Explorer Plugin official , data-explorer , included-in-core	30	87223	22 Outubro , 2025

Puxando E-mails via API

Related topics