Deserialize XML from SOAP

Hi everyone, I am getting this response from a HTTP Request and I would like to build a DataTable with some information about the “Documents”. But I am not able to access to the XElement “EncargoIntegrarDatos”. Any help?

Thank you!!

<soap-env:Envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/">
  <soap-env:Header />
  <soap-env:Body>
    <n0:EncargoIntegrarDatosIntegrarFicherosReadByIDResponse_sync xmlns:n0="http://sap.com/xi/SAPGlobal20/Global" xmlns:prx="urn:sap.com:proxy:JNU:/1SAI/TASF831AE28C85FD1DAF720:804">
      <EncargoIntegrarDatos>
        <SAP_UUID>fa163ebf-bd26-1edd-94a9-2c908250578f</SAP_UUID>
        <IntegrarFicheros>
          <UUID>fa163ebf-bd26-1edd-94a9-2c908252978f</UUID>
          <Document>
            <UUID>fa163e99-1e46-1edd-9782-bda9c6e25d93</UUID>
            <SystemAdministrativeData>
              <CreationDateTime>2022-11-04T07:54:36.440917Z</CreationDateTime>
              <CreationIdentityUUID>fa163ed8-c0b4-1edc-bae5-537579202c28</CreationIdentityUUID>
              <LastChangeDateTime>2022-11-04T07:54:39.142473Z</LastChangeDateTime>
              <LastChangeIdentityUUID>fa163ed8-c0b4-1edc-bae5-537579202c28</LastChangeIdentityUUID>
            </SystemAdministrativeData>
            <VisibleIndicator>true</VisibleIndicator>
            <CategoryCode>2</CategoryCode>
            <CategoryName>Document</CategoryName>
            <TypeCode>10001</TypeCode>
            <TypeName>Standard Attachment</TypeName>
            <MIMECode>text/csv</MIMECode>
            <MIMEName>Java Archive</MIMEName>
            <PathName>/BOAttachments/FA163EBFBD261EDD94A92C908252978F/SolicitudesAbiertas_20221019.csv</PathName>
            <Name>SolicitudesAbiertas_20221019.csv</Name>
            <AlternativeName>SolicitudesAbiertas_20221019.csv</AlternativeName>
            <FileContentURI>http://vhbydjnuai03.byd01.fra.byd.net.sap:50000/sap/ap/ds/wd/doc/FA163E991E461EDD9782BDA9C6E25D93/SolicitudesAbiertas_20221019.csv?sap-client=074&amp;Ctxt=WTBUTVBXNDNZX0VOT1M5MkFBNDNGOEI2MDdDMURFOklOVEVHUkhFUk9TNzRFREE1Q0ZEMEEwRTI4Mw==&amp;Shm=FA163E991E461EDD9782BDA9C6E25D93</FileContentURI>
            <FilesizeMeasure unitCode="AD">2969.0</FilesizeMeasure>
          </Document>
          <Document>
            <UUID>fa163e99-1e46-1edd-9782-bda9c6e29d93</UUID>
            <SystemAdministrativeData>
              <CreationDateTime>2022-11-04T07:54:36.488455Z</CreationDateTime>
              <CreationIdentityUUID>fa163ed8-c0b4-1edc-bae5-537579202c28</CreationIdentityUUID>
              <LastChangeDateTime>2022-11-04T07:54:39.142473Z</LastChangeDateTime>
              <LastChangeIdentityUUID>fa163ed8-c0b4-1edc-bae5-537579202c28</LastChangeIdentityUUID>
            </SystemAdministrativeData>
            <VisibleIndicator>true</VisibleIndicator>
            <CategoryCode>2</CategoryCode>
            <CategoryName>Document</CategoryName>
            <TypeCode>10001</TypeCode>
            <TypeName>Standard Attachment</TypeName>
            <MIMECode>text/csv</MIMECode>
            <MIMEName>Java Archive</MIMEName>
            <PathName>/BOAttachments/FA163EBFBD261EDD94A92C908252978F/Intervinientes_20221019.csv</PathName>
            <Name>Intervinientes_20221019.csv</Name>
            <AlternativeName>Intervinientes_20221019.csv</AlternativeName>
            <FileContentURI>http://vhbydjnuai03.byd01.fra.byd.net.sap:50000/sap/ap/ds/wd/doc/FA163E991E461EDD9782BDA9C6E29D93/Intervinientes_20221019.csv?sap-client=074&amp;Ctxt=WTBUTVBXNDNZX0VOT1M5MkFBNDNGOEI2MDdDMURFOklOVEVHUkhFUk9TNzRFREE1Q0ZEMEEwRTI4Mw==&amp;Shm=FA163E991E461EDD9782BDA9C6E29D93</FileContentURI>
            <FilesizeMeasure unitCode="AD">4464.0</FilesizeMeasure>
          </Document>
        </IntegrarFicheros>
      </EncargoIntegrarDatos>
      <Log />
    </n0:EncargoIntegrarDatosIntegrarFicherosReadByIDResponse_sync>
  </soap-env:Body>
</soap-env:Envelope>

Hi @ajgb

please use the DE serialize xml activity which will give you the desired output

subsequently can use get xml nodes activities and loop through all the data

cheers

Yes I know that activity, but I am not able to access to the deserialized content. It seems that is not as simple as a deserializeXML.Element(“Body”)….

1 Like

Hi @ajgb

Can you provide a sample file so that it would be easy to check

And if its complex xml then you need to deserialize multiple times by getting the value from output and passing back to another deserialize activity

This might help

cheers

Have a look here where it is elaborating on how to handle XML Namespaces:

1 Like