(Excel) Shippo Track Individual Shipments

Demonstrates how to submit an individual tracking request for a single shipment.

For more information, see https://goshippo.com/docs/tracking/

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/tracks/usps/92701902416755000000000015 \
'     -H "Authorization: ShippoToken <API_TOKEN>"

http.SetRequestHeader "Authorization","ShippoToken <API_TOKEN>"

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = http.QuickGetSb("https://api.goshippo.com/tracks/usps/92701902416755000000000015",sbResponseBody)
If (success = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim jResp As Chilkat.JsonObject
Set jResp = Chilkat.NewJsonObject
Dim success As Boolean
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False

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


respStatusCode = http.LastStatus
Debug.Print "Response Status Code = "; respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print http.LastHeader
    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": "2014-11-29T16:31:19.512Z",
'   "object_updated": "2014-11-29T16:31:19.512Z",
'   "object_id": "5695ae3a5eda41ba9abdbf347fd545f3",
'   "object_owner": "test@goshippo.com",
'   "test": false,
'   "rate": "693ea14a541f44e090291b929c171d5a",
'   "tracking_number": "9102969010383081813033",
'   "tracking_status": "DELIVERED",
'   "eta": "2014-11-24T00:00:00Z",
'   "tracking_url_provider": "https:\/\/tools.usps.com\/go\/TrackConfirmAction_input?origTrackNum=9102969010383081813033",
'   "label_url": "https:\/\/shippo-delivery-east.s3.amazonaws.com\/5695ae3a5eda41ba9abdbf347fd545f3.pdf?Signature=AyiitLq2g%2F2R9fjboCTVxi5z7JQ%3D&Expires=1534873886&AWSAccessKeyId=AKIAJGLCC5MYLLWIG42A",
'   "commercial_invoice_url": null,
'   "messages": [
'   ],
'   "order": "ca760ef0099040b4a2b7feec827bca88",
'   "metadata": "",
'   "parcel": "e0de043b2f7f4b6d8e6f23ad69641cc1",
'   "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