' character in string parameter of Odata Url

Question

Hmmm this seems silly, so I feel silly. I have a custom operation on an Odata service which has a string parameter. It works fine when the string contains no special characters, but as soon as I include the ['] character I get:

<?xml version=\"1.0\" encoding=\"utf-8\" standalone=\"yes\"?>\r\n<error xmlns=\"http://schemas.microsoft.com/ado/2007/08/dataservices/metadata\">\r\n  <code></code>\r\n  <message xml:lang=\"en-US\">Bad Request - Error in query syntax.</message>\r\n</error>

I am invoking the service with the following code:

new DataServiceContext(new Uri(svcUri)).Execute<string>(new Uri(relativeOperationUrl, UriKind.Relative));

I've tried encoding like this [& apos;] (xml encoding) and like this [%27] (url encoding) and the things is still blowing up.

possible duplicate of [How to escape a single quote to be used in an OData query?](http://stackoverflow.com/questions/3979367/how-to-escape-a-single-quote-to-be-used-in-an-odata-query) — Jeremiah Willcock, Mar 06 '11 at 06:43
Yeah sorry didn't find that question, it seems to be the same thing. — Jonathon Kresner, Mar 07 '11 at 05:20

score 2 · Accepted Answer · edited May 23 '17 at 11:55

2

Try '' (like escaping it for SQL); see How to escape a single quote to be used in an OData query?.

edited May 23 '17 at 11:55

Community

1
1

answered Mar 06 '11 at 06:28

Jeremiah Willcock

30,161
7
76
78

' character in string parameter of Odata Url

1 Answers1