SOLVED

Velocity Script - Connecting to a SFDC object with brackets in its name

Go to solution
Benjinc
Level 2

Velocity Script - Connecting to a SFDC object with brackets in its name

I'm having an issue where I've been unable to google a solution.

I'm trying to set up a script that references a Salesforce Object whose name includes brackets

Is there a way to escape/ encode the brackets in velocity so that I can reference this object? Or is it something else I've got wrong?  The token currently returns nothing.


I have pasted where I am below, I want to extract values stored in the Policy (Policy_Sponsor__c) object. I assume I need to name this were I have xxxxxxxxx in place

 

Benjinc_0-1700159105940.png

 
<table style="border-spacing: 0; border-collapse: collapse; width: 600px;">
#foreach ($Policy__cList in $xxxxxxxxxx)
<tr> 
    <td style="padding: 4px; font-family: arial; border-collapse: collapse !important; border: 1px solid black">
    ${Policy__cList.get(0).Policy_Status__c} BEN WAS HERE
    </td>
      <td style="padding: 4px; border-collapse: collapse; border: 1px solid black">
    ${Policy__cList.get(0).Name}
    </td>
    </tr>
    
#end
</table>


1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

Re: Velocity Script - Connecting to a SFDC object with brackets in its name

There’s no need for guesswork. The Velocity name is the name you get when you take a field from the tree and drag it to the canvas.

 

In your case the name of the object list is $Policy__cList. That’s what you iterate. And yes, you don’t want to keep referencing item 0.

#foreach( $item in $Policy__cList )
## $item is set to each item in turn
#end

 

View solution in original post

4 REPLIES 4
SanfordWhiteman
Level 10 - Community Moderator

Re: Velocity Script - Connecting to a SFDC object with brackets in its name

You’re leaving out vital details. What is the name of the object in SFDC, and what is the Velocity name of the object list (which you see when you check off a field in the tree and drag it to the canvas)? 

 

Marketo attempts to make a valid Velocity name for any object/field that wouldn’t otherwise be compatible. That’s why you can’t actually know for sure what the Velocity name will be outside  of Script Editor. But you haven’t shown the name Marketo is giving to the object list. Unless it’s $Policy__cList, in which case that’s what you should be iterating.

Benjinc
Level 2

Re: Velocity Script - Connecting to a SFDC object with brackets in its name

As far as I'm aware the object name is Policy (Policy_ Sponsor__c), or would Marketo rename this in the Admin interface?

 

I tried iterating on the $Policy__cList  but while it did print out 4 rows (the user tested has 4 policies), they were all of the most recent policy details.  

 

... Or could that be due to the fact that its referencing (0) after .get?

 

Should I be able to actually drag the whole Object into the script builder? When I do this, it just tries to pull in the gif...

 

Benjinc_0-1700168418280.png

 

SanfordWhiteman
Level 10 - Community Moderator

Re: Velocity Script - Connecting to a SFDC object with brackets in its name

There’s no need for guesswork. The Velocity name is the name you get when you take a field from the tree and drag it to the canvas.

 

In your case the name of the object list is $Policy__cList. That’s what you iterate. And yes, you don’t want to keep referencing item 0.

#foreach( $item in $Policy__cList )
## $item is set to each item in turn
#end

 

Benjinc
Level 2

Re: Velocity Script - Connecting to a SFDC object with brackets in its name

SMH!


Thanks, all working!

 

It was the (0) etc causing the issue that drew in the same values over and over