I am having process model which scheduled to run after every hour and get XML response from external system and storing into text type pv.
XML data in nested CDT format.
Now, We want to read that XML file into Appian CDT. For reference i am giving below XML response.
<variable type="InputBO"> <paymentInfo type="PaymentBO"> <operationType type="String">CAPTURE</operationType> <channelId type="String">AAA</channelId> <paymentTypeCode type="String">BBB</paymentTypeCode> <referenceNumber type="String">ABCD145891</referenceNumber> <paymentAmount type="Decimal">515.0</paymentAmount> <paymentCurrency type="String">GBP</paymentCurrency> <paymentCardDetails type="PaymentCardDetailsBO"> </paymentInfo></variable>
Could you please help me to achieve this task? Thanks for your support in advance.(Appian version 18.1)
Discussion posts and replies are publicly visible
Hi Vinod,
As if now we do not have any shared component that can do it for you. There are two ways to achieve it.
1. Use Extract each of the parameter and initialize CDT columns from that.
2. Create a Java plugin that can parse the given pattern and return data in either JSON format or CDT type.