Skip to main content Haga nuestra encuesta de 5 minutos de la comunidad. Ábrala ya hasta el 11/4/2025. Haga clic aquí para participar.
Topics#ApexPregunta de Bryan Telford
Bryan Telford (First Choice Loan Services Inc) ha preguntado en #Apex
1 mar 2016, 8:14

Parsing repeating xml nodes

Does anyone know how to use the XML DOM to parse repeating nodes of XML? For example, let's say I have the following section.

        <_CREDIT_SCORE>

                <_CREDIT_SCORE _CreditScore="668" _ReportingAgency="Experian"/>

                <_CREDIT_SCORE _CreditScore="658" _ReportingAgency="TransUnion"/>

                <_CREDIT_SCORE _CreditScore="660" _ReportingAgency="Equifax"/>

            </_CREDIT_SCORE>

I need to use the DOM to parse the first _CREDIT_SCORE element, then the second, and third. Ultimately, I need the get the values of the attributes inside each _CREDIT_SCORE node.

The Salesforce documentation provided doesn't seem to have a way to do this. For example, using getChildElement will always return the first element. I need to be able to read each _CREDIT_SCORE.  

I've been struggling with this for weeks. It seems like it should be a fairly easy task, but using the DOM provided by Salesforce, there doesn't seem to be a way to get to the subsequent nodes after the first. Perhaps I've missed something in my reading of the documentation, or perhaps there is another way altogether. 

Thanks for any help!

 
2 respuestas
  1. Patrick Connelly (Red Hat)
    2 mar 2016, 2:18
    You can do this by iterating the XMLNodes using getChildElements

     

    String xmlData = '<?xml version="1.0"?>' +
        '<_CREDIT_SCORE>' +
        '  <_CREDIT_SCORE _CreditScore="668" _ReportingAgency="Experian"/>' +
        '  <_CREDIT_SCORE _CreditScore="658" _ReportingAgency="TransUnion"/>' +
        '  <_CREDIT_SCORE _CreditScore="660" _ReportingAgency="Equifax"/>' +
        '</_CREDIT_SCORE>';
    Dom.Document doc = new Dom.Document();
    doc.load(xmlData);
    for (Dom.XmlNode node : doc.getRootElement().getChildElements()) {
        System.debug(node.getAttributeValue('_ReportingAgency', ''));
    }

    You can use the .getName() on the node to verify that you are in _CREDIT_SCORE
Cargando
Escribir una respuesta...
0/9000