# Can we utilize data explorer query to extract details via API?

**URL:** <https://community.dynatrace.com/t/can-we-utilize-data-explorer-query-to-extract-details-via-api/41043>\
**Category:** Open Q&A\
**Tags:** apdex, dynatrace-managed, data-explorer, dynatrace-api\
**Created:** [August 4, 2023, 10:29am UTC](https://community.dynatrace.com/t/can-we-utilize-data-explorer-query-to-extract-details-via-api/41043 "2023-08-04T10:29:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![AK](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/ak/32/164_2.png) [@AK](https://community.dynatrace.com/u/AK)\
**Post date:** [August 4, 2023, 10:29am UTC](https://community.dynatrace.com/t/can-we-utilize-data-explorer-query-to-extract-details-via-api/41043/1 "2023-08-04T10:29:08Z")

</div>

Hello Folks,

I wanted to extract Apdex split by geolocation and application via API.

I have data explorer query with which I can see following details, the same details I want via API.

 ![AK_0-1691144448005.png](https://global.discourse-cdn.com/dynatrace/original/3X/c/f/cf90c378568922a8d4bff5e14191e0bb40b0478d.png)

In short, how can we use data explorer query to extract the same details via API?

```markup
builtin:apps.web.apdex.userType.geoBig:filter(and(or(in("dt.entity.geolocation",entitySelector("type(geolocation),entityName.contains(~"dummydata~")"))))):filter (ne("dt.entity.geolocation","GEOLOCATION-1234567891011")):splitBy("dt.entity.geolocation","dt.entity.application"):sort(value(auto,descending))

```

Regards,

AK

---

<div class="post-metadata">

**Author:** ![AntonPineiro](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antonpineiro/32/49_2.png) [@AntonPineiro](https://community.dynatrace.com/u/AntonPineiro)\
**Post date:** [August 4, 2023, 11:28am UTC](https://community.dynatrace.com/t/can-we-utilize-data-explorer-query-to-extract-details-via-api/41043/2 "2023-08-04T11:28:39Z")

</div>

Hi,

You have a direct link to [copy request](https://www.dynatrace.com/support/help/shortlink/explorer#api).

 ![AntonPineiro_0-1691148509950.png](https://global.discourse-cdn.com/dynatrace/original/3X/7/9/79b8e00349eacba4891f91b95f08859bf86eff91.png)

Best regards

---

<div class="post-metadata">

**Author:** ![AK](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/ak/32/164_2.png) [@AK](https://community.dynatrace.com/u/AK)\
**Post date:** [August 4, 2023, 3:30pm UTC](https://community.dynatrace.com/t/can-we-utilize-data-explorer-query-to-extract-details-via-api/41043/3 "2023-08-04T15:30:39Z")

</div>

[@AntonPineiro](https://community.dynatrace.com/user/58682), Thanks for the quick response. That really helped.
