Email Event Action help

If those images are too small, here are larger images.

Even this hasn’t worked.

How do IFS Cloud Projections relate to APIs? Aren’t projection actions essentially just API calls? 

Hi @anmise 

I really appreciate the reply, especially with how quick it was.

Yes I am trying to email the main contact. I tried adding that into the custom attribute and I swapped the main_contact_id with the &OLD:MAIN_CONTACT_ID but I got this error:

Luckily, I tried this with &NEW:MAIN_CONTACT_ID and It didn’t give me an error!

I will have to turn on the emailer and try this. Thanks! I truly appreciate the help!
Thanks again!
Bryan

No worries. Unfortunately just from experience, and not something I think you’d easily be able to figure out through the front end (there might be a way I’m not aware of). PL/SQL APIs are being replaced by projections to a large extent, but sometimes there’s no other way.   

Hello again @anmise,

Thanks again for answering my question. I’m wondering if you know what API calls I’d have to use to get the equivalent of the BusinessOpportunityHandling.GetRepsToSendEmail function call. I’d like to get the main rep for this Business Opportunity so I know who to put as the sender. 

Also another IFS Employee just replied to another post saying that these PL/SQL executions are going to be ‘discontinued’ from future updates. Do you know if that will stop my Custom Attribute API calls that I’m currently making?

Thanks again,
Bryan

Hi @anmise 

Thanks again for helping me out with the API calls. Unfortunately.. I don’t think those API calls worked. I keep getting the error “Mail address 'To' field is not specified” when I use “&CONTACT_EMAIL”. That custom attribute has the 

“Comm_Method_API.Get_Value('PERSON', &NEW:MAIN_CONTACT_ID, Comm_Method_Code_API.Decode('E_MAIL'))” 

values we discussed before.

Unless I am formatting this incorrectly (I’ve tried using #CONTACT_EMAIL#, &CONTACT_EMAIL, and just CONTACT_EMAIL but all have resulted in the same error) I believe the issue might be with the API calls. I’ve tried just putting my email in that To: field and it worked.

Any insight would be greatly appreciated.

Thanks,
Bryan

Thinking about this more, would IFS Cloud automatically get the email for these accounts if you only use their IDs? For example, if I have just this

I’m wondering if IFS would fetch that information by itself, since it’s not explicitly asking for an email. I have to wait to test as our emailer isn’t up, but It was something I was thinking about after I saw some documentation saying that IFS will fetch certain information by itself (I cannot find where that document lived)

No it wouldn’t as all it’s doing is replacing that with the value from the field, however if there was a field called MAIN_REP_EMAIL then you could just put &NEW:MAIN_REP_EMAIL in the From User field.

Comm_Method_API.Get_Value('PERSON', main_representative_id, Comm_Method_Code_API.Decode('E_MAIL'))

Are you including the ampersand (&)? It’s important.

Also @anmise I just checked the BUSINESS_OPPORTUNITY table and for the BO that I was testing, both the Main_Contact_Id field and the Main_Representative_Id fields were populated. I looked both us via the Person page and both exist and have emails associated to them.

Thanks,
Bryan

Hi @anmise 

I’ve enabled the old values of the two fields, I just tried that and it didnt work. I tried adding the values in single quotes and that didnt work either unfortunately.

I also tried your example with just the “Comm_Method_API.Get_Value('PERSON', '&MAIN_CONTACT_ID', Comm_Method_Code_API.Decode('E_MAIL'))” and that sadly didn’t work as well.

Hi @anmise could it be that the ‘E_MAIL’ portion isn’t using the same formatting we are?

 

I went to the Person page for the main contact and this is what I saw 

We are using E-Mail but I’m not sure if that even matters

Ok, sorry for the mess. I had to test it out myself. This works for me.

 

Comm_Method_API.Get_Value('PERSON', &OLD:MAIN_CONTACT_ID, Comm_Method_Code_API.Decode('E_MAIL'))

Please give that a go. 

 

@anmise 

I’m so sorry, you’re going to hate me, I just tested on multiple Business Opportunities and a few of them worked. It must be something related to how the email is saved on some of the contacts. It works and I can’t thank you enough for helping me out. I truly appreciate it.
Thank you!
Bryan

Hi @anmise 

All of them were flagged as main, I think it has something to do with one contact, as every BO email that failed had the same contact. It might be because they have a weird email (rocketmail) but that contact was a test contact anyways so I’ll take it! Thanks again : )

For a related question, what would be the API call for getting the contact name (first or full name) or the company name? 

Again, thank you so much for all of the help, you are amazing.
Bryan