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

All responses (4)

Answers (0)

SheaLeonard 5 on at

Like (0)

Report

RE: How to escape an apostrophe in addCustomFilter Client API function

This is JavaScript issue and not C# but thanks for the response.
Goksel oral 25 on at

Like (0)

Report

RE: How to escape an apostrophe in addCustomFilter Client API function

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

weblogs.sqlteam.com/.../
SheaLeonard 5 on at

Like (1)

Report

RE: How to escape an apostrophe in addCustomFilter Client API function

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
Suggested answer

RodRodriguez on at

Like (0)

Report

RE: How to escape an apostrophe in addCustomFilter Client API function

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