Solved

read URL output(CSV) file into ASP

Posted on 2011-02-28
3
513 Views
Last Modified: 2012-05-11
Hi,

i have a http url which returns .csv file upon execution.

is there any way i can execute the URL from ASP and cath the response (which is .csv file) into a string variable?

Example: My csv returns this data...:
              Date,Open,High,Low
              2011-02-25,16.39,16.77,1

Environment: ASP (Active Server Pages)

thanks
0
Comment
Question by:kishan66
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
rhawk earned 500 total points
ID: 35001145
Dim targetURL, strResponse
targetURL = "http://where.you.want.com"

set httpRequest = CreateObject("WinHttp.WinHttprequest.5.1")
httpRequest.Open "POST", targetURL, false
httpRequest.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
httpRequest.send
strResponse = httpRequest.responseText
0
 

Author Comment

by:kishan66
ID: 35001494
Thats what i am talking about, rhawk.

Thank you so much.

can you pls suggest me site(s)  where i can read about this kind of "httpRequest/Response" header for ASP , in general.
0
 
LVL 2

Expert Comment

by:rhawk
ID: 35001813
0

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question