# How can I use PMM APIs to get data from query analytics dashboard

**URL:** <https://forums.percona.com/t/how-can-i-use-pmm-apis-to-get-data-from-query-analytics-dashboard/29197>\
**Category:** PMM 2.x\
**Tags:** mysql, postgres\
**Created:** [March 18, 2024, 11:34am UTC](https://forums.percona.com/t/how-can-i-use-pmm-apis-to-get-data-from-query-analytics-dashboard/29197 "2024-03-18T11:34:53Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Magdy\_Hafez](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/magdy_hafez/32/15686_2.png) [@Magdy\_Hafez](https://forums.percona.com/u/Magdy_Hafez)\
**Post date:** [March 18, 2024, 11:34am UTC](https://forums.percona.com/t/how-can-i-use-pmm-apis-to-get-data-from-query-analytics-dashboard/29197/1 "2024-03-18T11:34:53Z")

</div>

Hi All,  
I would like to know if there is an API exposed by PMM to get the queries found on the query analytics dashboard.

I want to be able to see all queries ran on my RDS instanceas so that I can analyze any unusual queries

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [March 18, 2024, 3:08pm UTC](https://forums.percona.com/t/how-can-i-use-pmm-apis-to-get-data-from-query-analytics-dashboard/29197/2 "2024-03-18T15:08:12Z")

</div>

[https://pmmdemo.percona.com/swagger](https://pmmdemo.percona.com/swagger)

I don’t see anything that could be used to get QAN data.

---

<div class="post-metadata">

**Author:** ![nurlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nurlan/32/1523_2.png) [@nurlan](https://forums.percona.com/u/nurlan)\
**Post date:** [March 19, 2024, 9:24am UTC](https://forums.percona.com/t/how-can-i-use-pmm-apis-to-get-data-from-query-analytics-dashboard/29197/3 "2024-03-19T09:24:24Z")

</div>

you can replace swagger.json at the top by swagger-dev.json and all non-GAed endpoints will be visible there. `/v0/qan/` endpoints are the ones that you are looking for.

---

<div class="post-metadata">

**Author:** ![Magdy\_Hafez](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/magdy_hafez/32/15686_2.png) [@Magdy\_Hafez](https://forums.percona.com/u/Magdy_Hafez)\
**Post date:** [March 19, 2024, 9:34am UTC](https://forums.percona.com/t/how-can-i-use-pmm-apis-to-get-data-from-query-analytics-dashboard/29197/4 "2024-03-19T09:34:48Z")

</div>

Thanks @matthewb and @nurlan

@nurlan These APIs are non-GAed but they can be used , right ?

---

<div class="post-metadata">

**Author:** ![nurlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nurlan/32/1523_2.png) [@nurlan](https://forums.percona.com/u/nurlan)\
**Post date:** [March 19, 2024, 9:59am UTC](https://forums.percona.com/t/how-can-i-use-pmm-apis-to-get-data-from-query-analytics-dashboard/29197/5 "2024-03-19T09:59:18Z")

</div>

Yes, they can be used.

---

<div class="post-metadata">

**Author:** ![Magdy\_Hafez](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/magdy_hafez/32/15686_2.png) [@Magdy\_Hafez](https://forums.percona.com/u/Magdy_Hafez)\
**Post date:** [March 19, 2024, 11:05am UTC](https://forums.percona.com/t/how-can-i-use-pmm-apis-to-get-data-from-query-analytics-dashboard/29197/6 "2024-03-19T11:05:01Z")

</div>

@nurlan Thank you for you support