How to deal with special characters in rest parameter values

Question

I am working on REST call. Everything works fine but my column contains special character &

So rest call like below works:

http://mydomain/_api/web/lists/GetByTitle('MyList')/Items?$filter=ColumnA eq 'DAD'

But below fails:

http://mydomain/_api/web/lists/GetByTitle('MyList')/Items?$filter=ColumnA eq 'D&D'

I dont want to change my column values now. Any solution?

Check this - social.msdn.microsoft.com/Forums/en-US/…
– Vishnu S
Aug 3, 2018 at 10:39 — Vishnu S, Aug 3, 2018 at 10:39

Gennady G · Accepted Answer · 2018-08-03 10:28:51Z

2

Use something like this:

"http://mydomain/_api/web/lists/GetByTitle('MyList')/Items?$filter=ColumnA eq " + encodeURIComponent("D&D")

answered Aug 3, 2018 at 10:28

Gennady G

1,6233 gold badges21 silver badges34 bronze badges

Thank you Gennady for the answer. I tried entering the same in my browser URL and it did not work
– Joy D'souza
Aug 3, 2018 at 10:59
Not at all. Try type additional quotes?.. "mydomain/_api/web/lists/GetByTitle('MyList')/… eq " + encodeURIComponent("'D&D'")
– Gennady G
Aug 3, 2018 at 11:43

Add a comment |

lazoDev · Accepted Answer · 2018-08-03 14:05:27Z

1

Perhaps try putting the encoded value in directly. Have you tried something like this yet:

"http://mydomain/_api/web/lists/GetByTitle('MyList')/Items?$filter=ColumnA eq 'D%26D'"

answered Aug 3, 2018 at 14:05

lazoDev

1,80614 silver badges20 bronze badges

Add a comment |

Rohit Waghela · Accepted Answer · 2018-08-03 18:17:59Z

0

encodeURIComponent should work. I have been using this method and it always works for me. You have to add D&D in quotes.

Try below URL. Just a little modification from @Gennady G's URL(i.e. quotes are added around the filter value) :

"http://mydomain/_api/web/lists/GetByTitle('MyList')/Items?$filter=Title eq '" + encodeURIComponent("D&D") + "'"

answered Aug 3, 2018 at 18:17

Rohit Waghela

2,9082 gold badges16 silver badges31 bronze badges

Add a comment |

3 Answers 3