What’s the right way to handle parameterized queries in a Studio DBConnector action without triggering a 500? I’m trying to pull a customer record based on an ID passed from the IVR menu. The connection profile is set up and tested, so that part is solid.
The issue hits every time the script reaches the DBConnector step. It returns a 500 Internal Server Error with no useful details in the Studio logs. The SQL query works fine when I run it directly in the database client, so the syntax isn’t the problem. Here’s the JSON payload I’m sending to the connector:
{
"query": "SELECT * FROM customers WHERE id = :custId",
"parameters": {
"custId": "{sys.data.callerId}"
}
}
I’ve tried hardcoding the ID instead of using the variable, and it still fails. Same 500 error. The documentation implies this should be straightforward. Is there a specific format for the parameters object that I’m missing? Or is this a known limitation with the DBConnector action when dealing with numeric types?
We’re running this in a production environment, so downtime isn’t an option. I need a fix that works reliably. The error log just shows DBConnector failed: Internal Server Error. Nothing else. No stack trace. No SQL error message. Just a generic 500.
Has anyone else hit this wall? What did you do to get past it?