Thanks Gauri, that worked. I have a follow up to this question, since i am only retrieving 1 row from the data source, how do i use the columns retrieved downstream in the workflow. My requirement is to put the columns in an email notification. Here's my query again, SELECT account.name AS AccountName, account.id AS AccountId, rateplancharge.name AS ChargeName, rateplancharge.quantity AS Quantity, Subscription.trialid__c AS AdminEmail,Subscription.initialterm AS Term FROM Account JOIN Subscription ON Account.id = subscription.accountid JOIN RatePlan ON Subscription.id = rateplan.subscriptionid JOIN RatePlanCharge ON RatePlan.id = rateplancharge.rateplanid JOIN ProductRatePlan ON RatePlan.productrateplanid = ProductRatePlan.id JOIN ProductRatePlanCharge ON ProductRatePlan.id = ProductRatePlanCharge.productrateplanid WHERE Subscription.id = '{{Data.Subscription.Id}}' Thanks, Vimal
... View more
