Getting a 500 Internal Server Error from the DBConnector action in Studio when running a basic SELECT query. The connection test passes fine, and the SQL works in the admin console, but the script crashes immediately. Here’s the config:
Action: DBConnector
Query: SELECT id FROM users WHERE name = '{{contact.attributes.name}}'
Timeout: 3000
The error log just says ‘Database query failed’ with no stack trace. Am I missing a permission scope on the connector?