Handle apostrophe (') in xml response of REST Api call

[Supriya39]

Hello All,

We have SSIS packages with which we are doing GET call to servicenow REST API and the source produces JSON as result. 

The issue we are having is whenever any value with apostrophe appears json result is getting distrubed. 

For e.g if value of location column is as below:

"location":{
"display_value":"ABCDFG'S " } the JSON gets distubed and eventually error out as below 

"error":{"message":"Transaction cancelled: maximum execution time exceeded","detail":"maximum execution time exceeded Check logs for error trace or enable glide.rest.debug property to verify REST request processing"},"status":"failure"}

Please let me know how this can be handled.

Thanks in advance.

[Service_RNow]

HI @Supriya39 

Please follow thread it will be helpful

How to read XML server response 

how-to-parse-xml-response-from-api 

Please mark reply as Helpful/Correct, if applicable. Thanks!

[shubhamdubey]

@Supriya39 

Check this article

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0748767

Use this method 

setStringParameterNoEscape(String name, String value).

https://www.servicenow.com/community/now-platform-forum/setstringparameter-vs-setstringparameternoes...

[Supriya39]

Actually we are using a REST API tool from Task Factory and not using any javascript. I Wanted to check if from source this can be handled?