# Get user apdex value via API

**URL:** <https://community.dynatrace.com/t/get-user-apdex-value-via-api/19368>\
**Category:** Dashboarding\
**Tags:** user-actions, user-sessions, dashboards-classic, dynatrace-api\
**Created:** [January 31, 2019, 11:59am UTC](https://community.dynatrace.com/t/get-user-apdex-value-via-api/19368 "2019-01-31T11:59:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![pablo\_sanchez](https://avatars.discourse-cdn.com/v4/letter/p/f07891/32.png) [@pablo\_sanchez](https://community.dynatrace.com/u/pablo_sanchez)\
**Post date:** [January 31, 2019, 11:59am UTC](https://community.dynatrace.com/t/get-user-apdex-value-via-api/19368/1 "2019-01-31T11:59:21Z")

</div>

Hi.

Because Dynatrace doesn’t offer the possibility to focus on the performance of specific regions in dashboarding tiles, we are trying to extract user experience data via API to make a custom dashboard externally. We are trying to extract the apdex value in the usersessions (or useractions, because it seems to be the only object which has it) via API, but we aren’t having any luck. we are trying something like this just to see if we can see this data:

https://(tenant).dynatrace.com/api/v1/userSessionQueryLanguage/table?api-token=(token)&query=SELECT \* FROM usersession

Which i got from here: [https://www.dynatrace.com/support/help/dynatrace-a…](https://www.dynatrace.com/support/help/dynatrace-api/environment/user-session-api/)

is there something i’m doing wrong?

Thank you. Kind Regards.

---

<div class="post-metadata">

**Author:** ![AlexanderSommer](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/alexandersommer/32/2501_2.png) [@AlexanderSommer](https://community.dynatrace.com/u/AlexanderSommer)\
**Post date:** [February 11, 2019, 2:48pm UTC](https://community.dynatrace.com/t/get-user-apdex-value-via-api/19368/2 "2019-02-11T14:48:05Z")

</div>

Sorry, for the late replay. Yes you can use the Rest API to do things like:

_select apdexCategory, count(\*) FROM useraction where usersession.userType = ‘REAL\_USER’ GROUP BY apdexCategory_

You can navigate to the Explore Dynatrace API view and play around within the UI for tuning your statements. Please make sure to create first an access token.