Using the DBConnector action in to query a legacy SQL Server. The SQL works fine in SSMS, but the script always returns an empty array. No error is thrown, just empty results. Here’s the JSON config for the action:
{
"sql": "SELECT * FROM agents WHERE status = 'active'",
"connectionId": "conn-123"
}
Is there a known issue with how handles parameter binding or timeout for this specific connector?