How to Read .xml File values in Sourcing CLM Scripts

[Former Member]

Hi All,

We have a Import LifeCycle Script (Pre-Process_Row) in which we need to read the xml files and replace the values if those are blank. Below is the sample xml file.

We were able to get the Values from <REGION_ID> tag, But we are unable to get value which is under <NAME> tag.

Below is the Logic we used.

DisplayName = import_record.getImportField("NAME").getValue();

Description = import_record.getImportField("DESCRIPTION").getValue();

RegionID = import_record.getImportField("REGION_ID").getValue();

We were able to get the Value from REGION_ID tag as "00".

And we are expecting to get value from "NAME" tag as "Catal Feral" But above logic is retrieving null value.

Can any of you please help me to how to get the NAME tag value.

BR//

Santhoshi