We’re migrating a logic block from Genesys Cloud to CXone Studio and running into a wall with the DBConnector action. The SQL query returns a valid JSON array, but the subsequent ASSIGN step keeps failing to parse the nested fields. Here’s the snippet:
DBConnector: execute_query("SELECT * FROM customers WHERE id = ?", [session.customerId])
ASSIGN: result = DBConnector.result
LOG: Debug result is {{result}}
The log shows the data is there: [{"id": 123, "metadata": {"tier": "gold"}}]. When I try to access result[0].metadata.tier, the script errors out with Invalid JSON path. I’ve tried using dot notation and bracket notation in the ASSIGN step, but CXone Studio seems to choke on the nested object inside the array. Is there a specific syntax for unwrapping the first element of a DBConnector result set before accessing deeper properties? We’ve verified the DB connection is fine and the query runs in the console without issues. It feels like the Studio engine is treating the whole array as a single string rather than a structured object. Any ideas on how to flatten this or extract the tier value correctly?