OriginalPostID-255853
Discussion posts and replies are publicly visible
That seems to be the standard with record type data. Did you try to cast the data to maps?
cast( type!Map, <your data> )
much better now!
last to remove are the "xsi:type" data and the
<n1:root xmlns:n1="root2" xmlns:a="">www.appian.com/.../2009" xmlns:xsd="">www.w3.org/.../XMLSchema" xmlns:xsi="">www.w3.org/.../n1:root>
<n1:root xmlns:n1="root2" xmlns:a="">www.appian.com/.../2009" xmlns:xsd="">www.w3.org/.../XMLSchema" xmlns:xsi="">www.w3.org/.../XMLSchema-instance">
<one xsi:type="a:Map">
<two xsi:type="xsd:dateTime">2024-02-27T16:13:19.700Z</two>
</n1:root>
possible with parameters only?
Use regular expressions in order to remove the namespaces from the resulting xml, for example
\sxmlns[^"]+"[^"]+"
thanks David,
Could you please give a more detailed example?
I am not too familiar with regular expressions in Appian
like how to remeove the header and footer from previous generated xml
<n1:root xmlns:n1="root2" xmlns:a="">www.appian.com/.../2009" xmlns:xsd="">www.w3.org/.../XMLSchema" xmlns:xsi="">www.w3.org/.../
n1:root>
thanks
Regexes in Appian are not different to other languages. Get the plugin installed and check stackoverflow or other resources.
a!localVariables( local!valor: "<n1:root xmlns:n1=""root2"" xmlns:a="">www.appian.com/.../2009"" xmlns:xsd="">www.w3.org/.../XMLSchema"" xmlns:xsi="">www.w3.org/...></n1:root>", regexreplaceall("\sxmlns[^""]+""[^""]+""", local!valor, "") )
Try this....
Thanks a lot