N1QL paths for deeply nested data

SQL++
9 
INSERT INTO default VALUES ("f01",{ "paths": { "/emv3dsecure/v1/devicedatacollection": { "post": { "summary": "EMV 3D SEcure Device Data Collection API", "parameters": [ { "name": "ProfileId", "in": "query", "description": "ProfileId for Cors Authentication", "required": true, "style": "form", "explode": true, "schema": { "type": "string" } } ] }}, "/emv3dsecure/v1/stepup": { "post": { "summary": "EMV 3D Secure StepUp API", "parameters": [ { "name": "ProfileId", "in": "query", "description": "ProfileId for Cors Authentication", "required": true, "style": "form", "explode": true, "schema": { "type": "string" } } ] }}, "/emv3dsecure/v1/merchantreturnurl": { "post": { "parameters": [ { "name": "TransactionId", "in": "query", "description": "Transaction Id included in Step Up JWT", "required": true, "style": "form", "explode": true, "schema": { "type": "string" } }] }} } });

SELECT m.*
FROM default AS m
WHERE ANY v WITHIN m.paths SATISFIES IS_ARRAY(v.parameters) AND (ANY p IN v.parameters SATISFIES p.name = "TransactionId" END) END;

SELECT ARRAY_FLATTEN(ARRAY v.parameters FOR v WITHIN m.paths WHEN v.parameters IS NOT NULL END, 1) AS parametrs
FROM default AS m
WHERE ANY v WITHIN m.paths SATISFIES IS_ARRAY(v.parameters) AND (ANY p IN v.parameters SATISFIES p.name = "TransactionId" END) END;