• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data connection setup for internal data query of protected website

uday

uday

Member
Hi All,

I want to create a data connection in Excel for below mentioned link. The main purpose of this connection will be to retrieve data or download different file from the website.

But whenever I am trying to set up a connection with the file URL, I can not able to download it because of its totally protected by User name and Password. Due to some security policy I can not disclose the Username and Password and the file URL.

Please help me to setup a Query request for the Username and Password. The link details is mentioned below.

The HTML string is-
"https://my.statestreet.com/main-smp...GET=-SM-https://my.statestreet.com/login/home"

If you have any other suggestion to automate to download the desirable file then please let me know.

Thanks......
 

Hi !

Differents ways, it depends on the web page itself …

Use webbrowser inspector tool to find out the webpage request.​
 
Last edited:
You must log in or register to reply here.
Back
Top