Get Outlook Mail Messages: Cannot parse condition. Error at "@SQL=(( urn:schemas:httpmail:subject LIK..."

[schoi]

Hi
I am trying to get emails using the Get Outlook Messages using a filter.
Using Windows Legacy. Running 2023.10.7
When in test environment the email can be found but when in our live environment keep getting this message in Orchestrator logs, Get Outlook Mail Messages: Cannot parse condition. Error at “@SQL=urn:schemas:httpmail:subject LIKE’%…”.
Any thoughts?
Thanks
Sum

[lrtetala (Lakshman Reddy)]

Hi @schoi

Try this

"@SQL=""urn:schemas:httpmail:subject"" like '%business analyst%'"

Activities - Get Outlook Mail Messages

Regards,

[vrdabberu (Varunraj Dabberu)]

Hi @schoi

Check the below thread:

Get outlook mail message - Add variable in subject filter condition

@Kapil , After a Copy paste from here . Manually replace Double Quotes with Double Quaotes and Single Quaotes with single Quote because copy paste gives the below [image] and uipath expects [image] It should look Like [image] Mukesh

Regards

[schoi]

Hi both,
I’ve tried both of these methods above, thanks. It’s very peculiar as able to grab an email elsewhere outside of the production environment.
Previously the logs showed like this Get Outlook Mail Messages: Cannot parse condition. Error at “@SQL=((”“urn:schemas:httpmail:subject”" …". when I used the double quotes.
Would prefer to use this as a config item so don’t have to amend in the build. @SQL=urn:schemas:mailheader:subject LIKE ‘%+in_strTradingAs+%’ is what has been working in my test environment
Any other thoughts?

[lrtetala (Lakshman Reddy)]

@schoi

Can you try like below

"@SQL=""urn:schemas:httpmail:subject"" like '%" & Filter & "%'"

Regards,

[schoi]

Afraid this also doesn’t work.
Any way I can filter without @SQL?

[lrtetala (Lakshman Reddy)]

@schoi

@schoi

Afraid this also doesn’t work.

In my case it is working.Can you show the screenshot how you are trying

Can you try this

[Subject] = 'Product Roadmap

Regards,

[lrtetala (Lakshman Reddy)]

@schoi

@schoi

Any way I can filter without @SQL?

Try this

FilteredMails = RetrievedMails.Where(Function(mail) mail.Subject.Contains(Filter)).ToList()

Regards,

[schoi]

Will give this a try - thanks

[lrtetala (Lakshman Reddy)]

@schoi

If you got the solution for your question.Please mark it as solution to close the thread.So it will be helpful for others.

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

Regards,

[schoi]

Thanks all for your input.
I’ve had to do a different method.

• mailMessages (List of MailMessage): The list of emails retrieved.
• filteredEmails (List of MailMessage): The list to store filtered emails.
• filteredEmails = New List(Of MailMessage)
• If activity to subject.contains or body.contains
• in THEN branch - For Each
• Invoke Method
• • TargetObject: filteredEmails`
• MethodName: Add
• Parameters: item
• TESTED * - and working