Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

joaquinlr
Valued Contributor II

Problem reading data from a web

Hello:

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


CallATC:

LOAD

    id,

    name,

    nif,

    realNif,

    color,

    version

FROM [https://myuserid:mypwd@manager.masvoz.es/api/rs/uac/accounts/mypwd@manager.masvoz.es/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.

<collection>

<account>

<id>6666</id>

<name>MECALUX SA</name>

<nif>I2117061I</nif>

<realNif>A08123456</realNif>

<color>11824243</color>

<version>2016-07-15T12:52:05+02:00</version>

</account>

</collection>

What I'm doing wrong or which is the best method for doing this ?

Thank you very much.

Joaquín

1 Solution

Accepted Solutions
joaquinlr
Valued Contributor II

Re: Problem reading data from a web

HI:

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

Joaquín

1 Reply
joaquinlr
Valued Contributor II

Re: Problem reading data from a web

HI:

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

Joaquín

Community Browser