Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
chrisssmaia
New Contributor II

How to ignore characters (parts) of an XML

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

Erro.jpg

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

1 Solution

Accepted Solutions

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

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

5 Replies

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

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

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

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

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
New Contributor II

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

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
New Contributor II

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

Thank you Peter. With the REST Connector worked perfectly.

Community Browser