# Get total list of topics and their view counts from Discourse API

**URL:** https://meta.discourse.org/t/get-total-list-of-topics-and-their-view-counts-from-discourse-api/198596
**Category:** Development
**Created:** [July 29, 2021, 6:23pm UTC](https://meta.discourse.org/t/get-total-list-of-topics-and-their-view-counts-from-discourse-api/198596 "2021-07-29T18:23:19Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![j127](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/j127/32/79093_2.png) [@j127](https://meta.discourse.org/u/j127)
#### Post date: [July 30, 2021, 4:22am UTC](https://meta.discourse.org/t/get-total-list-of-topics-and-their-view-counts-from-discourse-api/198596/2 "2021-07-30T04:22:31Z")

</div>

Would [Data Explorer](https://meta.discourse.org/t/data-explorer-plugin/32566) work? It’s possible to make SQL queries with [Data Explorer](https://meta.discourse.org/t/32566?silent=true) and then [get the results with the API](https://meta.discourse.org/t/how-to-run-data-explorer-queries-with-the-discourse-api/120063).

---

_[View the full topic](https://meta.discourse.org/t/get-total-list-of-topics-and-their-view-counts-from-discourse-api/198596)._