# How to display multiple proxy metadata entries in tabular format instead of a single JSON cell

**URL:** <https://community.dynatrace.com/t/how-to-display-multiple-proxy-metadata-entries-in-tabular-format-instead-of-a-single-json-cell/56013>\
**Category:** DQL\
**Tags:** dql\
**Created:** [May 27, 2026, 1:20pm UTC](https://community.dynatrace.com/t/how-to-display-multiple-proxy-metadata-entries-in-tabular-format-instead-of-a-single-json-cell/56013 "2026-05-27T13:20:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![achoud22](https://avatars.discourse-cdn.com/v4/letter/a/d2c977/32.png) [@achoud22](https://community.dynatrace.com/u/achoud22)\
**Post date:** [May 27, 2026, 1:20pm UTC](https://community.dynatrace.com/t/how-to-display-multiple-proxy-metadata-entries-in-tabular-format-instead-of-a-single-json-cell/56013/1 "2026-05-27T13:20:19Z")

</div>

We are currently fetching proxy metadata using an external service and persisting the output as a business event. To reduce the number of biz events, we ingest metadata for all proxies (e.g., 9 proxies) as a single JSON object.

The challenge is that when this data is displayed in a table, the entire JSON object shows up in one cell, which makes it hard to read and analyze.

Is there a recommended way in Dynatrace to:

- Separate each proxy’s metadata into its own row or column,
- Flatten or expand the JSON array for tabular display,
- Or otherwise visualize the data in a more structured format?

Currently, everything is lumped into one cell, but we’d like to see each proxy’s metadata clearly in a table view. What’s the best practice for handling this scenario?

---

<div class="post-metadata">

**Author:** ![dannemca](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/dannemca/32/7215_2.png) [@dannemca](https://community.dynatrace.com/u/dannemca)\
**Post date:** [May 27, 2026, 2:00pm UTC](https://community.dynatrace.com/t/how-to-display-multiple-proxy-metadata-entries-in-tabular-format-instead-of-a-single-json-cell/56013/2 "2026-05-27T14:00:55Z")

</div>

You can parse it using the default JSON DPL, and expand the array with “expand” command:

> **[DPL JSON Data](https://docs.dynatrace.com/docs/platform/grail/dynatrace-pattern-language/log-processing-json-data)**
>
> DPL JSON\_OBJECT, JSON\_ARRAY, and JSON\_VALUE matchers parse JSON objects, arrays, and standalone values in log data according to RFC 8259.

> **[expand - DQL structuring commands](https://docs.dynatrace.com/docs/platform/grail/dynatrace-query-language/commands/structuring-commands#expand)**
>
> Expands an array into separate records. This command takes an array, and for each incoming record, produces as many new records as there are elements in the array of the expression. The number of elements is limited by the limit parameter or the...
