Qlik REST Connector - CDATA section

Tue, 16 May 2017 14:00:41 GMT

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>

<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

Re: Qlik REST Connector - CDATA section

Anonymous — Mon, 10 Aug 2020 09:38:19 GMT

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.

topic Re: Qlik REST Connector - CDATA section in QlikView

Qlik REST Connector - CDATA section

Re: Qlik REST Connector - CDATA section