Hello there, I’m trying to see if there’s a way to reverse-engineer getting a complete list of topics and views for each of those topics via the Discourse API. Ideally, something as simple as the landing page of a Discourse server with topic names and views in JSON format would be perfect, but from what I can tell from the API documentation there doesn’t seem to be an endpoint that can provide this high level overview. Is there such a way to get this data in a nice format that I could pipe through to an analytics dashboard API? Thanks in advance.

Would Data Explorer work? It’s possible to make SQL queries with Data Explorer and then get the results with the API.

[imagem] paigen11: Ideally, something as simple as the landing page of a Discourse server with topic names and views in JSON format would be perfect Would https://meta.discourse.org/latest.json be good enough? That includes topic titles, and view count. Docs can be found here. If you need more advanced filtering, then data explorer is also a good choice as @j127 mentioned :+1:

Thank you both for the suggestions - I’ll start checking out both of them this morning to see what might work. I appreciate it!

Hello, it seems like the best solution (if not using Data Explorer) is https://meta.discourse.org/latest.json. However one must loop through all the https://agora.les-cae.coop/latest.json?no_definitions=true&page={id} until no further data is found. By any chance, is there a way to get all the topics in a single request?

Obter a lista completa de tópicos e seus contagens de visualizações da API do Discourse

Dev

j127 30 Julho , 2021 04:22 2

O Data Explorer funcionaria? É possível fazer consultas SQL com o Data Explorer e depois obter os resultados via API.

Tópico		Respostas	Vistas
Api get all topics Development rest-api	3	1192	21 Outubro , 2021
Use API to get topics for a period using js Development rest-api	2	901	28 Fevereiro , 2023
Data Explorer :handshake: AI - Generate Data Explorer queries with AI Announcements data-explorer , ai	0	232	23 Julho , 2026
View total topics per category/sub category Product Support moderation	9	3206	18 Novembro , 2015
How do I get the json for the each raw from topics in the category? Development	8	2053	17 Abril , 2020

Obter a lista completa de tópicos e seus contagens de visualizações da API do Discourse

Related topics