Automate "Get External Data" over HTTP with a BasicAuth protectedressource

  • Thread starter Thread starter =?ISO-8859-1?Q?Michael_Kr=F6ll?=
  • Start date Start date
?

=?ISO-8859-1?Q?Michael_Kr=F6ll?=

Hi,

Using the "Get External Data" import dialog of Access 2003 I can import
an XML file from a remote URL. If a that URL needs credentials
(BasicAuth), I'll be prompted for username and password and the import
works fine. Now, if I try to automate that process using
Application.ImportXML that import fails. It looks like ImportXML only
accepts unprotected URLs.
How can I workaround that? Are there other ways to automate that "Get
External Data" import dialog? Do I have to use WinHTTPRequest and ask
for username and password via InputBoxes?

--michael
 
There used to be a syntax for embedding credentials in the URL itself.
Not sure if MS removed it in a recent SP.
But give it a try.

I don't recall the exact syntax off the top of my head but it was something
like:

http://joe:[email protected]
 
That capability was removed from Internet Explorer quite some time ago, so
I'd assume the same is true of the Get External Dialog route as well.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Joe Fallon said:
There used to be a syntax for embedding credentials in the URL itself.
Not sure if MS removed it in a recent SP.
But give it a try.

I don't recall the exact syntax off the top of my head but it was
something like:

http://joe:[email protected]
Click to expand...
 
Back
Top