Best API for All First Posts in a Category

[simonk (Simon King)]

Could you write a data-explorer query that returns the data that you want, and then execute that query via the API?

Discourse Data Explorer Plugin

Summary Discourse Data Explorer allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting. Repository Link https://github.com/discourse/discourse-data-explorer Install Guide How to install plugins in Discourse If you’re looking for examples or support for any custom queries, you can find lots of topics in our data & reporting category under the sql-query tag. If th…

Run Data Explorer queries with the Discourse API

Virtually any action that can be performed through the Discourse user interface can also be triggered with the Discourse API. For a general overview of how to find the correct API request for an action, see Reverse engineer the Discourse API. To run a Data Explorer query from the API, you need to make a POST request to /admin/plugins/explorer/queries/<query-id>/run. You can find the a Data Explorer query’s ID by visiting the query on your site and getting the value of the id parameter that yo…