How do I remove special characters from a text field that cause SOAP to fail

[devra_a_komenda]

I am attempting to transfer a primary item Title to an external system using an Orchestration. I have run into a problem with special characters being in the Text fields causing the orchestration to fail due to an XML constraint. Within the Orchestration is there a way to scan and replace all special characters within the orchestration? Is there a way to put a CDATA block around the title field.

[PM Thompson]

Just a guess ... try disabling "rich text" for the text fields.

[devra_a_komenda]

I found a solution from another post that requires you loop through the field and CONCAT(SUBSTRINGBEFORE(Title,"/"),"-",SUBSTRINGAFTER(Title,"/")) and reset field in loop replacing all the special characters. I do this for all the text fields passed. Thankfully, with this particular integration I only had to replace the "/" .

Thanks for your contribution though!