Hello All,
I have build an application where the data entered by users are getting stored inside mssql table. To accomplish this functionality we have used API call, It works fine when the entered values are normal text but if user enters huge number of special characters then the api call is failing. We have third party application to launch api calls manually, When we launch the API with same data from that application, It works fine. Can someone please suggest me a better method to get rid of this issue?
example string: "{}|[]\\%3b':\",.//.,<>?~/*-+!@#$%^&*()_+"
Discussion posts and replies are publicly visible
Hello, By API do you mean a smart service? Regardless, if you do not need the special characters and want to remove them, you can do so by using the stripwith() Appian function, documented here: docs.appian.com/.../fnc_text_stripwith.html
If you can provide more information about the error that is returned, the API, or any other functions involved then I may be able to provide more help.
Thanks,Dylan