tags:

views:

36

answers:

1
Q: 

what is the problem with my http GET ??

in VBA i am creating a URL:

URL = "http://api.local.yahoo.com/MapsService/V1/geocode?appid=" & yahoo & "&street=" & street & "&city=" & city & "&state=" & state & "&zip=" & zip

for example it sets itself to equal this:

http://api.local.yahoo.com/MapsService/V1/geocode?appid=username123&street=1893 n. clyde morris blvd &city=daytona beach&state=FL&zip=32117

when i manually go to this URL, IT WORKS FINE.

however when i do this:

'Create Http object
If IsEmpty(http) Then Set http = CreateObject("WinHttp.WinHttpRequest.5.1")

'Send request To URL
http.Open "GET", URL

http.send
'Get response data As a string

response = http.responseText

it's giving me this for the response:

response="Watch :   : response : "<!doctype html public "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"&gt;
<html><head><title>Yahoo! - 400 Bad Request</title><style>
/* nn4 hide */ 
/*/*/
bod........"

please note that 50% of the time it returns the correct URL and 50% it gives me a 400 bad request

what am i doing wrong?

wrikken has suggested that i get a URLencoder, but i believe that it was encoding it correctly!

+1  A: 

You need to url-encode all your query parameters, otherwise they may result in invalid URLs, depending on their actual value (for instance, a space should be a + or a %20). Google has a multitude of VBA url encode examples, it appears there's no built-in function for it.

Wrikken  2010-10-05 00:14:36
@wrikken: thank you so much for your help. can you please show me an example
i am a girl  2010-10-05 00:15:19
Quote 'Wrikken': _"Google has a multitude of VBA url encode examples."_
Wrikken  2010-10-05 00:16:56
@wrikken: thank you. im getting THE URL does not use a recognized protocol" - what does this mean?
i am a girl  2010-10-05 00:19:05
Wrikken  2010-10-05 00:22:04
@wrikken: thank you again. now im getting something crazy like this "http://api.local.yahoo.com/MapsService/V1/geocode?appid=user123%26street%3D4511%20horizon%20hill%20ste%2E%20150%26city%3Dsan%20antonio%26state%3DTX%26zip%3D78229"
i am a girl  2010-10-05 00:28:11
i am a girl  2010-10-05 00:28:39
Wrikken  2010-10-05 00:44:11

related questions

Does anyone have a good Proper Case algorithm
Converting bool to text in C++
Does PHP have an equivalent to this type of Python string substitution?
PHP ToString() equivalent
What's the difference between a string constant and a string literal?
What would be the fastest way to remove Newlines from a String in C#?
Why is String.Format static?
PowerShell - How do I pass string parameters correctly?
What's the best string concatenation method using C#?
Java: Best way of converting List<Integer> to List<String>
C# String output: format or concat?
Parse usable Street Address, City, State, Zip from a string
C# Save Dialogs
How do I Convert a string to an enum in C#?
PowerShell - how do I do a string replacement in a function?
Case insensitive string comparison in C++
Why doesn't Ruby have a real StringBuffer or StringIO?
Checking for string contents? string Length Vs Empty String
Remove Quotes and Commas from a String in MySQL
Test serialization encoding
In C# what is the difference between String and string
String.indexOf function in C
What is the best way to parse strings in Java
Format string to title case
Generate list of all possible permutations of a string