Microsoft Dynamics 365 | Integration, Dataverse...

How to escape an apostrophe in addCustomFilter Client API function

(0) Share

Report

Posted on by SheaLeonard

Hi All,

I am having some issues attempting to escape an apostrophe whilst using the addCustomFilter Client API function.

I have tried a number of different methods but continue to get "Invalid XML Format" error message. I was able to successfully escape an ampersand character using &amp.

Here are some of the things I have tried:

Using ' to escape the apostrophe.
Using &39; to escape the apostrophe.
Built a string variable into fetch xml but still getting the same issue.
Instead of using equal to in the fetch query I used contains but still getting the error message.
Tried escaping using HTML character references - still no luck.

Has anyone experienced this issue before?

Thanks,

Shea

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

RodRodriguez on at

Like (0)

Report
Copy link

Link copied!

Howdy!

I believe you are looking for this:

'

docs.oracle.com/.../obcCustomXml.htm

Also here is the Microsoft docs as well:

docs.microsoft.com/.../xml-character-entities

Was this reply helpful? Yes No
SheaLeonard 5 on at

Like (1)

Report
Copy link

Link copied!

Hi Rod,

Thanks for your reply.

Unfortunately I have also tried this and to no avail (including the #). To get around it I have had to find that record by GUID in the filter query.

Thanks,

Shea

Was this reply helpful? Yes No
Goksel oral 25 on at

Like (0)

Report
Copy link

Link copied!

Have you tried the method - System.Security.SecurityElement.Escape(string) to replace those and other methods mentioned below

weblogs.sqlteam.com/.../

Was this reply helpful? Yes No
SheaLeonard 5 on at

Like (0)

Report
Copy link

Link copied!

This is JavaScript issue and not C# but thanks for the response.

Was this reply helpful? Yes No