topic Re: Add global variable to tSendMail subject in Talend Studio

Add global variable to tSendMail subject

Anonymous — Sat, 16 Nov 2024 03:39:17 GMT

Who am I able to add a global variable to the subject of tSendMail? Whenever I try it is not adding the global variable to the subject. I was able to get it to work for the body of the email but can't seem to get the subject to work.

In the above picture the body works but for some reason the subject does not. Any advice to getting this to work?

Re: Add global variable to tSendMail subject

Anonymous — Tue, 07 Jan 2020 20:35:27 GMT

This may or may not be the issue, but you should be casting to the appropriate data type when you retrieve values from the globalMap

(String)globalMap.get("myJob")

Re: Add global variable to tSendMail subject

Anonymous — Tue, 07 Jan 2020 20:38:49 GMT

Unfortunately, that was not the issue but thank you for the information. I will update them now to use casting.

Re: Add global variable to tSendMail subject

Anonymous — Tue, 07 Jan 2020 21:24:45 GMT

Is the global being set correctly/before you send an email?

Usually you can just reference the job's name from built-in value

jobName

Re: Add global variable to tSendMail subject

Anonymous — Tue, 07 Jan 2020 21:29:08 GMT

Not sure to be honest. I only ever did it as (String)globalMap.get("myJob") and this works other places such as the email body and sql queries but not in the subject line so not sure what is going on.

Re: Add global variable to tSendMail subject

Anonymous — Tue, 07 Jan 2020 21:34:33 GMT

I think for some reason the global variable is empty because the following when I send it outlook says the email has no subject.

(String)globalMap.get("myJob") + "ESB Job Failure"
and
(String)globalMap.get("myJob")

I can't think why since it works fine in the body of the email which is apart of the same thing