locked
SDK.REST.retrieveMultipleRecords and $filter unterminated string literally error RRS feed

  • Question

  • Hi,

    I'm from Italian and here we have city names having special characters such as the '. For example, we have a city called FORLI'. When I try to use the retrieveMultipleRecords method with the $filter=city eq 'FORLI%27' (%27 is the encoded code for the ') I retrieve the error: Bad Request 400: unterminated string literally at position xx in 'city eq 'FORLI'''.

    Also, I tried to replace the string containing the city name in this way .replace("'", "\'"); with no success.

    Any suggestion?

    Thanks

    Wednesday, September 24, 2014 2:36 PM

Answers

  • Try using '' instead of ' e.g. FLORI''S.

    Saad

    • Marked as answer by Bltfast Thursday, September 25, 2014 7:56 AM
    Thursday, September 25, 2014 7:18 AM

All replies

  • try html. Encoding &#39 for a single quote and let me know if it works.

    regards

    Jithesh

    Wednesday, September 24, 2014 9:25 PM
  • Try using '' instead of ' e.g. FLORI''S.

    Saad

    • Marked as answer by Bltfast Thursday, September 25, 2014 7:56 AM
    Thursday, September 25, 2014 7:18 AM