Flatten or Filter Nested JSON

[vicdavies01]

Hello!

I previously used this format (arr->key) to pull out values from an array within my query but recently it stopped pulling the data through correctly

These are the steps that I'm following:

1. I have a MongoDB query that returns the following sample data as an example, lets assume there is a string column called companyName and a json columns called 'list_admin' which has the below format

[
{"id": 1,
"email": test1@test.com},
{"id": 4,
"email": test4@test.com}
]

2. I was then using Query JSON with SQL to return the email addresses so they showed in a concatenated list for each company

select
companyName,
GROUP_CONCAT(list_admin -> email) 
from {{getCompanies.data}}

group by companyName

Previously this returned the following table

Company Name | test1@test.com, test4@test.com

But now I'm getting the error attached

Any help much appreciated!