We want to get all of the first posts in a category (which we are using as wikis but not actually wikis). Preferably, we’d like to avoid having to do one request per topic/post. The best way have so far is using search to get topics, and then get the topics one by one and take the first post out o…

Bumping this to see if anyone had an idea?

[image] John_Lehmann: Preferably, we’d like to avoid having to do one request per topic/post. The best way have so far is using search to get topics, and then get the topics one by one and take the first post out of the stream. I’m not aware of a bulk way of getting the first replies to many…

Could you write a data-explorer query that returns the data that you want, and then execute that query via the API? [image] Discourse Data Explorer Plugin discourse2 Summary Discourse Data Explorer allows you to make SQL queries against your live databas…

@blake [image] I don’t suppose the topic event would include changes to the OP?

[image] John_Lehmann: topic event would include changes to the OP It should trigger for changes. The description for it says: When there is a new topic, revised, changed, or deleted. [image] simonk: Could you write a data-explorer query that returns the data that you want, and then ex…

Hi everyone, I’m developing a mobile application that integrates with our self-hosted Discourse instance. I need to retrieve all first posts from topics within a specific category, similar to the use case discussed here. While the current approach involves fetching topics and then retrieving eac…

Best API for All First Posts in a Category

Development

blake (Blake Erickson) April 24, 2025, 6:24pm 8

I think the data explorer query route mentioned above would be worth trying out. This way you could make one request per category.

Topic		Replies	Views
How do I get the json for the each raw from topics in the category? Development	8	1834	April 17, 2020
How to get all posts from Discourse (Any API available?) Development	1	844	April 15, 2021
What would be the best way to display the last topics excerpts and categories via the API? Support	1	876	January 1, 2018
Get only top level posts in topic via discourse API Development rest-api	4	2350	March 17, 2022
What's a Post? (Discourse API question) Development	7	1007	August 24, 2021

Best API for All First Posts in a Category

Related topics