I’m trying to pull customer data in a CXone Studio script using the DBConnector action. The SQL looks fine when I test it directly in the database, but the script always returns an empty result set. Here’s the configuration I’m using:
{
“sql”: “SELECT * FROM customers WHERE phone = ‘{{session.contact.phone}}’”,
“connectionId”: “conn-123”
}
I’ve checked the variable mapping and the phone number is definitely passing through. Is there a specific format requirement for the parameter binding in Studio? Or maybe a timeout issue?