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.

[image] 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:

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?

Get total list of topics and their view counts from Discourse API

Development

paigen11 (Paige N) July 30, 2021, 1:14pm 4

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

Topic		Replies	Views
Api get all topics Development rest-api	3	1198	October 21, 2021
Use API to get topics for a period using js Development rest-api	2	907	February 28, 2023
Data Explorer :handshake: AI - Generate Data Explorer queries with AI Announcements data-explorer , ai	0	242	July 23, 2026
View total topics per category/sub category Product Support moderation	9	3214	November 18, 2015
How do I get the json for the each raw from topics in the category? Development	8	2083	April 17, 2020

Get total list of topics and their view counts from Discourse API

Related topics