Excel Web Data Query Invalid URL

Question

I am trying to scrape data from an amazon product page to get the price and put that in an Excel spreadsheet. I have done this before with other URLs and it has been fine but the URL I am trying to use is this:

https://www.amazon.co.uk/dp/B01J2BK6CO/ref=gw\_aucc\_rk\_qh\_ec\_wh?pf\_rd\_p=7747d414-88e2-4b25-addf-9fab03d0cf97&pf\_rd\_r=FGCBXTB3YDG1XC3MGKF5

I paste in the URL to the Get Data From Web function without changing any settings, although I have tried parsing in HTML headers with no success, and it tells me it is connecting for a few seconds, then tells me that the URL is invalid and says: "The supplied URL must be a valid 'http:' or 'https:' URL."

If i just try https://www.amazon.co.uk then it works and connects fine but if I try any product page it doesn't work at all. 

Any help will be greatly appreciated.