Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik REST Connector - CDATA section

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:

WerkgevercodeAchternaamVoornaam
01Some last nameSome first name

How can I get the actual table in QlikView that is now within this CDATA section?

Thanks in advance!

Best regards,

Joost

1 Reply
rolandraijmaker
Contributor II
Contributor II

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.