How to ignore characters (parts) of an XML

[chrisssmaia]

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-...

Thank

[rwunderlich]

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

[Peter_Cammaert]

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

[Peter_Cammaert · Accepted solution]

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

[chrisssmaia]

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.

[chrisssmaia]

Thank you Peter. With the REST Connector worked perfectly.