Need help on reading XML files

Please elaborate. We need way more details to help and cannot analyze your requirement.

https://codeblog.jonskeet.uk/2012/11/24/stack-overflow-question-checklist/

In general this helps to read XML files

docs.appian.com/.../fnc_scripting_xpathsnippet.html

Hi Stefan ,

Thanks for the reply!

We have one XML file with the claim details and all those claim details to be written in Appian.

How can I read all the XML fields in Appian?

Do I need to create an exact CDT and use Process Model to use this function?

XML:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Intake_ClaimBatch><CreatedDateTimeUTC>2017-12-12T18:02:38.890-05:00</CreatedDateTimeUTC><BatchID>101009</BatchID><ClaimCount>1</ClaimCount><ClaimSystemBatchID>0</ClaimSystemBatchID><ClaimDetails><ClaimMetaData><UniqueClaimID>552300</UniqueClaimID><GlobalIntakeID>0</GlobalIntakeID></Intake_ClaimBatch>

Hi Stefan ,

Thanks for the reply!

We have one XML file with the claim details and all those claim details to be written in Appian.

How can I read all the XML fields in Appian?

Do I need to create an exact CDT and use Process Model to use this function?

XML:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Intake_ClaimBatch><CreatedDateTimeUTC>2017-12-12T18:02:38.890-05:00</CreatedDateTimeUTC><BatchID>101009</BatchID><ClaimCount>1</ClaimCount><ClaimSystemBatchID>0</ClaimSystemBatchID><ClaimDetails><ClaimMetaData><UniqueClaimID>552300</UniqueClaimID><GlobalIntakeID>0</GlobalIntakeID></Intake_ClaimBatch>

Where is the XML coming from? This would probably answer your question whether you need a process model or not.

Regarding reading the XML. I would create an expression which transforms the XML into an Appian CDT. You can do that via toRecord()

https://docs.appian.com/suite/help/21.1/fnc_scripting_torecord.html

or use xPathSnippet/xPathDocument to read each value individually. I would prefer the second way as it provides more flexibility.

This expression can be used in a process or wherever you need.

Thank you Stefan.

I have two requirements:

Appian is fetching from an FTP server and another one we want to read from an XML existing in Local machine.

Thanks

To fetch files you will need a scheduled recurring process.

What do you mean with "local machine"? If this is client, then you need a process with file upload capability in the start form.

Apologies! I meant to say the XML file is already in Appian Folder and then I want to read the xml file to a CDT.

Thanks

Faisal

Then I would try to have three processes. One to fetch files from FTP, one to check for local files, one to do the XML work which will be called by the other two.

Hi Stefan,

Many thanks for your help !

Thanks

Hi Stefan,

Any luck on the solution. I am eager to know how we can implement this. I am a learner and I want to learn appian and needs your suggestions to learn Appian effectively.

Thanks

Then, welcome to the show :-)

What can we help you with? I assume you already know the documentation, academy and play book. If yes, then it would be a good idea to think about a training.

Hi Stefan,

I have completed Appian Training Videos.

I am doing some POCs. In that I had some issues with XML reading.

Waiting for your answer .

I am not sure if you have mentioned some other different kind of Training.

Thanks

Faisal

OK. Maybe I missed it, but what is your question?