Unable to fetch analytics data in email body

[Harsha]

Hi,

we are trying to fetch details of analytics report in email as following:

so in log it says  Missing Property exception. Am I missing something? Please do help.

Thank you,

Harsha

[RakeshMG]

In your email template space is missing between FirstName and LastName, please try following sample with space.

Body:${ANALYTICSDATA.'First Name'[0]} ${ANALYTICSDATA.'Last Name'[0]}

For more details on email templates please refer to following document : https://docs.saviyntcloud.com/bundle/EIC-Admin-v232/page/Content/Chapter06-EIC-Configurations/Creati...

[Harsha]

Hello,

Yes we tried both ways by giving space and by removing it but error is still the same Missing property exception.

[RakeshMG]

Please share the complete template.

[Harsha]

Hi,

Thank you for your quick response.I am just testing analytics mail, so this is the complete template is as following

Email body:

Hi,

Please find below the details:
First Name- ${ANALYTICSDATA.'First Name'[0]}
Last Name- ${ANALYTICSDATA.'Last Name'[0]}

Please let me know why ANALYTICSDATA is not supporting, following is the error in logs:

023-03-07T08:04:50.832961538Z stdout F 2023-03-07 08:04:50,832 [http-nio-8080-exec-329] DEBUG println.PrintlnToLogger - Println :: | Error groovy.lang.MissingPropertyException: No such property: ANALYTICSDATA for class: SimpleTemplateScript325

Thank you,

Harsha

[RakeshMG]

In your email template please use only ${ANALYTICSDATA} do not use any other attributes.

----------------------

Hi,

Please find below the details:

${ANALYTICSDATA}.

----------------------

Could you please let me know the test result is success or failure.

If success, what is the result set.

If failure, please share error.

[Harsha]

Hello,

mail was sent successfully but resultset is blank

below is email template:

Also analytics is not empty, it has 1 record. Below is analytics query:

select u.username, u.firstname as 'First Name', u.lastname as 'Last Name', u.email, u.startdate, u.enddate, (select u1.email from users u1 where u.manager=u1.userkey) as 'Manager Email' from users u where u.customproperty30 in ('GUEST') and u.enddate between CURDATE() and CURDATE()+24

below is report:

Please let me know, if you have any idea what is the issue.

Thank you,

Harsha

[RakeshMG]

In global config, Group emails by username.

Please check ,if its not enabled as it may throw a error.

If still facing issue request you to open FreshDesk ticket with support team and share this forum post for reference.