Advanced JSON Array Object Column | Query Properties as JSON Array

[MaximeBaker]

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

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:

[
   {
      "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:
   

   
   
   Make sure to separate values by a comma:
   
   

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.