Conditional forEach statement in Velocity Script

Question

I've been using @Sanford Whiteman's excellent resource on using JSON in Velocity script but am stuck on how I'd go about only displaying certain records from the JSON.

For example in the following I only want to list the relevant values where {{lead.email domain}} = allProjects.domain. So anyone with a domain of company01.com would see the first 2 records listed, whereas company02.com would only see the last record (there will be about 50 - 100 records in the JSON eventually). Any pointers greatly appreciated!

#set( $allProjects = [
{
    "domain": "Company01.com",
"category": {
        "URL": "https://www.example.com/project1",
        "companyName": "Company 01",
        "name": "Example Project Name 01",
"participantType": "Champion"
    }
},
{
    "domain": "Company01.com",
"category": {
        "URL": "https://www.example.com/project2",
        "companyName": "Company 01",
        "name": "Example Project Name 02",
"participantType": "Champion"
    }
},
{
    "domain": "Company02.com",
"category": {
        "URL": "https://www.example.com/project1",
        "companyName": "Company 02",
        "name": "Example Project Name 01",
"participantType": "Champion"
    }
}
}
] )
<p><br /></p>
<ul>
#foreach( ${allProjects.domain} in $allProjects )
<li>
<a href="${allProjects.category.URL}" target="_blank" id="">${allProjects.category.name}</a></li>
#end
</ul>

${allProjects.category.name}

SanfordWhiteman · Accepted Answer

There's no built-in collection filtering w/predicates in Velocity. So you do a simple loop and move the matches into another collection:

#set( $domainProjects = [] )
#foreach( $project in $allProjects )
#if( $project.domain.equalsIgnoreCase($lead.emailDomain) )
#set( $void = $domainProjects.add($project) )
#end
#end
#foreach( $project in $domainProjects )
## this is your subset of matches
#end

Your {{lead.email domain}} token, when you check it off and drag it onto the Velocity canvas, isn't going to have a space in it (the Velocity $lead.property name isn't the same as the token name). So I've used $lead.emailDomain here.

Mark_Price · Answer

Once you get the #foreach working, you may then be surprised by an obscure system behavior with links and #foreach loops.

If you are going to output a link from within a #foreach loop, you will probably need to add the class "mktNoTrack" to your link OR deploy a workaround. Otherwise, you'll potentially output a dead links.

Here's a resource that helped me understand what was going on when encountering this issue: https://blog.teknkl.com/multiple-marketo-tracked-links-in-velocity/

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded