I an external service which is sending escaped xml as a string e.g. <tag&

joel671 over 8 years ago

I an external service which is sending escaped xml as a string e.g. <tag>myValue</tag> (<tag>myValue</tag>)
We are then converting this using torecord which puts it into a CDT with no issues
This is working fine except in one circumstance when a < is passed in as part of the value. e.g. <tag>my < Value</tag> obviously this is now causing the xml to be misinformed. I cannot get the system sending the information to change the data being sent. All other special character are working fine with this single escaping but the < is causing the torecord to fail. I can't create rules to find each element as there are quite a lot and it would be very complicated is there any way of finding and replacing only those < values within a tag? So we can deal with it within Appian before converting torecord.

Discussion posts and replies are publicly visible

0 Tom Ryan
Appian Employee
over 8 years ago

One approach would be to use regex via the regular expression function plugin. This way you should be able to replace the problematic characters as required:

forum.appian.com/.../summary
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sagarl511
A Score Level 2
over 8 years ago

Other approach can be using <![CDATA[]] for the value which contains xml specific characters. For example -

torecord("<employee><title><![CDATA[<John>]]></title></employee>",ri!test)

returns -
[id=, title=<John>, RP_status=, RP_priority=, folderId=, createdBy=, createdOn=, updatedBy=, updatedOn=]

If you receive your xml with values in CDATA tag then it might solve your issue.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 joel671 over 8 years ago

Thanks Tom and sagarl511.

@sagarl I can't get CDATA to work becuase I need it at the parent level e.g.

torecord("<![CDATA[<employee><title><John</title></employee>]]>",ri!test) I have no idea of knowing which field the value may be in and it would be very resource heavy doing this at a field level. But good suggestion.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

I an external service which is sending escaped xml as a string e.g. &lt;tag&

I an external service which is sending escaped xml as a string e.g. <tag&