Ampscript "lookup" don't work for synchronized data extension "Case_Salesforce"

Question

I am trying to extract data from synchronized data extension "Case_Salesforce" to show on an email. Is it possible to do this? I am using lookup function to achieve. I can get synchronized data extension "Contact_Salesforce" ,but cannot get data out of "Case_Salesforce". Does Anyone know what the differnce is between them?

%%[<br>
var @lookupvalue,@CaseId,@Subject,@ContactEmail,@Status<br>
set @lookupvalue = AttributeValue("_subscriberkey")<br>
set @CaseId = Lookup("Case_Salesforce","Id","Id",@lookupvalue)<br>
set @Subject = Lookup("Case_Salesforce","Subject","Id",@lookupvalue)<br>
set @ContactEmail = Lookup("Case_Salesforce","ContactEmail","Id",@lookupvalue)<br>
set @Status = Lookup("Case_Salesforce","Status","Id",@lookupvalue)<br>
]%%<p>
Case Detail<br>
CaseID:%%=v(@CaseId)=%%<br>
Subject:%%=v(@Subject)=%%<br>
Status:%%=v(@Status)=%%<br>
</p>

Answer 1

• Please make sure you have these additional fields added to your SYNCED object.
  • Then make sure you are searching based on "ContactID" and NOT "Id"

%%[
var @lookupvalue,@CaseId,@Subject,@ContactEmail,@Status
set @lookupvalue = "0030o00002dgaRDAAY"
set @CaseId = Lookup("Case_Salesforce","Id","ContactId",@lookupvalue)
set @Subject = Lookup("Case_Salesforce","Subject","ContactId",@lookupvalue)
set @ContactEmail = Lookup("Case_Salesforce","ContactEmail","ContactId",@lookupvalue)
set @Status = Lookup("Case_Salesforce","Status","ContactId",@lookupvalue)
]%%

Case Detail
CaseID:%%=v(@CaseId)=%% <br/>
Subject:%%=v(@Subject)=%% <br/>
Status:%%=v(@Status)=%% <br/>

• I have hardcoded the subkey for testing. And it worked for me!