Deserialize XML from SOAP

[ajgb]

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>

[Anil_G (Anil Gorthi)]

Hi @ajgb

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

Deserialize XML

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

cheers

[ajgb]

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”)….

[Anil_G (Anil Gorthi)]

@ajgb

Element

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

XML Parse

Hi @mikamol Find the attached sample Main.xaml (8.1 KB) that is showcasing following: Retrieving all Field elements Retrieving all Id elements (Parent is Field) Retrieving the particular Answer Value for a particular Id As this XML is defining the namespace:` xmlns="urn:abou:documents:ka:Case The Root element Name is not Case it is: e.g. urn:abou:documents:ka:Case:Case So the namespace part is to take into account Solved with using namespace manager Kindly note the order from a XML Docu…

cheers

[ppr (Peter Preuss)]

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

XML Extraction - Handling Namespaces (Tableau, Soap, OASIS types)

Going ahead Serializing the XML - output: xDoc | DataType: XDocument: [grafik] Checking if we have to handle XML namespaces [grafik] We do have: [grafik] Checking for some children: [grafik] Defining Namespace Variable [grafik] In some cases, we can also do: Assign Activity - xnsDefault = xDoc.Root.Name.Namespace Checkin the retrieval [grafik] xDoc.Descendants(xnsDefault + "productVersion") GetDescendants { [<productVersion build="456" xmlns="http://tableau.com/api">123</…