(Excel) TicketBAI -- Send HTTP POST

See more TicketBAI Examples

Demonstrates how to send a TicketBAI POST and get the response.

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


success = http.SetSslClientCertPfx("your.pfx","pfx_password")
If (success = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' Get the XML we wish to send in the body of the request.
Dim sbXml As Chilkat.StringBuilder
Set sbXml = Chilkat.NewStringBuilder
success = sbXml.LoadFile("qa_data/payload.xml","utf-8")
If (success = False) Then
    Debug.Print "Failed to load XML that is to be the HTTP request body"
    Exit Sub
End If

' Build the following JSON

' { 
'     "con": "LROE", 
'     "apa": "1.1", 
'     "inte": { 
'         "nif": "número de identificación fiscal", 
'         "nrs": "nombre o Razón social", 
'         "ap1": "primer apellido", 
'         "ap2": "segundo apellido" 
'     }, 
'     "drs": { 
'     "mode": "140/240", 
'     "ejer": "ejercicio" 
'     } 
' }

' Use this online tool to generate code from sample JSON: 
' Generate Code to Create JSON

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
Dim success As Boolean
success = json.UpdateString("con","LROE")
success = json.UpdateString("apa","1.1")
success = json.UpdateString("inte.nif","número de identificación fiscal")
success = json.UpdateString("inte.nrs","nombre o Razón social")
success = json.UpdateString("inte.ap1","primer apellido")
success = json.UpdateString("inte.ap2","segundo apellido")
success = json.UpdateString("drs.mode","140/240")
success = json.UpdateString("drs.ejer","ejercicio")

' Add required headers...
http.SetRequestHeader "eus-bizkaia-n3-version","1.0"
http.SetRequestHeader "eus-bizkaia-n3-content-type","application/xml"
http.SetRequestHeader "eus-bizkaia-n3-data",json.Emit()


url = "https://pruesarrerak.bizkaia.eus/N3B4000M/aurkezpena"

bGzip = True

Set resp = http.PTextSb("POST",url,sbXml,"utf-8","application/octet-stream",False,bGzip)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

http.ClearHeaders 

Debug.Print "response status code: "; resp.StatusCode

' Examine the response (it is already decompressed)
Debug.Print "response body:"
Debug.Print resp.BodyStr