How to read an xml file and update in a datatable using file listener
Hi,
I have requirement like I need to read the xml file (eg: which are having firstname,lastname,address as tag)using file listener from specified location and update the value in a data table. Here how to parse(using parse xml) and map it to clipboard in activity.
Thanks
SorenTara
***Edited by Moderator Marissa to update platform capability tags****
Pegasystems Inc.
US
Hi SorenTara,
To read XML files you can configure File Listener rule as follows:
In Properties tab -> under Source properties -> enter Source name mask as *.xml
You can use an asterisk as a wildcard match.
For example, BA*.xml causes the system to find all files with type of XML that start with the two letters BA.
If you leave this blank or use a mask of *.*, the listener selects every file in the directory identified in the Source location field (skipping over any files that are themselves directories).
To update in a datatable, you can try using a function: pxConvertStringToPage in the Service activity.
Remember you need to save the page after converting, so that a record gets added to the datatable.
Hope this helps!
Let me know if you have any questions.
Thanks.
Swedbank AB
SE
You can import xsd of that xml in some integration class and refer the generated xmlparse rule in service file in parsesegments in request tab.
Cognizant Technology Solutions
IN
Hi Deva,
I'm generating Parse xml rule from service file where taking three elements along with root(eg: id,fname,lname) and values for all these passing by uploading xml file in file listener,here my question is how to map aal these properties value in clipboard using activity.correct me if I'm wrong.
Can't it possible without importing xsd.
Regards,
SorenTara