I need to send a Marketing Cloud Triggered Email using Marketing cloud connect when a new case is created in Service Cloud. My email has some personalized information as well (e.g. CaseNumber).
I referred to the documentation and used the below AMPScript

My Triggered Email is failing. I think it is because I don't have the RecordID value of the Case

How can I get that?

%%[Set @mySObject = "Case" 
@myRecordId = RecordIdset 
@Case = RetrieveSalesforceObjects(@mySObject,"Subject,Status,Priority,CaseNumber","Id", "=", @myRecordId)
Set @CaseRow = Row(@Case, 1)
Set @Subject = FIELD(@CaseRow,"Subject")
Set @CaseNumber = FIELD(@CaseRow,"CaseNumber")]%%
  • Is this the actual definition of the record ID you're trying to set? @myRecordId = RecordIdset? – Tom Callahan Feb 11 at 21:27
  • No it’s not and that’s exactly my confusion. How do I get the Case Record ID here? – Maneesh Feb 11 at 21:28
  • Are you using Email Studio triggered send definition, or journey builder? – Tom Callahan Feb 11 at 21:31
  • Triggered Send Definition in Email Studio – Maneesh Feb 11 at 21:31

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.