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 of the stream. Web hooks will be a good option in the future but we’d like to start with PULL. thanks!

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 topics. Iterating through each topic and grabbing the first post is probably the best option. [image] John_Lehmann: Web hooks will be a good option in the future but we’d like to start with PULL. Yes, webhooks really are a good option here and you can trigger off the “Post Event”. [image] But this would trigger for EVERY post event and you’d just have to ignore all the posts that aren’t the first reply on a topic.

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 database, allowing for up-to-the-minute stats reporting. open_book Install Guide This plugin is bundled with Discourse core. There is no need to install the plugin separately. information_source 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 there’s not one to suit your par… [image] Run Data Explorer queries with the Discourse API Integrations bookmark This guide explains how to use the Discourse API to create, run, and manage queries with the Data Explorer plugin. person_raising_hand Required user level: Administrator Virtually any action that can be performed through the Discourse user interface can also be triggered with the Discourse API. This document provides a comprehensive overview for utilizing the API specifically in conjunction with the Data Explorer plugin. For a general overview of how to find the correct API …

@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 execute that query via the API? Yes, that is great option! :slight_smile:

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 each first post individually, I’m looking for a more efficient method suitable for mobile applications. Ideally, this would minimize the number of API calls to conserve bandwidth and improve performance. Has anyone implemented a similar solution or can offer guidance on the most efficient way to achieve this? Any insights or suggestions would be greatly appreciated!

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

Meilleure API pour tous les premiers messages dans une catégorie

Dev

simonk (Simon King) Octobre 4, 2021, 3:43 4

Pourriez-vous écrire une requête data-explorer qui renvoie les données souhaitées, puis exécuter cette requête via l’API ?

Sujet		Réponses	Vues
How do I get the json for the each raw from topics in the category? Development	8	2077	Avril 17, 2020
How to get all posts from Discourse (Any API available?) Development	1	899	Avril 15, 2021
What would be the best way to display the last topics excerpts and categories via the API? Product Support	1	915	Janvier 1, 2018
Get only top level posts in topic via discourse API Development rest-api	4	2454	Mars 17, 2022
What's a Post? (Discourse API question) Development	7	1144	Août 24, 2021

Meilleure API pour tous les premiers messages dans une catégorie

Sujets connexes