(Excel) HTTP POST x-www-form-urlencoded

Demonstrates how to send a simple URL encoded POST (content-type = x-www-form-urlencoded). Form params are passed in the HTTP request body in x-www-form-urlencoded format.

Download Excel Class Modules

Chilkat Excel Class Modules

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest

' Add the request params expected by the server-side:
req.AddParam "city","Paris"
req.AddParam "country","France"

' Send the POST  (This is a real URL that may be tested.)

Set resp = http.PostUrlEncoded("http://www.chilkatsoft.com/httpTest/cityCountry.asp",req)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' The exact HTTP request sent and response received
' by the example code above is as follows:

' 
' ---- Sending ----
' POST /httpTest/cityCountry.asp HTTP/1.1
' Host: www.chilkatsoft.com
' Content-Type: application/x-www-form-urlencoded
' Content-Length: 25
' 
' city=Paris&country=France
' ---- Received ----
' HTTP/1.1 200 OK
' Date: Wed, 09 Dec 2009 16:16:00 GMT
' Server: Microsoft-IIS/6.0
' X-Powered-By: ASP.NET
' Content-Length: 156
' Content-Type: text/html
' Set-Cookie: ASPSESSIONIDQCDTSSAC=MHJCNFMDENFOKGINOFEDILCM; path=/
' Cache-control: private
' 
' 
' <html>
' <head>
' <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
' </head>
' <body>
' 
' France<br />Paris<br />
' 
' </body>
' </html>