Automate process to look up data on secure website

How can I automate a manual process where a human has to look up a member on an external website that requires login.  For example, we need to look up members on a web site where we login and search to obtain valid member information.  This is very tedious and it seems it could be automated, since we already have access to that web site.  
I am thinking I could build a .Net application that could login and access that web site in order to query, similar to an LDAP query I recall my organization used 10 years ago to lookup phone numbers for its employees.  
Thank you for any insight and suggestions.
newtoperlpgmAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

zephyr_hex (Megan)DeveloperCommented:
The website is just a front end for some data storage mechanism on the back-end (most likely a database).  So, your options are to write an API for that external website so that you're able to retrieve the information you need, or, perhaps you're able to connect to the database behind that website and query it via code ?
0
newtoperlpgmAuthor Commented:
Yes, that is what I was thinking, but I did not know if there was some standard.   I have not been developing applications for a while.
0
zephyr_hex (Megan)DeveloperCommented:
The easiest approach would be to query the database directly from your code.  But, this depends on whether you have access to the database.  If it's on a remote server, you may not have access.  If that's the case, then you can write an API for the website that allows you to query / retrieve the data remotely.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.