The DBConnector action in Studio keeps returning an empty result set despite the SQL query working fine in the DB client. The connection test passes, but the script fails at the lookup step. Here’s the config:
{
"action": "DBConnector",
"query": "SELECT * FROM users WHERE id = {{user.id}}",
"connection": "prod_sql_conn"
}
No error thrown, just null output.