I did a "Query JSON with SQL" (query 1), that result in a 3 dimension array. I need one of those dimensions to be used as a condition to another query (query 2). Something like:
Select * from table1 where column in (query1[dimension])
I tried to use a transformer to extract the dimension i need from query1, but i havent figure it out yet.
Can anybody help me , please?