1

I need to personalize a triggered send using Marketing Cloud Connect and a custom object to contact relationship, but I'm not getting results for the relationship. My AMPscript looks like this:

%[
Set @mySObject = AttributeValue("SObject")
Set @myRecordId = AttributeValue("RecordId")

Set @customObject = RetrieveSalesforceObjects(@mySObject,"Field__c, Contact__r.Name","Id", "=",@myRecordId)

var @customObjectRow, @fieldValue, @contactName
Set @customObjectRow = Row(@customObject, 1)
Set @fieldValue = FIELD(@customObjectRow, "Field__c")
Set @contactName = FIELD(@customObjectRow, "Contact__r.Name")
]%

<html>
This will have a value: %%=v(@fieldValue)=%%
This will have a blank value: %%=v(@contactName)=%%
</html>

I've been reading documentation all night and haven't found anything useful. Can you use object relationships straight from Sales Cloud without having to do another RetrieveSalesforceObjects function call?

0

You are using Contact__r.Name which isn't a proper AMPscript syntax. What you need to do, is declare api names of all fields that you want to retrieve from the object, for example:

set @subscriberRows = RetrieveSalesforceObjects(
   "Contact",
   "FirstName,LastName,Email",
   "Id", "=", _subscriberKey )
  • "Contact" is the object from which you are retrieving
  • "FirstName,LastName,Email" are the fields you are retrieving
  • "Id", "=", _subscriberKey is how you match your Salesforce Data with Marketing Cloud data

Read more here: https://ampscript.guide/retrievesalesforceobjects/

  • So the solution here is to make 2 RetrieveSalesforceObjects function calls ... one to retrieve data from the custom object and one to retrieve data from the related contact? I've been reading the Ampscript guide book, but I can't find anything about retrieving data from related objects through lookups, which is really my issue. – justinpdove Aug 16 at 11:43
  • retrieving data from related objects through lookups > that won't work in Marketing Cloud, al least not the way it works in Sales Cloud. If you have the field from custom object included in your Contact as a lookup, you can retrieve it but it will show up as the Object ID of that related object. Try it and see what results you get: set @subscriberRows = RetrieveSalesforceObjects("Contact","LookupField__c","Id", "=", @myRecordId) – CodeRage Aug 16 at 12:17
  • and yes, if just the Id of that related object isn't enough, you will have to make a second RetrieveSalesforceObjects function call – CodeRage Aug 16 at 12:27
  • @justinpdove if my answer helped, please mark it as accepted - thanks! – CodeRage Aug 16 at 13:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.