Hey everyone,
I’m trying to query a custom table in CXone Studio using the DBConnector action. I’ve got the connection string set up and the SQL looks fine when tested in the browser, but the script throws a 500 Internal Server Error every time it hits the lookup step.
Here’s the payload I’m passing to the action:
{
"sql": "SELECT * FROM agents WHERE status = :status",
"params": {
"status": "active"
}
}
The error log just says “Database query failed” without much detail. Is there a specific permission or format I’m missing for the params object?