Solved

read URL output(CSV) file into ASP

Posted on 2011-02-28
3
514 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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 …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

830 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