Solved

read URL output(CSV) file into ASP

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

759 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now