Inserting next unused item from an external file in triggered email to respondent


We are going to be deploying Starbucks eGift Cards as an incentive for people who complete a survey we are building. Starbucks will provide me with a file of one time use urls that we can insert into an email address that the respondent can click on to add the value of the eGift Card to their Starbucks account.

I was wondering if anyone knew of a way to access an external file and to pull the next available code and then insert it into the triggered email sent upon completion of a survey.

Anyone have any thoughts or ideas?


Jon Erickson answered

    Thanks Mary, we are deploying using the client’s ESP so this does not work. However the support team sent me this link which was totally on target.

    Jon Erickson answered

      Hi Jon,

      How are you launching your survey?  If you are doing an email campaign, you could upload the URLs as a custom column in your campaign list and use merge codes to include them in an Email Action. 

      Let me know if you have any questions.


      Mary L (Moderator) answered


        Question stats

        • Active
        • Views8569 times
        • Answers2 answers
        • Followers1 follower