How Do I Escape an Apostrophe in a REST API Query?
I am trying to write a REST API query that looks like this:
https://<server>:<port>/ccm/rpt/workitem?fields=workitem[projectArea/name="Nate's Sandbox Area"]/*
If the project area name does not have an apostrophe in it, this works fine. As soon as I put the apostrophe in there, I get zero results. The page doesn't display an error or complain about a badly formatted request, I just get a page with zero results.
How do I correctly escape an apostrophe in this scenario?
One answer
[projectArea/name="Nate''s Sandbox Area"]
Comments
Unfortunately I tried that as well. I could list all the things that I tried for what it's worth:
"Nate's Sandbox Area"
(Nate's Sandbox Area)
<Nate's Sandbox Area>
<"Nate's Sandbox Area">
"Nate''s Sandbox Area"
"Nate\'s Sandbox Area"
"Nate%'%s Sandbox Area"
"Nate%27s Sandbox Area"
A few other permutations as well... I've decided the guess-and-check approach will be fruitless here.
Comments
Donald Nong
Sep 04 '14, 9:48 p.m.I have done some debugging and it appears that the application cannot handle the apostrophe sign in a query correctly - the term becomes an empty string when it is passed to the server. I suggest you open a support ticket to get it investigated further.