Step one: we’ve got a Studio script that needs to pull a legacy customer flag from a backend SQL database. The DBConnector action is configured with a standard ODBC connection string. Step two: the SQL query is a simple SELECT statement. It looks like this:
SELECT isActive FROM customer_flags WHERE account_id = '{{interaction.attributes.accountId}}'
Step three: the issue is that the DBConnector returns an empty result set every single time. The {{dbConnector.resultSet}} object is null. Step four: I’ve verified the connection is alive by running a dummy SELECT 1 query in the same script, and that works fine. The accountId attribute is populated correctly, and I’ve even logged it to the debug log to confirm it matches a row in the database.
Is there a known issue with how the DBConnector handles parameter substitution in WHERE clauses? Or does it require a specific JSON payload format for the query execution that I’m missing? The documentation is pretty sparse on error handling for empty sets versus actual failures. I’m getting a 200 OK from the connector action itself, so it’s not throwing an exception. Just silently returning nothing.