Trying to pull a customer record in Studio using DBConnector but the output variable stays null.
The connection works fine in the test tab, but when running the script it fails silently. Here is the config:
action: DBConnector
query: "SELECT * FROM customers WHERE id = {{request.customerId}}"
output: dbResult
The dbResult object is empty. Am I missing a step to parse the response?