topic Re: How to ignore characters (parts) of an XML in QlikView

How to ignore characters (parts) of an XML

chrisssmaia — Fri, 01 Jul 2016 20:52:33 GMT

Good afternoon

I have a url that opens a web page with an XML table. But the first line of that page is a text with a warning that want to ignore, and the second line actually starts the XML. How to load this URL in QlikView and make him ignore this first row, so that only recognize the XML part?

This is the error that displays when I try Qlik direct access URL

If I copy the page content, save in xml and delete the first line, the Qlik recognizes normally.

If want to test, this is the url I am using http://ts.texus.com.br/1263/api/vehicles/121/subtrips?endDate=2016-05-17T18:45:00&startDate=2016-05-16T06:05:00

Thank

Re: How to ignore characters (parts) of an XML

rwunderlich — Fri, 01 Jul 2016 21:53:23 GMT

When you use that URL in QlikView script, JSON is returned, not XML. It does return XML when used in a browser. Is there a parameter you can add to the URL to force it to return XML?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: How to ignore characters (parts) of an XML

Peter_Cammaert — Fri, 01 Jul 2016 22:07:25 GMT

Maybe the QlikView REST Connector (JSON) could be useful?

Re: How to ignore characters (parts) of an XML

Peter_Cammaert — Fri, 01 Jul 2016 22:22:09 GMT

It does work out-of-the box with the REST connector. See attachment.

Peter

[Edit] The REST Connector is a free Qlik package and can be obtained here: REST Connector

Re: How to ignore characters (parts) of an XML

chrisssmaia — Fri, 01 Jul 2016 22:22:12 GMT

Truth. I had not realized it. But there is no parameter to put in the URL to force the xml. Thank you for your help.

Re: How to ignore characters (parts) of an XML

chrisssmaia — Fri, 01 Jul 2016 22:40:11 GMT

Thank you Peter. With the REST Connector worked perfectly.