PowerBuilder

Shippo List All Orders

See more Shippo Examples

Demonstrates how to list all orders created by sending a GET request to the orders endpoint. PowerBuilder

integer li_rc
long li_Success
oleobject loo_Http
oleobject loo_SbResponseBody
oleobject loo_JResp
long li_RespStatusCode
long li_IntVal
long j
long li_Count_j
string ls_Object_id
string ls_Title
string ls_Variant_title
string ls_Sku
long li_Quantity
string ls_Total_price
string ls_Currency
string ls_Weight
string ls_Weight_unit
string ls_Manufacture_country
string ls_Max_ship_time
string ls_Max_delivery_time
string ls_Description
long li_Count
string ls_Next
string ls_Previous
long i
long li_Count_i

li_Success = 0

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

loo_Http = create oleobject
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
if li_rc < 0 then
    destroy loo_Http
    MessageBox("Error","Connecting to COM object failed")
    return
end if

//  Implements the following CURL command:

//  curl https://api.goshippo.com/orders/ \
//      -H "Authorization: ShippoToken <API_Token>"

loo_Http.SetRequestHeader("Authorization","ShippoToken <API_Token>")

loo_SbResponseBody = create oleobject
li_rc = loo_SbResponseBody.ConnectToNewObject("Chilkat.StringBuilder")

li_Success = loo_Http.QuickGetSb("https://api.goshippo.com/orders/",loo_SbResponseBody)
if li_Success = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_SbResponseBody
    return
end if

loo_JResp = create oleobject
li_rc = loo_JResp.ConnectToNewObject("Chilkat.JsonObject")

loo_JResp.LoadSb(loo_SbResponseBody)
loo_JResp.EmitCompact = 0

Write-Debug "Response Body:"
Write-Debug loo_JResp.Emit()

li_RespStatusCode = loo_Http.LastStatus
Write-Debug "Response Status Code = " + string(li_RespStatusCode)
if li_RespStatusCode >= 400 then
    Write-Debug "Response Header:"
    Write-Debug loo_Http.LastHeader
    Write-Debug "Failed."
    destroy loo_Http
    destroy loo_SbResponseBody
    destroy loo_JResp
    return
end if

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

//  {
//    "count": 1382,
//    "next": "https://api.goshippo.com/orders/?page=2",
//    "previous": null,
//    "results": [
//      {
//        "object_id": "4f2bc588e4e5446cb3f9fdb7cd5e190b",
//        "object_owner": "shippotle@goshippo.com",
//        "order_number": "#1068",
//        "order_status": "PAID",
//        "placed_at": "2016-09-23T01:28:12Z",
//        "to_address": {
//          "object_created": "2016-09-23T01:38:56Z",
//          "object_updated": "2016-09-23T01:38:56Z",
//          "object_id": "d799c2679e644279b59fe661ac8fa488",
//          "object_owner": "shippotle@goshippo.com",
//          "is_complete": true,
//          "validation_results": {},
//          "name": "Mr Hippo",
//          "company": "Shippo",
//          "street1": "215 Clayton St.",
//          "street2": "",
//          "city": "San Francisco",
//          "state": "CA",
//          "zip": "94117",
//          "country": "US",
//          "phone": "15553419393",
//          "email": "shippotle@goshippo.com",
//          "is_residential": null,
//          "metadata": ""
//        },
//        "from_address": null,
//        "line_items": [
//          {
//            "object_id": "abf7d5675d744b6ea9fdb6f796b28f28",
//            "title": "Hippo Magazines",
//            "variant_title": "",
//            "sku": "HM-123",
//            "quantity": 1,
//            "total_price": "12.10",
//            "currency": "USD",
//            "weight": "0.40",
//            "weight_unit": "lb",
//            "manufacture_country": null,
//            "max_ship_time": null,
//            "max_delivery_time": null,
//            "description": null
//          }
//        ],
//        "shipping_cost": "12.83",
//        "shipping_cost_currency": "USD",
//        "shipping_method": "USPS First Class Package",
//        "shop_app": "Shippo",
//        "subtotal_price": "12.10",
//        "total_price": "24.93",
//        "total_tax": "0.00",
//        "currency": "USD",
//        "transactions": [
//        ],
//        "weight": "0.40",
//        "weight_unit": "lb",
//        "notes": null
//      },
//      ...
//    ]
//  }

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

li_Count = loo_JResp.IntOf("count")
ls_Next = loo_JResp.StringOf("next")
ls_Previous = loo_JResp.StringOf("previous")
i = 0
li_Count_i = loo_JResp.SizeOfArray("results")
do while i < li_Count_i
    loo_JResp.I = i
    li_IntVal = loo_JResp.IntOf("results[i]")
    j = 0
    li_Count_j = loo_JResp.SizeOfArray("results[i].line_items")
    do while j < li_Count_j
        loo_JResp.J = j
        ls_Object_id = loo_JResp.StringOf("results[i].line_items[j].object_id")
        ls_Title = loo_JResp.StringOf("results[i].line_items[j].title")
        ls_Variant_title = loo_JResp.StringOf("results[i].line_items[j].variant_title")
        ls_Sku = loo_JResp.StringOf("results[i].line_items[j].sku")
        li_Quantity = loo_JResp.IntOf("results[i].line_items[j].quantity")
        ls_Total_price = loo_JResp.StringOf("results[i].line_items[j].total_price")
        ls_Currency = loo_JResp.StringOf("results[i].line_items[j].currency")
        ls_Weight = loo_JResp.StringOf("results[i].line_items[j].weight")
        ls_Weight_unit = loo_JResp.StringOf("results[i].line_items[j].weight_unit")
        ls_Manufacture_country = loo_JResp.StringOf("results[i].line_items[j].manufacture_country")
        ls_Max_ship_time = loo_JResp.StringOf("results[i].line_items[j].max_ship_time")
        ls_Max_delivery_time = loo_JResp.StringOf("results[i].line_items[j].max_delivery_time")
        ls_Description = loo_JResp.StringOf("results[i].line_items[j].description")
        j = j + 1
    loop
    j = 0
    li_Count_j = loo_JResp.SizeOfArray("results[i].transactions")
    do while j < li_Count_j
        loo_JResp.J = j
        j = j + 1
    loop
    i = i + 1
loop


destroy loo_Http
destroy loo_SbResponseBody
destroy loo_JResp