Parker Software Ltd Homepage
Forum Home Forum Home > ThinkAutomation Business Process Automation > General
  New Posts New Posts RSS Feed - Issue with processing azure email
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Issue with processing azure email

 Post Reply Post Reply
Author
Message
mitesh281 View Drop Down
Professional
Professional
Avatar

Joined: 24 Feb 2009
Location: India
Points: 71
Post Options Post Options   Thanks (0) Thanks(0)   Quote mitesh281 Quote  Post ReplyReply Direct Link To This Post Topic: Issue with processing azure email
    Posted: 18 Jun 2020 at 8:22am
Hi,

I am inserting the email body part which I receive from azure. I am using %msg_body% inbuilt variable to insert plain text from azure html formatted email. It was working fine however since last two days %msg_body% is not collecting plain text instead it gives a message "Plain-text emails are not supported at this point." Any reason why msg_body gives that message instead of plain text of email?

Any help will be appreciate.

Thank you,
Mitesh
Back to Top
Liam View Drop Down
Admin Group
Admin Group
Avatar

Joined: 29 Jun 2011
Location: Stoke-on-Trent
Points: 268
Post Options Post Options   Thanks (0) Thanks(0)   Quote Liam Quote  Post ReplyReply Direct Link To This Post Posted: 12 Nov 2020 at 11:30am
Hi Mitesh

This will most likely be because Microsoft stopped sending the emails with a proper plain text portion.
you'd need to rethink your triggers in this scenario.
%msg_html% contains the html portion but you will need to consider how to handle the HTML formatting in your processing.

To allow TA to perform field extractions from msg_html you can one of two things
1. In the first trigger use the Pass To action and pass the msg_html onto another trigger, this other trigger will then perform your actual email processing and trigger extractions
2. You can use the trigger conditions script to run this line of code
MSG_Body = MSG_HTML
This will place the html content into the body, so that your field extraction can extract from the html portion of the email

Important note, when extracting from the HTML portion, you need to be aware of HTML tags and how that is going to impact your extractions
Back to Top
benv View Drop Down
New User
New User


Joined: 25 Feb 2021
Location: London
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote benv Quote  Post ReplyReply Direct Link To This Post Posted: 26 Feb 2021 at 2:32pm
Hi Liam

I had  similar issue as above, the information I wanted to collect from the email only seemed to be visible in the html version. I tried your option 2 above and this almost worked. It works when I reprocess a message, but not to the message as it comes in. Do you have any ideas why this might be?

Cheers

Ben
Back to Top
Ollie View Drop Down
New User
New User
Avatar

Joined: 12 Nov 2020
Location: Staffordshire
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote Ollie Quote  Post ReplyReply Direct Link To This Post Posted: 26 Feb 2021 at 3:00pm
Originally posted by benv benv wrote:

Hi Liam

I had  similar issue as above, the information I wanted to collect from the email only seemed to be visible in the html version. I tried your option 2 above and this almost worked. It works when I reprocess a message, but not to the message as it comes in. Do you have any ideas why this might be?

Cheers

Ben


From my understanding it's to do with how Microsoft handles emailing now, as Liam said, usually without a proper portion of the email in 'plain text'.

As such, ThinkAutomation can't read from the message and will need some effort to do so, for example passing the HTML to another trigger and going from there, as above.

I hope that makes sense!
Back to Top
benv View Drop Down
New User
New User


Joined: 25 Feb 2021
Location: London
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote benv Quote  Post ReplyReply Direct Link To This Post Posted: 27 Feb 2021 at 9:46pm
Hi Ollie

Thank you for your reply. Yes I understood the issue and had successfully implemented Liam's second option, I have since tried the first and it also reads the data from the html email correctly.

The issue I am having is that since the format of these emails changed, new emails delivered into my email account are no longer getting picked up by the triggers for this account.

Interestingly if I make a change to a trigger (even if it is just deleting and retyping the same from email address) when I save the changes any new emails in my email account are picked up and processed correctly.

So the triggers are obviously set up correctly (from address / text in subject) but when the software checks for new messages it marks them as read and adds them to the message store, but without activating the trigger.

As I said this has only started happening since the emails changed format showing limited text in the plain text part of the email.

I hope that makes sense and any advice would be appreciated!

Cheers

Ben
Back to Top
benv View Drop Down
New User
New User


Joined: 25 Feb 2021
Location: London
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote benv Quote  Post ReplyReply Direct Link To This Post Posted: 05 Mar 2021 at 11:25am
Hello

Just to simplify the issue I described above - to get this software to process the emails I have to go into the trigger, make a random change and click Save while the emails are unread an unprocessed in my email folder. 

If I just wait for the software to process them automatically it just marks the emails as read, and adds them to the message store with folderID "-". It doesn't process them.

Does anyone have any ideas?

Cheers

Ben
Back to Top
Liam View Drop Down
Admin Group
Admin Group
Avatar

Joined: 29 Jun 2011
Location: Stoke-on-Trent
Points: 268
Post Options Post Options   Thanks (0) Thanks(0)   Quote Liam Quote  Post ReplyReply Direct Link To This Post Posted: 05 Mar 2021 at 4:16pm
Hi Ben

I'm not sure what might be going on here.
if you have TA move the mails to another folder, at the account level.
And then have a second account and trigger read this folder, does it make any difference?

Also, if you set the logging level to "Debug", do you see anything in the Edge Server log which might suggest why the emails aren't being processed?
Back to Top
benv View Drop Down
New User
New User


Joined: 25 Feb 2021
Location: London
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote benv Quote  Post ReplyReply Direct Link To This Post Posted: 12 May 2021 at 9:11am
I figured this out in case anyone else has this issue.. I had two accounts with completely different triggers, but they were both looking for emails in the same email folder. When the first account ran it marked all the emails as read and so when the second account ran it didn't pick up the emails. It only did if I forced it to run by making a change and saving - because it ran on it's own without the previous account running first.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.05
Copyright ©2001-2016 Web Wiz Ltd.

This page was generated in 0.098 seconds.