So I’m seeing a very odd bug with the DBConnector action in Studio. I’ve verified the connection string and credentials are correct, and the SQL query runs fine in the database manager. However, the Studio action consistently returns an empty result set, even when the query should return a single row.
Here is the configuration I’m using:
sql: SELECT * FROM customers WHERE email = '{{input.email}}'
The output variable dbResult is always null. Has anyone hit this issue with parameterized queries in DBConnector? Are there specific escaping rules for the input variable?