topic Re: Connection to a WebService from Script in QlikView

Connection to a WebService from Script

AbhijitBansode — Mon, 04 Jul 2016 14:00:16 GMT

Hi All,

I know we can connect to a web service without authentication using below syntax:

Forecast:

LOAD Date,

WeatherID,

Desciption,

[ProbabilityOfPrecipiation/Nighttime] as Nighttime,

[ProbabilityOfPrecipiation/Daytime] as Daytime,

[Temperatures/MorningLow] as MorningLow,

[Temperatures/DaytimeHigh] as DaytimeHigh

FROM [http://wsf.cdyne.com/WeatherWS/Weather.asmx/GetCityForecastByZIP?ZIP=33139] (XmlSimple, Table is [ForecastReturn/ForecastResult/Forecast]);

as mentioned https://community.qlik.com/docs/DOC-1320#start=25

I've a web service with basic authentication (username and password). How do I connect with this service using "Web Files" option. I've tried different options mentioned at "Basic access authentication - Wikipedia, the free encyclopedia" but can't get it working. Any suggestion here will be much helpful.

Thanks,

Abhijit

Re: Connection to a WebService from Script

rbecher — Mon, 04 Jul 2016 19:43:44 GMT

Please provide more details about the web service and your script..

- Ralf

Re: Connection to a WebService from Script

Frank_Hartmann — Mon, 04 Jul 2016 20:05:06 GMT

if there are any Special Characters in Usernames and Passwords the attached document might be helpful!

Re: Connection to a WebService from Script

rbecher — Mon, 04 Jul 2016 20:11:13 GMT

URL encoding should be always taken into account when dealing with web resources..

Re: Connection to a WebService from Script

AbhijitBansode — Tue, 05 Jul 2016 11:09:01 GMT

Thanks for the reply. rbecher‌ I don't have more details about the web service. I've tested the service using postman chrome extension and it works with basic authentication (Username and password).

franky_h79,thanks for the suggestion. username and password doesn't contain special characters. I've tried all the variations of the url listed in your example but it's not working yet.

Thanks,

Abhijit

Re: Connection to a WebService from Script

rbecher — Tue, 05 Jul 2016 11:18:49 GMT

So, what is you script call then?

Re: Connection to a WebService from Script

AbhijitBansode — Tue, 05 Jul 2016 11:35:02 GMT

I use "Web Files" option in load script to load the data from service:

Original URL is

https://server.domain.com:8443/AllStars/rest/allstar/qvdata

this works with postman using basic authentication. Lets consider username is 'user' and password is 'pass'

I've tried providing URLs in below formats:

https://user:pass@server.domain.com:8443/AllStars/rest/allstar/qvdata

https://user%40domain.com:pass@server.domain.com:8443/AllStars/rest/allstar/qvdata

https://user%40server.domain.com:pass@server.domain.com:8443/AllStars/rest/allstar/qvdata

https://user%40server.domain.com:8443:pass@server.domain.com:8443/AllStars/rest/allstar/qvdata

I've also tested open web service which doesn't require username and password and it generates below script when using above process:

SpotlightProblem:

LOAD

Qtr,

Period,

PR,

Active

FROM [https://server.domain.com:8443/toolswebservices/rest/spotlight/retail/problem] (XmlSimple, Table is [SpotlightProblems/SpotlightProblem]);

Re: Connection to a WebService from Script

Joaquin_Lazaro — Mon, 03 Oct 2016 10:43:37 GMT

Hi cabhijit

Did you retrieve data from a WebService ?

Thank you

Joaquín

Re: Connection to a WebService from Script

AbhijitBansode — Mon, 03 Oct 2016 12:48:27 GMT

Hi joaquinlr,

I've developed executable application using DOTNET to retrieve a data set from web service and store it in csv file to process in QV. EXE is called using EXECUTE command in QV script and it works charm.

Thanks,

Abhijit

Re: Connection to a WebService from Script

Joaquin_Lazaro — Mon, 03 Oct 2016 13:04:55 GMT

Hi Abhijit Bansode

OK. I will think about it

Thank you.