Import data from online file

[gerhardl]

Hi, I have a CSV file that I download from a user interface for our call centre dialler system. I do this via a download button, but the link address does not include a file name or extension like a download link usually does.

The download link looks like this: http://172.18.101.203/Reports/DownloadFull

This then generates a file with a default name of "Download Full.csv"

Currently I download this file manually and then import to QV, but I want to import directly from the site. When I use the QV "Web File" wizard and enter the URL http://172.18.101.203/Reports/DownloadFull it doesn't work. "Cannot Open HTML File" and when I choose a delimited file type it sees the html text:

I've tried changing the download link to include the default file name etc. but nothing seems to work.

Note that I need a username & password to log into the website.

[isingh30]

This has to do with the format. Please share your app.

Thank you!

[gerhardl]

Sorry, but what format?

There is no app to share. This is the starting point of the application so it has no data and no load script, I'm simply trying to get the data.

[isingh30]

Did you check file type html? If possible, can you share your csv file.Let me know.

Thank you!

[gerhardl]

I did yes, it shows this:

I unfortunately cannot share the CSV file, but the file is not the problem, it's accessing the file on the website that's the problem. The file loads fine if I load from my drive:

[isingh30]

Check these - Did you try any web connector so far?

Connect to webservice

https://www.quickintelligence.co.uk/free-qlik-web-connectors/

Thank you!