Using dynamic attribute in email template

[Dalalsaleh888]

We have a requirement to print dynamic attribute in email template and found the below documentation/code for Configuring Service Account Creation Email template ${accessItems.collect{ it.request_access_attrss.find{it.attributeName.toString().equalsIgnoreCase('Location')}.collect{it.attributeValue}}.get(0) - Obtains a specific dynamic attribute name and value from request. But when we used this in the email template we got the below error : Error while sending email - No such property: accessItems for class: SimpleTemplateScript224 groovy.lang.MissingPropertyException: No such property: accessItems for class: SimpleTemplateScript224 at SimpleTemplateScript224.run(SimpleTemplateScript224.groovy:7) Could you please share the correct document or code to achieve the expected result . Saviynt document referred - https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter06-EIC-Configurations/Creati...

[rushikeshvartak]

Which email template & where it is attached?

[Dalalsaleh888]

service account email template for new account creation.

[rushikeshvartak]

${this.binding.variables.each {k,v -> println "$k = $v" + "<" + "br" + ">"}}

find variables exposed using above script in email body

[Dalalsaleh888]

This expression didn't give the dynamic attribute. It gives variables of the account like name and owners and information about the requests.

[Dalalsaleh888]

Any other suggestions :)???

[rushikeshvartak]

Share result 

[rushikeshvartak]

${accessItems.collect{it.request_access_attrss.findAll{it.attributeName.toString().equalsIgnoreCase('Location')} .collect{it.attributeName.toString() + ': ' + it.attributeValue}.join('###')}.toString().replaceAll('\\[','').replaceAll('\\]','').replaceAll('\\,','')}

[Dalalsaleh888]

Result: no email received.

Error:

[rushikeshvartak]

Share output of this email & when this email is triggered ? And where email template is attached ?

[Dalalsaleh888]

Hello,

As I mentioned, the email is not received due to the above-attached error. below is the email template:

[sk]

I see you are trying to get accttype from access items. Is it custom Dynamic attribute if not try variable: ${ACCOUNTTYPE}

[Dalalsaleh888]

Yes, it is a custom Dynamic attribute name.

[sk]

Then try below variable also make sure that Advanced CSS is enabled

${accessItems.collect{it.request_access_attrss.findAll{it.attributeName.toString().equalsIgnoreCase('accttype')}.collect{it.attributeValue}}.get(0)}

[Dalalsaleh888]

encountered the same previous error:

[Manu269]

Can you check this :

Favorite Food:<br>

${accessItems.collect{ it.request_access_attrss.find{it.attributeName.toString().equalsIgnoreCase('FavFood')}.collect{it.attributeValue}}.get(0)}<br><br>

[Dalalsaleh888]

same error

[rushikeshvartak]

Can you share output of below code 

${this.binding.variables.each {k,v -> println "$k = $v" + "<" + "br" + ">"}}

[Dalalsaleh888]

Here is the result of ${this.binding.variables.each {k,v -> println "$k = $v" + "<" + "br" + ">"}}

[sk · Accepted solution]

This looks like Task completion email not request approval emails. In that case accessItems won't work you need to derive from task .

Please use below in that case

${task?.requestAccessKey?.collect{it.request_access_attrss.findAll{it.attributeName.toString().equalsIgnoreCase('accttype')}.collect{it.attributeValue}}.get(0)}

[Dalalsaleh888]

This one worked! thanks. but, is there a way the value can be printed without the square brackets?

[sk · Accepted solution]

Try below options

${task?.requestAccessKey?.collect{it.request_access_attrss.findAll{it.attributeName.toString().equalsIgnoreCase('accttype')}.collect{it.attributeValue}}.get(0).join(', ')}

or

${task?.requestAccessKey?.collect{it.request_access_attrss.findAll{it.attributeName.toString().equalsIgnoreCase('accttype')}.collect{it.attributeValue}}.get(0).toString().replaceAll('\\[','').replaceAll(']','')}

or ${String.valueOf(task?.requestAccessKey?.collect{it.request_access_attrss.findAll{it.attributeName.toString().equalsIgnoreCase('accttype')}.collect{it.attributeValue}}.get(0)).replaceAll('\\[','').replaceAll(']','')}

[Dalalsaleh888]

Thank you! All 3 line codes print the dynamic attribute without [] 👍

[sk]

Great can you mark it as solution so that it helps others as well