(Excel) Shippo Create Transaction Object

Creates a Transaction object that represents a shipping label purchase and is based on the shipping rate.

For more information, see https://goshippo.com/docs/shipping-labels/

Download Excel Class Modules Chilkat Excel Class Modules

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

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

' Implements the following CURL command:

' curl https://api.goshippo.com/transactions \
'     -H "Authorization: ShippoToken <API_TOKEN>" \
'     -d rate="478fb066930e4e3195a3686f7ea5b612"
'     -d label_file_type="PDF"
'     -d async=false

Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest
req.HttpVerb = "POST"
req.Path = "/transactions"
req.ContentType = "application/x-www-form-urlencoded"
req.AddParam "rate","478fb066930e4e3195a3686f7ea5b612"
req.AddParam "label_file_type","PDF"
req.AddParam "async","false"

req.AddHeader "Authorization","ShippoToken <API_TOKEN>"


Set resp = http.PostUrlEncoded("https://api.goshippo.com/transactions",req)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = resp.GetBodySb(sbResponseBody)
Dim jResp As Chilkat.JsonObject
Set jResp = Chilkat.NewJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False

Debug.Print "Response Body:"
Debug.Print jResp.Emit()


respStatusCode = resp.StatusCode
Debug.Print "Response Status Code = "; respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print resp.Header
    Debug.Print "Failed."

    Exit Sub
End If

' Sample JSON response:
' (Sample code for parsing the JSON response is shown below)

' {
'   "object_state": "VALID",
'   "status": "SUCCESS",
'   "object_created": "2019-06-28T18:04:08.679Z",
'   "object_updated": "2019-06-28T18:04:10.516Z",
'   "object_id": "6178e155da304f10aa4b4271fdca84fb",
'   "object_owner": "admin@chilkatsoft.com",
'   "test": true,
'   "rate": "dd7556c284e8444294d2ab7099e662d2",
'   "tracking_number": "92701902416755000000000015",
'   "tracking_status": "UNKNOWN",
'   "eta": null,
'   "tracking_url_provider": "https://tools.usps.com/go/TrackConfirmAction_input?origTrackNum=92701902416755000000000015",
'   "label_url": "https://shippo-delivery-east.s3.amazonaws.com/6178e155da304f10aa4b4271fdca84fb.pdf?Signature=1LU0Qf11nQJGei%2FeLZr%2BQ5EwJS4%3D&Expires=1593281050&AWSAccessKeyId=AKIAJGLCC5MYLLWIG42A",
'   "commercial_invoice_url": null,
'   "messages": [
'   ],
'   "order": null,
'   "metadata": "",
'   "parcel": "5af766ff15684a4186b0e3c833348fac",
'   "billing": {
'     "payments": [
'     ]
'   }
' }

' Sample code for parsing the JSON response...
' Use the following online tool to generate parsing code from sample JSON:
' Generate Parsing Code from JSON


object_state = jResp.StringOf("object_state")

status = jResp.StringOf("status")

object_created = jResp.StringOf("object_created")

object_updated = jResp.StringOf("object_updated")

object_id = jResp.StringOf("object_id")

object_owner = jResp.StringOf("object_owner")

test = jResp.BoolOf("test")

rate = jResp.StringOf("rate")

tracking_number = jResp.StringOf("tracking_number")

tracking_status = jResp.StringOf("tracking_status")

eta = jResp.StringOf("eta")

tracking_url_provider = jResp.StringOf("tracking_url_provider")

label_url = jResp.StringOf("label_url")

commercial_invoice_url = jResp.StringOf("commercial_invoice_url")

order = jResp.StringOf("order")

metadata = jResp.StringOf("metadata")

parcel = jResp.StringOf("parcel")

i = 0

count_i = jResp.SizeOfArray("messages")
Do While i < count_i
    jResp.I = i
    i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("billing.payments")
Do While i < count_i
    jResp.I = i
    i = i + 1
Loop