Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ottebian
Contributor III
Contributor III

Accessing Web-Resource fails in Qlikview

Hello everybody,

I'm having some trouble with loading an xml file from a web-URL into Qlikview and hope someone can point me in the right direction to solve this mess.

Here's the code-snippet from my script:

table:

LOAD

    date

  ,value

FROM [https://api.sistrix.com/domain.sichtbarkeitsindex?api_key=XXX&domain=YYY]

(XmlSimple, Table is [response/answer/sichtbarkeitsindex]);

When executing the Script the following error-message appears:

Sichtbarkeitsindex.PNG

To make sure that I did not have a general firewall issue or typos in my link, I threw the link into a bunch of browsers. There everything worked exactly as expected:

Sichtbarkeitsindex2.PNG

Further information:

  • The machine where the code is executed is my publishing server. This machine does run solely the publishing service
  • The only server roles the publishing server has are "File and Storage Services"
  • On our DEV-machine, running with microsoft IIS and all qlikview services, the script can be executed without errors

To help me fix my problem I need to know how Qlikview accesses Web Resources so I can follow this route and hopefully find the spot where the tool gets stuck.

If anyone has already experienced similar issues an can point me to possible causes, that would be a great help.

Thanks in advance for your help,

Fabian

0 Replies