I'm trying to import an XML file from a web-base URL that has an https connection which requires my developer key. I get the message you must specify a developer key.
However when input the URL in FireFox I can see the xml file. I'm also using Modify Headers add-on for FF with my developer key which appears fine in the web browser, just not excel when trying to import the data via web query.

How would i be able to display/import the content using web query in excel?