Discourse Connector - Fetch Data Explorer queries with Discourse API

[JoseAnaya28]

For the data we need for comms we need to be able to retrieve the data using data explorer queries according to this: https://meta.discourse.org/t/run-data-explorer-queries-with-the-discourse-api/120063

The goal is ideally to replicate the exact same dashboard as shown here:

[JoseAnaya28]

Identified tables:

• post_actions
• posts
• topics
• users
• user_actions
• user_visits
• topic_views
• poll_votes
• polls
• poll_options
• uploads
• upload_references
• topic_users
• groups
• group_users
• assignments
• user_emails
• categories
• topic_tags
• tags

[apentori]

Posts

• post_actions: ?
• posts : already fetch by the connector : https://docs.discourse.org/#tag/Posts/operation/listPosts

Topics

• topics: https://docs.discourse.org/#tag/Topics/operation/listLatestTopics, objects topic_list.topics
• topic_views: The objects topics from https://docs.discourse.org/#tag/Topics/operation/listLatestTopics give the view per topic, is that enough ?
• topic_users : https://docs.discourse.org/#tag/Topics/operation/listLatestTopics, objects topic_list.topics.posters or users ? (the docs doensn't give much info, will start with posters, if that doesnt work, i will add another call to get the value of users lists
• topic_tags: https://docs.discourse.org/#tag/Categories/operation/listCategoryTopics object topic_list.top_tags ?

Users

• users: we currently fetch all the active users: https://docs.discourse.org/#tag/Posts/operation/listPosts, can also add support for this list of users type : active, new, staff, suspended, blocked,suspect.we could get more info of each users with https://docs.discourse.org/#tag/Users/operation/adminGetUser
• user_actions: possible to add https://docs.discourse.org/#tag/Posts/operation/listPosts
• user_visits: Except the field days_visited in the user objecti have no idea how to get it.
• user_emails: present the user objects

Polls

• poll_votes ?
• polls ?
• poll_options ?

Upload

• uploads : ?
• upload_references : ?

Groups

• groups ; https://docs.discourse.org/#tag/Groups/operation/listGroups
• group_users : https://docs.discourse.org/#tag/Groups/operation/listGroupMembers

Miscs

• assignments : ?
• categories : https://docs.discourse.org/#tag/Categories/operation/listCategories
• tags : https://docs.discourse.org/#tag/Tags/operation/listTags

[JoseAnaya28]

topic_views: The objects topics from https://docs.discourse.org/#tag/Topics/operation/listLatestTopics give the view per topic, is that enough ?

Yes, that should be enough

• pageviews: We can get these from the table application_requests. Needed but I don't see it in API
• user_visits will be needed