CXone Studio DBConnector action returning null despite valid query

NICE CXone API & Integrations
1

I’m trying to pull customer data in a CXone Studio script using the DBConnector action. The connection profile works fine in the test panel, but when the script runs, the result object is always null. I’ve double-checked the SQL syntax and it’s a simple SELECT statement.

Here’s the snippet:

{
 "action": "DBConnector",
 "query": "SELECT name FROM users WHERE id = {{data.customerId}}"
}

Any ideas why it’s failing silently?