How to pass special characters & '# in filter query in get mail activity of msoffice 365 package

Help Activities
1

Special characters like & '# throws incorrect filter clause error. Rest special characters are working through query.

Email subject - Xyz subject ab@@ab test
“contains (subject ‘ab@@ab’)”
Working fine

Email subject- Xyz subject ab&‘#ab test
"contains (subject ‘ab&’ #ab’)"
Error

1 Like
2

Thanks Harsh
Really looking for this solution.

3

Hi @harshbansal0701

Please use uriencoding and use it…that should solve the issue

Cheers

4

Kindly share one example that helps.

5

Hi @harshbansal0701

Like this

Replace # with %23

Cheers

6

Hi @harshbansal0701

To be more prescise use this

Convert this
Xyz subject ab&‘#ab test
“contains (subject ‘ab&’ #ab’)”

To This

Xyz subject ab&%26%60%23ab test
“contains (subject ‘ab%26%60%23ab’)”

Please let me know if you face any issue else please mark solution to help others

Cheers