topic Re: Getting car information from a website using the registration - help! in QlikView

Getting car information from a website using the registration - help!

Wed, 18 Jul 2012 10:57:12 GMT

Hi,

I have used a script to get lat and long information based on a postcode before now which remains really useful. I've now got a new question ... some websites you are able to go to and get basic make and model information by entering the car registration. Any ideas if this can be automated? We want to check that people are entering the correct engine size when making mileage claims! 🙂

Many thanks,

Emma

Re: Getting car information from a website using the registration - help!

Wed, 18 Jul 2012 11:14:17 GMT

Emma,

I am not sure if I understand you completly. But if the requirement is extract the data from a parameter based URL, then yes it is possible.

Typically URL will have the parmeters like http://abaasdfas.com/ParamA?=<your parameter>. Using for loop in the script along with webfiles based load statement to achieve this.

Kiran.

Re: Getting car information from a website using the registration - help!

Wed, 18 Jul 2012 12:46:10 GMT

Hi Kiran,

Yeah - probably didn't express it very well (was running into a meeting!).

The parameter based URL is essentially they type of thing I'm after, but I don't know which website to use an was wondering if anyone had any ideas.

Thanks,

Emma