<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Problem reading data from a web in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Problem-reading-data-from-a-web/m-p/1212736#M628087</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;HI:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The problem was that the data were in JSON format, and it isn't a valid format.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I readed this data with two metods:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;a) Instaling CURL app in my descktop and server environment&lt;/P&gt;&lt;P&gt;b) Instaling QlikView Rest Connector, a free tool for reading data from FACEBOOK, LINKEDIN, GOOGLE ANALTYCIS and WebServices.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Hope it helps anybody&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Joaquín&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 08 Nov 2016 08:38:38 GMT</pubDate>
    <dc:creator>Joaquin_Lazaro</dc:creator>
    <dc:date>2016-11-08T08:38:38Z</dc:date>
    <item>
      <title>Problem reading data from a web</title>
      <link>https://community.qlik.com/t5/QlikView/Problem-reading-data-from-a-web/m-p/1212735#M628086</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;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&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;It isn't valid in the upper level document&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;&lt;STRONG&gt;On line number: 1. On column number: 38. System ID: .es/api/rs/uac/accounts/.&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;&lt;STRONG&gt;&lt;BR /&gt;&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;CallATC:&lt;/P&gt;&lt;P&gt;LOAD&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; id,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; name,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; nif,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; realNif,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; color,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; version&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;FROM [&lt;/SPAN&gt;&lt;A class="jive-link-external-small" href="https://myuserid:mypwd@manager.masvoz.es/api/rs/uac/accounts/" rel="nofollow" target="_blank"&gt;https://myuserid:mypwd@manager.masvoz.es/api/rs/uac/accounts/&lt;/A&gt;&lt;A class="jive-link-email-small" href="mailto:mypwd@manager.masvoz.es"&gt;mypwd@manager.masvoz.es&lt;/A&gt;&lt;SPAN&gt;/api/rs/uac/accounts/] (xmlGeneric, Table is [collection/account])&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 13.3333px;"&gt;Edited: There shouldn't be any characters between ...accounts/myuser:mypwd AT&amp;nbsp; ...&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;When I type the C-URL on the Chrome browser I get this page&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P class="header" style="border-bottom: 2px solid black; padding-bottom: 5px; margin: 10px; color: #000000; font-family: 'Times New Roman'; font-size: medium;"&gt;This XML file does not appear to have any style information associated with it. The document tree is shown below.&lt;/P&gt;&lt;P class="pretty-print" style="margin-top: 1em; margin-left: 20px; font-family: monospace; font-size: 13px; color: #000000;"&gt;&lt;/P&gt;&lt;DIV class="collapsible"&gt;&lt;DIV class="expanded"&gt;&lt;DIV class="line"&gt;&lt;SPAN class="button collapse-button" style="margin-left: -10px; background-position: initial;"&gt;&lt;/SPAN&gt;&lt;SPAN class="html-tag"&gt;&amp;lt;collection&amp;gt;&lt;/SPAN&gt;&lt;P&gt;&lt;/P&gt;&lt;P class="collapsible-content" style="margin-left: 1em;"&gt;&lt;/P&gt;&lt;DIV class="collapsible"&gt;&lt;DIV class="expanded"&gt;&lt;DIV class="line"&gt;&lt;SPAN class="button collapse-button" style="margin-left: -10px; background-position: initial;"&gt;&lt;/SPAN&gt;&lt;SPAN class="html-tag"&gt;&amp;lt;account&amp;gt;&lt;/SPAN&gt;&lt;P&gt;&lt;/P&gt;&lt;P class="collapsible-content" style="margin-left: 1em;"&gt;&lt;/P&gt;&lt;DIV class="line"&gt;&lt;SPAN class="html-tag"&gt;&amp;lt;id&amp;gt;&lt;/SPAN&gt;&lt;SPAN class="text"&gt;6666&lt;/SPAN&gt;&lt;SPAN class="html-tag"&gt;&amp;lt;/id&amp;gt;&lt;/SPAN&gt;&lt;P&gt;&lt;/P&gt;&lt;P class="line"&gt;&lt;SPAN class="html-tag"&gt;&amp;lt;name&amp;gt;&lt;/SPAN&gt;&lt;SPAN class="text"&gt;MECALUX SA&lt;/SPAN&gt;&lt;SPAN class="html-tag"&gt;&amp;lt;/name&amp;gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="line"&gt;&lt;SPAN class="html-tag"&gt;&amp;lt;nif&amp;gt;&lt;/SPAN&gt;&lt;SPAN class="text"&gt;I2117061I&lt;/SPAN&gt;&lt;SPAN class="html-tag"&gt;&amp;lt;/nif&amp;gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="line"&gt;&lt;SPAN class="html-tag"&gt;&amp;lt;realNif&amp;gt;&lt;/SPAN&gt;&lt;SPAN class="text"&gt;A08123456&lt;/SPAN&gt;&lt;SPAN class="html-tag"&gt;&amp;lt;/realNif&amp;gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="line"&gt;&lt;SPAN class="html-tag"&gt;&amp;lt;color&amp;gt;&lt;/SPAN&gt;&lt;SPAN class="text"&gt;11824243&lt;/SPAN&gt;&lt;SPAN class="html-tag"&gt;&amp;lt;/color&amp;gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="line"&gt;&lt;SPAN class="html-tag"&gt;&amp;lt;version&amp;gt;&lt;/SPAN&gt;&lt;SPAN class="text"&gt;2016-07-15T12:52:05+02:00&lt;/SPAN&gt;&lt;SPAN class="html-tag"&gt;&amp;lt;/version&amp;gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/DIV&gt;&lt;P class="line"&gt;&lt;SPAN class="html-tag"&gt;&amp;lt;/account&amp;gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;P class="line"&gt;&lt;SPAN class="html-tag"&gt;&amp;lt;/collection&amp;gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;What I'm doing wrong or which is the best method for doing this ?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thank you very much.&lt;/P&gt;&lt;P&gt;Joaquín&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 24 Oct 2016 13:42:21 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Problem-reading-data-from-a-web/m-p/1212735#M628086</guid>
      <dc:creator>Joaquin_Lazaro</dc:creator>
      <dc:date>2016-10-24T13:42:21Z</dc:date>
    </item>
    <item>
      <title>Re: Problem reading data from a web</title>
      <link>https://community.qlik.com/t5/QlikView/Problem-reading-data-from-a-web/m-p/1212736#M628087</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;HI:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The problem was that the data were in JSON format, and it isn't a valid format.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I readed this data with two metods:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;a) Instaling CURL app in my descktop and server environment&lt;/P&gt;&lt;P&gt;b) Instaling QlikView Rest Connector, a free tool for reading data from FACEBOOK, LINKEDIN, GOOGLE ANALTYCIS and WebServices.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Hope it helps anybody&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Joaquín&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 08 Nov 2016 08:38:38 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Problem-reading-data-from-a-web/m-p/1212736#M628087</guid>
      <dc:creator>Joaquin_Lazaro</dc:creator>
      <dc:date>2016-11-08T08:38:38Z</dc:date>
    </item>
  </channel>
</rss>

