Discussion Board for collaboration on QlikView Scripting.
I'm trying to retrieve data from a web page in xml format with this sentece, but I get an error marked with bold type
It isn't valid in the upper level document
On line number: 1. On column number: 38. System ID: .es/api/rs/uac/accounts/.
FROM [https://myuserid:firstname.lastname@example.orgemail@example.com/api/rs/uac/accounts/] (xmlGeneric, Table is [collection/account])
Edited: There shouldn't be any characters between ...accounts/myuser:mypwd AT ...
When I type the C-URL on the Chrome browser I get this page
This XML file does not appear to have any style information associated with it. The document tree is shown below.
What I'm doing wrong or which is the best method for doing this ?
Thank you very much.
Go to Solution.
The problem was that the data were in JSON format, and it isn't a valid format.
I readed this data with two metods:
a) Instaling CURL app in my descktop and server environment
b) Instaling QlikView Rest Connector, a free tool for reading data from FACEBOOK, LINKEDIN, GOOGLE ANALTYCIS and WebServices.
Hope it helps anybody