# Advanced JSON Array Object Column | Query Properties as JSON Array

**URL:** <https://community.glideapps.com/t/advanced-json-array-object-column-query-properties-as-json-array/80439>\
**Category:** Feature Requests\
**Created:** [March 2, 2025, 12:02pm UTC](https://community.glideapps.com/t/advanced-json-array-object-column-query-properties-as-json-array/80439 "2025-03-02T12:02:26Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [March 7, 2025, 4:10pm UTC](https://community.glideapps.com/t/advanced-json-array-object-column-query-properties-as-json-array/80439/7 "2025-03-07T16:10:47Z")

</div>

You cannot use a **JSON Object** column to retrieve multiple properties from a query and output them as an array.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/3/7367771994dc37f2f9b695d05d900b5d56dd99f0.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/a/9a2bfdfdf6ce80f70eddeba8c907e4e7d3d861b2.png)  
Here, you can’t access query properties. However, it would be very beneficial to have the ability to output a JSON array containing the specified properties. For example:

```json
[
   {
      "prop1":"value of row 1's prop1",
      "prop2":"value of row 1's prop2"
   },
   {
      "prop1":"value of row 2's prop1",
      "prop2":"value of row 2's prop2"
   },
   "..."
]

```

Currently, the workaround to achieve the desired result involves the following steps:

1. Open the queried table.

2. Add a JSON Object column:  

3. In the main table, include a joined list column:  

4. Create a Template column to add array brackets around the joined list:  

5. Finally, add a JSON Template column to format the template into valid JSON:  

It would be much easier and beneficial to have the ability to create a JSON Object Array directly.

I may consider renaming my feature request.

---

_[View the full topic](https://community.glideapps.com/t/advanced-json-array-object-column-query-properties-as-json-array/80439)._