Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Is there anyone who has experience with CDATA sections in an XML response?
I am trying to fetch a table from a webservice with the Qlik REST Connector. I have tested this with SOAP UI and I can succesfully fetch data, but the data that I need is embedded in a CDATA section. When fetching this data with Qlik REST Connector it does not recognize this section and only fetches meta-data.
Example of XML response:
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
<GetDataResponse xmlns="urn:Afas.Profit.Services">
<GetDataResult><![CDATA[<AfasGetConnector><xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"><xs:element name="AfasGetConnector"><xs:complexType><xs:choice maxOccurs="unbounded"><xs:element name="QVGC"><xs:complexType><xs:sequence><xs:element name="werkgevercode" type="xs:string" minOccurs="0"/><xs:element name="achternaam" type="xs:string" minOccurs="0"/><xs:element name="voornaam" type="xs:string" minOccurs="0"/></xs:sequence></xs:complexType></xs:element></xs:choice></xs:complexType></xs:element></xs:schema><Qlikview_medewerkers><werkgevercode>01</werkgevercode><achternaam>Some last name</achternaam><voornaam>Some first name</voornaam></Qlikview_medewerkers>]]></GetDataResult>
</GetDataResponse>
</soap:Body>
</soap:Envelope>
So the actual table should be:
Werkgevercode | Achternaam | Voornaam |
---|---|---|
01 | Some last name | Some first name |
How can I get the actual table in QlikView that is now within this CDATA section?
Thanks in advance!
Best regards,
Joost
I suggest not to use SOAP/XML, but to use REST/JSON. You can test this on https://connect.afas.nl where you can test your connectors defined in AFAS on your own live data.
the [CDATA] means that the XML you're looking for is encapsulated within as an string response, rather than a normal XML format.