# Dynatrace Business Events Extractions of Json Array

**URL:** <https://community.dynatrace.com/t/dynatrace-business-events-extractions-of-json-array/38977>\
**Category:** Open Q&A\
**Tags:** dynatrace-managed, oneagent\
**Created:** [March 23, 2023, 2:17pm UTC](https://community.dynatrace.com/t/dynatrace-business-events-extractions-of-json-array/38977 "2023-03-23T14:17:02Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![keekos](https://avatars.discourse-cdn.com/v4/letter/k/ebca7d/32.png) [@keekos](https://community.dynatrace.com/u/keekos)\
**Post date:** [April 4, 2023, 8:05pm UTC](https://community.dynatrace.com/t/dynatrace-business-events-extractions-of-json-array/38977/4 "2023-04-04T20:05:22Z")

</div>

Thanks, that unfortunately doesn’t cover the use case when your data sample omits accountData key for the array.

I ended up using DQL parse and was able to retrieve the correct value.

```markup
PARSE(requestbody, "DATA 'Account'LD SPACE?':' SPACE? DQS:Account ")

```

---

_[View the full topic](https://community.dynatrace.com/t/dynatrace-business-events-extractions-of-json-array/38977)._
