1 Reply Latest reply: Nov 8, 2016 3:38 AM by Joaqu�n L�zaro RSS

    Problem reading data from a web

    Joaqu�n L�zaro

      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

        • Re: Problem reading data from a web
          Joaqu�n L�zaro

          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