Hi everyone! For the company I work in, we are extracting the topics created throughout all the Discourse’s forum of the company by doing requests to the url of each category (for example like:https://{organization_url}/c/{c}/{category_slug}/{subcategory_slug}/206.json) . We need to count the number of topics created per category per each date but when we compare the results per date obtained through the API vs searching the topics in discourse, we find that for some categories/subcategories they do not completely match. For example, for a particular date (such as 2022-07-01) the API returns 3 topics, while by searching in discourse for the same date we get 4 topics and what is weird is that one of the topics is actually from one day before (2022-06-30). Apart from that, that topic from 2022-06-30 is not returned by the API (shows no topics created that date) and if I search in discourse for topics created on 2022-06-30, there are no matches. I’m doing the search using the filters: in:first after:2022-07-01 before:2022-07-02 in the search bar. What can be done in that case? or is that any kind of bug in the API/search bar feature? (sorry, I cannot upload any images to show any result due to confidentiality issues. Hope that at least the explanation was clear).

Hi Jay, thanks for your answer. I’m not sure if that’s about the time zones (it will only explain why the topic created on 2022-06-30 appears in the web UI under the same date of the topics created on 2022-07-01) because the API doesn’t show the topic published on 2022-06-30. I was able to get this image and you can see that in the search bar we were searching for posts between 2022-07-01 and 2022-07-02, three of them were actually created between that time range but the last one has date of 2022-06-30. That last post (the one from 2022-06-30) is the one that is not retrieved through the API. [Screen Shot 2022-08-15 at 09.54.33] On the other hand, for other dates, there are some posts that appear in the API but not in the web UI. Thank you!

Hmm. I’m confused enough by my own time zones. :slight_smile: There was some work on this interface recently, I think. I can’t imagine, though, how how the front end and the API would give different results since they’re using the same API. :person_shrugging: Maybe your image will be enough for someone who understands that code to figure something out.

Jay, is it there any way that we can tag a developer so that person can take a look to this issue or what can we done in our side? Thank you!

Unless you’re a paying customer you can’t really tag anyone for attention. If you were a paying customer you would have other avenues for support. The team is very active here though, if someone has an answer they will respond without prompting.

Topics extracted from API do not appear in discourse forums or vice versa

Development

pfaffman (Jay Pfaffman) August 14, 2022, 12:32am 2

My guess is that it has to do with time zones.

Topic		Replies	Views
Some inconsistencies in search results Product Support	5	718	June 5, 2019
Use API to get topics for a period using js Development rest-api	2	903	February 28, 2023
How to retrieve all topics of a category Development rest-api	6	1060	December 6, 2023
Topics created_since API Product Support	2	569	February 25, 2019
Discourses API get just the number of search results Development rest-api	8	3351	October 20, 2019

Topics extracted from API do not appear in discourse forums or vice versa

Related topics