Sample code for 30+ languages & platforms
Classic ASP Requires Chilkat v11.0.0+

Ecwid - Search Orders

See more Ecwid Examples

Search or filter orders in an Ecwid store. The response provides full details of the found orders.

Chilkat Classic ASP Downloads

Classic ASP
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<%
success = 0

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

set http = Server.CreateObject("Chilkat.Http")

'  Implements the following CURL command:

'  curl --request GET \
'       --url 'https://app.ecwid.com/api/v3/storeId/orders?token=token' \
'       --header 'Accept: application/json'

'  Use the following online tool to generate HTTP code from a CURL command
'  Convert a cURL Command to HTTP Source Code

'  Load the access token previously obtained in Ecwid Get Access Token
set jsonToken = Server.CreateObject("Chilkat.JsonObject")
success = jsonToken.LoadFile("qa_data/tokens/ecwid.json")

http.SetRequestHeader "Accept","application/json"

set params = Server.CreateObject("Chilkat.JsonObject")
success = params.UpdateInt("limit",100)
success = params.UpdateString("email","joe@example.com")
success = params.UpdateString("token",jsonToken.StringOf("access_token"))

set resp = Server.CreateObject("Chilkat.HttpResponse")
success = http.HttpParams("GET","https://app.ecwid.com/api/v3/storeId/orders",params,resp)
If (success = 0) Then
    Response.Write "<pre>" & Server.HTMLEncode( http.LastErrorText) & "</pre>"
    Response.End
End If

set sbResponseBody = Server.CreateObject("Chilkat.StringBuilder")
success = resp.GetBodySb(sbResponseBody)
set jResp = Server.CreateObject("Chilkat.JsonObject")
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = 0

Response.Write "<pre>" & Server.HTMLEncode( "Response Body:") & "</pre>"
Response.Write "<pre>" & Server.HTMLEncode( jResp.Emit()) & "</pre>"

respStatusCode = resp.StatusCode

Response.Write "<pre>" & Server.HTMLEncode( "Response Status Code = " & respStatusCode) & "</pre>"
If (respStatusCode <> 200) Then
    Response.Write "<pre>" & Server.HTMLEncode( "Failed.") & "</pre>"
    Response.End
End If

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

'  {
'    "total": 1,
'    "count": 1,
'    "offset": 0,
'    "limit": 100,
'    "items": [
'      {
'        "id": "XJ12H",
'        "subtotal": 1076.64,
'        "total": 2014.97,
'        "giftCardRedemption": 2.23,
'        "totalBeforeGiftCardRedemption": 2.23,
'        "giftCardDoubleSpending": false,
'        "usdTotal": 2014.97,
'        "tax": 488.48,
'        "paymentMethod": "Credit or debit card (Mollie)",
'        "paymentStatus": "PARTIALLY_REFUNDED",
'        "fulfillmentStatus": "DELIVERED",
'        "vendorOrderNumber": "XJ12H",
'        "orderNumber": 1082727626,
'        "refererUrl": "https://mdemo.ecwid.com/",
'        "globalReferer": "https://my.ecwid.com/",
'        "createDate": "2018-05-31 15:08:36 +0000",
'        "updateDate": "2018-05-31 15:09:35 +0000",
'        "createTimestamp": 1527779316,
'        "updateTimestamp": 1527779375,
'        "hidden": false,
'        "orderComments": "Test order comments",
'        "privateAdminNotes": "Must be delivered till Sunday.",
'        "email": "mscott@gmail.com",
'        "ipAddress": "123.431.234.243",
'        "customerId": 40201284,
'        "customerGroupId": 12345,
'        "customerGroup": "Gold",
'        "customerTaxExempt": false,
'        "customerTaxId": "",
'        "customerTaxIdValid": false,
'        "reversedTaxApplied": false,
'        "discount": 4,
'        "couponDiscount": 22,
'        "volumeDiscount": 4,
'        "membershipBasedDiscount": 0,
'        "totalAndMembershipBasedDiscount": 0,
'        "customDiscount": [
'        ],
'        "discountCoupon": {
'          "id": 29567026,
'          "name": "API Testing",
'          "code": "APITESTING",
'          "discountType": "ABS",
'          "status": "ACTIVE",
'          "discount": 22,
'          "launchDate": "2018-05-24 20:00:00 +0000",
'          "usesLimit": "UNLIMITED",
'          "applicationLimit": "UNLIMITED",
'          "creationDate": "2018-05-31 15:08:33 +0000",
'          "updateDate": "2018-05-24 13:40:32 +0000",
'          "orderCount": 0
'        },
'        "discountInfo": [
'          {
'            "value": 4,
'            "type": "ABS",
'            "base": "ON_TOTAL",
'            "orderTotal": 1
'          }
'        ],
'        "items": [
'          {
'            "id": 140273658,
'            "productId": 66722487,
'            "categoryId": 19563207,
'            "price": 1060,
'            "productPrice": 1000,
'            "sku": "ABCA-IAC",
'            "quantity": 1,
'            "shortDescription": "",
'            "tax": 331.01,
'            "shipping": 0,
'            "quantityInStock": 0,
'            "name": "iMac",
'            "isShippingRequired": true,
'            "weight": 0,
'            "trackQuantity": false,
'            "fixedShippingRateOnly": false,
'            "imageUrl": "https://ecwid-images-ru.gcdn.co/images/5035009/391870914.jpg",
'            "smallThumbnailUrl": "https://ecwid-images-ru.gcdn.co/images/5035009/650638292.jpg",
'            "hdThumbnailUrl": "https://ecwid-images-ru.gcdn.co/images/5035009/650638293.jpg",
'            "fixedShippingRate": 0,
'            "digital": false,
'            "couponApplied": true,
'            "selectedOptions": [
'              {
'                "name": "Price-Optimizer",
'                "value": "6",
'                "valuesArray": [
'                  "6"
'                ],
'                "selections": [
'                  {
'                    "selectionTitle": "6",
'                    "selectionModifier": 6,
'                    "selectionModifierType": "PERCENT"
'                  }
'                ],
'                "type": "CHOICE"
'              }
'            ],
'            "taxes": [
'              {
'                "name": "State tax",
'                "value": 12,
'                "total": 124.13,
'                "taxOnDiscountedSubtotal": 124.13,
'                "taxOnShipping": 0,
'                "includeInPrice": false
'              },
'              {
'                "name": "TVA",
'                "value": 20,
'                "total": 206.88,
'                "taxOnDiscountedSubtotal": 206.88,
'                "taxOnShipping": 0,
'                "includeInPrice": true
'              }
'            ],
'            "dimensions": {
'              "length": 0,
'              "width": 0,
'              "height": 0
'            },
'            "couponAmount": 21.66,
'            "discounts": [
'              {
'                "discountInfo": {
'                  "value": 4,
'                  "type": "ABS",
'                  "base": "ON_TOTAL",
'                  "orderTotal": 1
'                },
'                "total": 3.94
'              }
'            ]
'          },
'          {
'            "id": 140273659,
'            "productId": 66821181,
'            "categoryId": 0,
'            "price": 16.64,
'            "productPrice": 16,
'            "sku": "001001",
'            "quantity": 1,
'            "shortDescription": "This sturdy white, glossy ceramic mug is an essential to your cupboard. This brawny version of ceramic mugs shows it’s ...",
'            "tax": 157.47,
'            "shipping": 471.85,
'            "quantityInStock": 0,
'            "name": "Mug",
'            "isShippingRequired": true,
'            "weight": 0.4,
'            "trackQuantity": false,
'            "fixedShippingRateOnly": false,
'            "imageUrl": "https://ecwid-images-ru.gcdn.co/images/5035009/389900000.jpg",
'            "smallThumbnailUrl": "https://ecwid-images-ru.gcdn.co/images/5035009/475772545.jpg",
'            "hdThumbnailUrl": "https://ecwid-images-ru.gcdn.co/images/5035009/408631478.jpg",
'            "fixedShippingRate": 0,
'            "digital": false,
'            "couponApplied": true,
'            "selectedOptions": [
'              {
'                "name": "Color",
'                "value": "White",
'                "valuesArray": [
'                  "White"
'                ],
'                "selections": [
'                  {
'                    "selectionTitle": "White",
'                    "selectionModifier": 0,
'                    "selectionModifierType": "ABSOLUTE"
'                  }
'                ],
'                "type": "CHOICE"
'              },
'              {
'                "name": "Size",
'                "value": "11oz",
'                "valuesArray": [
'                  "11oz"
'                ],
'                "selections": [
'                  {
'                    "selectionTitle": "11oz",
'                    "selectionModifier": 0,
'                    "selectionModifierType": "ABSOLUTE"
'                  }
'                ],
'                "type": "CHOICE"
'              },
'              {
'                "name": "Price-Optimizer",
'                "value": "4",
'                "valuesArray": [
'                  "4"
'                ],
'                "selections": [
'                  {
'                    "selectionTitle": "4",
'                    "selectionModifier": 4,
'                    "selectionModifierType": "PERCENT"
'                  }
'                ],
'                "type": "CHOICE"
'              }
'            ],
'            "taxes": [
'              {
'                "name": "State tax",
'                "value": 12,
'                "total": 59.05,
'                "taxOnDiscountedSubtotal": 1.95,
'                "taxOnShipping": 57.1,
'                "includeInPrice": false
'              },
'              {
'                "name": "TVA",
'                "value": 20,
'                "total": 98.42,
'                "taxOnDiscountedSubtotal": 3.25,
'                "taxOnShipping": 95.17,
'                "includeInPrice": true
'              }
'            ],
'            "dimensions": {
'              "length": 0,
'              "width": 0,
'              "height": 0
'            },
'            "couponAmount": 0.34,
'            "discounts": [
'              {
'                "discountInfo": {
'                  "value": 4,
'                  "type": "ABS",
'                  "base": "ON_TOTAL",
'                  "orderTotal": 1
'                },
'                "total": 0.06
'              }
'            ]
'          },
'          {
'            "subscriptionId": 123456,
'            "recurringChargeSettings": {
'              "recurringInterval": "month",
'              "recurringIntervalCount": 1
'            }
'          }
'        ],
'        "refundedAmount": 3.5,
'        "refunds": [
'          {
'            "date": "2017-09-12 10:12:56 +0000",
'            "source": "CP",
'            "reason": "Testing!",
'            "amount": 3.5
'          }
'        ],
'        "billingPerson": {
'          "name": "Michael Scott",
'          "companyName": "",
'          "street": "555 Lackawanna Ave",
'          "city": "Scranton",
'          "countryCode": "US",
'          "countryName": "United States",
'          "postalCode": "18508",
'          "stateOrProvinceCode": "PA",
'          "stateOrProvinceName": "Pennsylvania",
'          "phone": ""
'        },
'        "shippingPerson": {
'          "name": "Michael Scott",
'          "companyName": "",
'          "street": "555 Lackawanna Ave",
'          "city": "Scranton",
'          "countryCode": "US",
'          "countryName": "United States",
'          "postalCode": "18508",
'          "stateOrProvinceCode": "PA",
'          "stateOrProvinceName": "Pennsylvania",
'          "phone": ""
'        },
'        "shippingOption": {
'          "shippingCarrierName": "Shipping app the-printful",
'          "shippingMethodName": "USPS Priority Mail",
'          "shippingRate": 471.85,
'          "estimatedTransitTime": "1-3",
'          "isPickup": false
'        },
'        "handlingFee": {
'          "name": "Handling Fee",
'          "value": 4,
'          "description": ""
'        },
'        "predictedPackage": [
'          {
'            "length": 0,
'            "width": 0,
'            "height": 0,
'            "weight": 0.4,
'            "declaredValue": 1076.64
'          }
'        ],
'        "shipments": [
'          {
'            "id": "5e79bd4f-9ebf-4ab8-b901-24c9b48b19eb",
'            "created": "2020-04-23 19:13:43 +0000",
'            "shipTo": {
'              "name": "Michael Scott",
'              "companyName": "",
'              "street": "555 Lackawanna Ave",
'              "city": "Scranton",
'              "countryCode": "US",
'              "countryName": "United States",
'              "postalCode": "18508",
'              "stateOrProvinceCode": "PA",
'              "stateOrProvinceName": "Pennsylvania",
'              "phone": ""
'            },
'            "shipFrom": {
'              "companyName": "Roga Kopyty Inc",
'              "street": "444 fff",
'              "city": "New York",
'              "countryCode": "US",
'              "countryName": "United States",
'              "postalCode": "10001",
'              "stateOrProvinceCode": "NY",
'              "stateOrProvinceName": "New York",
'              "phone": "1011991919"
'            },
'            "parcel": {
'              "weight": 0.5,
'              "weightUnit": 'KILOGRAM',
'              "width": 10,
'              "height": 10,
'              "length": 10,
'              "dimensionUnit": 'CM'
'            },
'            "shippingService": {
'              "carrier": 'USPS',
'              "carrierName": 'Shipping,
'              "carrierServiceName": "Priority Mail",
'              "carrierServiceCode": "usps_priority"
'            },
'            "tracking": {
'              "tracking_number": "9499907123456123456781",
'              "tracking_url": "https://tools.usps.com/go/TrackConfirmAction_input?origTrackNum=9499907123456123456781",
'              "estimatedDays": 3
'            },
'            "shippingLabel": {
'              "label_url": "https://shippo-delivery.s3.amazonaws.com/70ae8117ee1749e393f249d5b77c45e0.pdf?Signature=vDw1ltcyGveVR1OQoUDdzC43BY8%3D&Expires=1437093830&AWSAccessKeyId=AKIAJTHP3LLFMYAWALIA",
'              "commercial_invoice_url": ""
'            }
'          }
'        ],
'        "taxesOnShipping": [
'          {
'            "name": "State tax",
'            "value": 12,
'            "total": 57.1
'          },
'          {
'            "name": "TVA",
'            "value": 20,
'            "total": 95.17
'          }
'        ],
'        "paymentModule": "CUSTOM_PAYMENT_APP-mollie-pg",
'        "additionalInfo": {
'          "google_customer_id": "2008512504.1526280224"
'        },
'        "paymentParams": {},
'        "orderExtraFields": [
'          {
'            "id": "lang",
'            "value": "en",
'            "customerInputType": "",
'            "title": "",
'            "orderDetailsDisplaySection": "",
'            "orderBy": "1"
'          },
'          {
'            "id": "askHowYouFoundUsApp",
'            "value": "From a friend",
'            "customerInputType": "SELECT",
'            "title": "How did you hear about us?",
'            "orderDetailsDisplaySection": "order_comments",
'            "orderBy": "2"
'          }
'        ],
'        "acceptMarketing": true,
'        "refererId": "Amazon",
'        "disableAllCustomerNotifications": false,
'        "externalFulfillment": false,
'        "pricesIncludeTax": false
'      }
'    ]
'  }

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

set json1 = Server.CreateObject("Chilkat.JsonObject")

total = jResp.IntOf("total")
count = jResp.IntOf("count")
offset = jResp.IntOf("offset")
limit = jResp.IntOf("limit")
i = 0
count_i = jResp.SizeOfArray("items")
Do While i < count_i
    jResp.I = i
    id = jResp.StringOf("items[i].id")
    subtotal = jResp.StringOf("items[i].subtotal")
    total_str = jResp.StringOf("items[i].total")
    giftCardRedemption = jResp.StringOf("items[i].giftCardRedemption")
    totalBeforeGiftCardRedemption = jResp.StringOf("items[i].totalBeforeGiftCardRedemption")
    giftCardDoubleSpending = jResp.BoolOf("items[i].giftCardDoubleSpending")
    usdTotal = jResp.StringOf("items[i].usdTotal")
    tax = jResp.StringOf("items[i].tax")
    paymentMethod = jResp.StringOf("items[i].paymentMethod")
    paymentStatus = jResp.StringOf("items[i].paymentStatus")
    fulfillmentStatus = jResp.StringOf("items[i].fulfillmentStatus")
    vendorOrderNumber = jResp.StringOf("items[i].vendorOrderNumber")
    orderNumber = jResp.IntOf("items[i].orderNumber")
    refererUrl = jResp.StringOf("items[i].refererUrl")
    globalReferer = jResp.StringOf("items[i].globalReferer")
    createDate = jResp.StringOf("items[i].createDate")
    updateDate = jResp.StringOf("items[i].updateDate")
    createTimestamp = jResp.IntOf("items[i].createTimestamp")
    updateTimestamp = jResp.IntOf("items[i].updateTimestamp")
    hidden = jResp.BoolOf("items[i].hidden")
    orderComments = jResp.StringOf("items[i].orderComments")
    privateAdminNotes = jResp.StringOf("items[i].privateAdminNotes")
    email = jResp.StringOf("items[i].email")
    ipAddress = jResp.StringOf("items[i].ipAddress")
    customerId = jResp.IntOf("items[i].customerId")
    customerGroupId = jResp.IntOf("items[i].customerGroupId")
    customerGroup = jResp.StringOf("items[i].customerGroup")
    customerTaxExempt = jResp.BoolOf("items[i].customerTaxExempt")
    customerTaxId = jResp.StringOf("items[i].customerTaxId")
    customerTaxIdValid = jResp.BoolOf("items[i].customerTaxIdValid")
    reversedTaxApplied = jResp.BoolOf("items[i].reversedTaxApplied")
    discount = jResp.IntOf("items[i].discount")
    couponDiscount = jResp.IntOf("items[i].couponDiscount")
    volumeDiscount = jResp.IntOf("items[i].volumeDiscount")
    membershipBasedDiscount = jResp.IntOf("items[i].membershipBasedDiscount")
    totalAndMembershipBasedDiscount = jResp.IntOf("items[i].totalAndMembershipBasedDiscount")
    discountCouponId = jResp.IntOf("items[i].discountCoupon.id")
    discountCouponName = jResp.StringOf("items[i].discountCoupon.name")
    discountCouponCode = jResp.StringOf("items[i].discountCoupon.code")
    discountCouponDiscountType = jResp.StringOf("items[i].discountCoupon.discountType")
    discountCouponStatus = jResp.StringOf("items[i].discountCoupon.status")
    discountCouponDiscount = jResp.IntOf("items[i].discountCoupon.discount")
    discountCouponLaunchDate = jResp.StringOf("items[i].discountCoupon.launchDate")
    discountCouponUsesLimit = jResp.StringOf("items[i].discountCoupon.usesLimit")
    discountCouponApplicationLimit = jResp.StringOf("items[i].discountCoupon.applicationLimit")
    discountCouponCreationDate = jResp.StringOf("items[i].discountCoupon.creationDate")
    discountCouponUpdateDate = jResp.StringOf("items[i].discountCoupon.updateDate")
    discountCouponOrderCount = jResp.IntOf("items[i].discountCoupon.orderCount")
    refundedAmount = jResp.StringOf("items[i].refundedAmount")
    billingPersonName = jResp.StringOf("items[i].billingPerson.name")
    billingPersonCompanyName = jResp.StringOf("items[i].billingPerson.companyName")
    billingPersonStreet = jResp.StringOf("items[i].billingPerson.street")
    billingPersonCity = jResp.StringOf("items[i].billingPerson.city")
    billingPersonCountryCode = jResp.StringOf("items[i].billingPerson.countryCode")
    billingPersonCountryName = jResp.StringOf("items[i].billingPerson.countryName")
    billingPersonPostalCode = jResp.StringOf("items[i].billingPerson.postalCode")
    billingPersonStateOrProvinceCode = jResp.StringOf("items[i].billingPerson.stateOrProvinceCode")
    billingPersonStateOrProvinceName = jResp.StringOf("items[i].billingPerson.stateOrProvinceName")
    billingPersonPhone = jResp.StringOf("items[i].billingPerson.phone")
    shippingPersonName = jResp.StringOf("items[i].shippingPerson.name")
    shippingPersonCompanyName = jResp.StringOf("items[i].shippingPerson.companyName")
    shippingPersonStreet = jResp.StringOf("items[i].shippingPerson.street")
    shippingPersonCity = jResp.StringOf("items[i].shippingPerson.city")
    shippingPersonCountryCode = jResp.StringOf("items[i].shippingPerson.countryCode")
    shippingPersonCountryName = jResp.StringOf("items[i].shippingPerson.countryName")
    shippingPersonPostalCode = jResp.StringOf("items[i].shippingPerson.postalCode")
    shippingPersonStateOrProvinceCode = jResp.StringOf("items[i].shippingPerson.stateOrProvinceCode")
    shippingPersonStateOrProvinceName = jResp.StringOf("items[i].shippingPerson.stateOrProvinceName")
    shippingPersonPhone = jResp.StringOf("items[i].shippingPerson.phone")
    shippingOptionShippingCarrierName = jResp.StringOf("items[i].shippingOption.shippingCarrierName")
    shippingOptionShippingMethodName = jResp.StringOf("items[i].shippingOption.shippingMethodName")
    shippingOptionShippingRate = jResp.StringOf("items[i].shippingOption.shippingRate")
    shippingOptionEstimatedTransitTime = jResp.StringOf("items[i].shippingOption.estimatedTransitTime")
    shippingOptionIsPickup = jResp.BoolOf("items[i].shippingOption.isPickup")
    handlingFeeName = jResp.StringOf("items[i].handlingFee.name")
    handlingFeeValue = jResp.IntOf("items[i].handlingFee.value")
    handlingFeeDescription = jResp.StringOf("items[i].handlingFee.description")
    paymentModule = jResp.StringOf("items[i].paymentModule")
    additionalInfoGoogle_customer_id = jResp.StringOf("items[i].additionalInfo.google_customer_id")
    acceptMarketing = jResp.BoolOf("items[i].acceptMarketing")
    refererId = jResp.StringOf("items[i].refererId")
    disableAllCustomerNotifications = jResp.BoolOf("items[i].disableAllCustomerNotifications")
    externalFulfillment = jResp.BoolOf("items[i].externalFulfillment")
    pricesIncludeTax = jResp.BoolOf("items[i].pricesIncludeTax")
    j = 0
    count_j = jResp.SizeOfArray("items[i].customDiscount")
    Do While j < count_j
        jResp.J = j
        j = j + 1
    Loop
    j = 0
    count_j = jResp.SizeOfArray("items[i].discountInfo")
    Do While j < count_j
        jResp.J = j
        value = jResp.IntOf("items[i].discountInfo[j].value")
        v_type = jResp.StringOf("items[i].discountInfo[j].type")
        base = jResp.StringOf("items[i].discountInfo[j].base")
        orderTotal = jResp.IntOf("items[i].discountInfo[j].orderTotal")
        j = j + 1
    Loop
    j = 0
    count_j = jResp.SizeOfArray("items[i].items")
    Do While j < count_j
        jResp.J = j
        id_int = jResp.IntOf("items[i].items[j].id")
        productId = jResp.IntOf("items[i].items[j].productId")
        categoryId = jResp.IntOf("items[i].items[j].categoryId")
        price = jResp.IntOf("items[i].items[j].price")
        productPrice = jResp.IntOf("items[i].items[j].productPrice")
        sku = jResp.StringOf("items[i].items[j].sku")
        quantity = jResp.IntOf("items[i].items[j].quantity")
        shortDescription = jResp.StringOf("items[i].items[j].shortDescription")
        tax = jResp.StringOf("items[i].items[j].tax")
        shipping = jResp.IntOf("items[i].items[j].shipping")
        quantityInStock = jResp.IntOf("items[i].items[j].quantityInStock")
        name = jResp.StringOf("items[i].items[j].name")
        isShippingRequired = jResp.BoolOf("items[i].items[j].isShippingRequired")
        weight = jResp.IntOf("items[i].items[j].weight")
        trackQuantity = jResp.BoolOf("items[i].items[j].trackQuantity")
        fixedShippingRateOnly = jResp.BoolOf("items[i].items[j].fixedShippingRateOnly")
        imageUrl = jResp.StringOf("items[i].items[j].imageUrl")
        smallThumbnailUrl = jResp.StringOf("items[i].items[j].smallThumbnailUrl")
        hdThumbnailUrl = jResp.StringOf("items[i].items[j].hdThumbnailUrl")
        fixedShippingRate = jResp.IntOf("items[i].items[j].fixedShippingRate")
        digital = jResp.BoolOf("items[i].items[j].digital")
        couponApplied = jResp.BoolOf("items[i].items[j].couponApplied")
        dimensionsLength = jResp.IntOf("items[i].items[j].dimensions.length")
        dimensionsWidth = jResp.IntOf("items[i].items[j].dimensions.width")
        dimensionsHeight = jResp.IntOf("items[i].items[j].dimensions.height")
        couponAmount = jResp.StringOf("items[i].items[j].couponAmount")
        subscriptionId = jResp.IntOf("items[i].items[j].subscriptionId")
        recurringChargeSettingsRecurringInterval = jResp.StringOf("items[i].items[j].recurringChargeSettings.recurringInterval")
        recurringChargeSettingsRecurringIntervalCount = jResp.IntOf("items[i].items[j].recurringChargeSettings.recurringIntervalCount")
        k = 0
        count_k = jResp.SizeOfArray("items[i].items[j].selectedOptions")
        Do While k < count_k
            jResp.K = k
            name = jResp.StringOf("items[i].items[j].selectedOptions[k].name")
            value_str = jResp.StringOf("items[i].items[j].selectedOptions[k].value")
            v_type = jResp.StringOf("items[i].items[j].selectedOptions[k].type")
            success = jResp.ObjectOf2("items[i].items[j].selectedOptions[k]",json1)

            i1 = 0
            count_i1 = json1.SizeOfArray("valuesArray")
            Do While i1 < count_i1
                json1.I = i1
                strVal = json1.StringOf("valuesArray[i]")
                i1 = i1 + 1
            Loop

            success = jResp.ObjectOf2("items[i].items[j].selectedOptions[k]",json1)
            i1 = 0
            count_i1 = json1.SizeOfArray("selections")
            Do While i1 < count_i1
                json1.I = i1
                selectionTitle = json1.StringOf("selections[i].selectionTitle")
                selectionModifier = json1.IntOf("selections[i].selectionModifier")
                selectionModifierType = json1.StringOf("selections[i].selectionModifierType")
                i1 = i1 + 1
            Loop
            k = k + 1
        Loop
        k = 0
        count_k = jResp.SizeOfArray("items[i].items[j].taxes")
        Do While k < count_k
            jResp.K = k
            name = jResp.StringOf("items[i].items[j].taxes[k].name")
            value = jResp.IntOf("items[i].items[j].taxes[k].value")
            total_str = jResp.StringOf("items[i].items[j].taxes[k].total")
            taxOnDiscountedSubtotal = jResp.StringOf("items[i].items[j].taxes[k].taxOnDiscountedSubtotal")
            taxOnShipping = jResp.IntOf("items[i].items[j].taxes[k].taxOnShipping")
            includeInPrice = jResp.BoolOf("items[i].items[j].taxes[k].includeInPrice")
            k = k + 1
        Loop
        k = 0
        count_k = jResp.SizeOfArray("items[i].items[j].discounts")
        Do While k < count_k
            jResp.K = k
            discountInfoValue = jResp.IntOf("items[i].items[j].discounts[k].discountInfo.value")
            discountInfoType = jResp.StringOf("items[i].items[j].discounts[k].discountInfo.type")
            discountInfoBase = jResp.StringOf("items[i].items[j].discounts[k].discountInfo.base")
            discountInfoOrderTotal = jResp.IntOf("items[i].items[j].discounts[k].discountInfo.orderTotal")
            total_str = jResp.StringOf("items[i].items[j].discounts[k].total")
            k = k + 1
        Loop
        j = j + 1
    Loop
    j = 0
    count_j = jResp.SizeOfArray("items[i].refunds")
    Do While j < count_j
        jResp.J = j
        date = jResp.StringOf("items[i].refunds[j].date")
        source = jResp.StringOf("items[i].refunds[j].source")
        reason = jResp.StringOf("items[i].refunds[j].reason")
        amount = jResp.StringOf("items[i].refunds[j].amount")
        j = j + 1
    Loop
    j = 0
    count_j = jResp.SizeOfArray("items[i].predictedPackage")
    Do While j < count_j
        jResp.J = j
        length = jResp.IntOf("items[i].predictedPackage[j].length")
        width = jResp.IntOf("items[i].predictedPackage[j].width")
        height = jResp.IntOf("items[i].predictedPackage[j].height")
        weight_str = jResp.StringOf("items[i].predictedPackage[j].weight")
        declaredValue = jResp.StringOf("items[i].predictedPackage[j].declaredValue")
        j = j + 1
    Loop
    j = 0
    count_j = jResp.SizeOfArray("items[i].shipments")
    Do While j < count_j
        jResp.J = j
        id = jResp.StringOf("items[i].shipments[j].id")
        created = jResp.StringOf("items[i].shipments[j].created")
        shipToName = jResp.StringOf("items[i].shipments[j].shipTo.name")
        shipToCompanyName = jResp.StringOf("items[i].shipments[j].shipTo.companyName")
        shipToStreet = jResp.StringOf("items[i].shipments[j].shipTo.street")
        shipToCity = jResp.StringOf("items[i].shipments[j].shipTo.city")
        shipToCountryCode = jResp.StringOf("items[i].shipments[j].shipTo.countryCode")
        shipToCountryName = jResp.StringOf("items[i].shipments[j].shipTo.countryName")
        shipToPostalCode = jResp.StringOf("items[i].shipments[j].shipTo.postalCode")
        shipToStateOrProvinceCode = jResp.StringOf("items[i].shipments[j].shipTo.stateOrProvinceCode")
        shipToStateOrProvinceName = jResp.StringOf("items[i].shipments[j].shipTo.stateOrProvinceName")
        shipToPhone = jResp.StringOf("items[i].shipments[j].shipTo.phone")
        shipFromCompanyName = jResp.StringOf("items[i].shipments[j].shipFrom.companyName")
        shipFromStreet = jResp.StringOf("items[i].shipments[j].shipFrom.street")
        shipFromCity = jResp.StringOf("items[i].shipments[j].shipFrom.city")
        shipFromCountryCode = jResp.StringOf("items[i].shipments[j].shipFrom.countryCode")
        shipFromCountryName = jResp.StringOf("items[i].shipments[j].shipFrom.countryName")
        shipFromPostalCode = jResp.StringOf("items[i].shipments[j].shipFrom.postalCode")
        shipFromStateOrProvinceCode = jResp.StringOf("items[i].shipments[j].shipFrom.stateOrProvinceCode")
        shipFromStateOrProvinceName = jResp.StringOf("items[i].shipments[j].shipFrom.stateOrProvinceName")
        shipFromPhone = jResp.StringOf("items[i].shipments[j].shipFrom.phone")
        parcelWeight = jResp.StringOf("items[i].shipments[j].parcel.weight")
        parcelWeightUnit = jResp.IntOf("items[i].shipments[j].parcel.weightUnit")
        parcelWidth = jResp.IntOf("items[i].shipments[j].parcel.width")
        parcelHeight = jResp.IntOf("items[i].shipments[j].parcel.height")
        parcelLength = jResp.IntOf("items[i].shipments[j].parcel.length")
        parcelDimensionUnit = jResp.IntOf("items[i].shipments[j].parcel.dimensionUnit")
        shippingServiceCarrier = jResp.IntOf("items[i].shipments[j].shippingService.carrier")
        shippingServiceCarrierName = jResp.IntOf("items[i].shipments[j].shippingService.carrierName")
        shippingServiceCarrierServiceName = jResp.StringOf("items[i].shipments[j].shippingService.carrierServiceName")
        shippingServiceCarrierServiceCode = jResp.StringOf("items[i].shipments[j].shippingService.carrierServiceCode")
        trackingTracking_number = jResp.StringOf("items[i].shipments[j].tracking.tracking_number")
        trackingTracking_url = jResp.StringOf("items[i].shipments[j].tracking.tracking_url")
        trackingEstimatedDays = jResp.IntOf("items[i].shipments[j].tracking.estimatedDays")
        shippingLabelLabel_url = jResp.StringOf("items[i].shipments[j].shippingLabel.label_url")
        shippingLabelCommercial_invoice_url = jResp.StringOf("items[i].shipments[j].shippingLabel.commercial_invoice_url")
        j = j + 1
    Loop
    j = 0
    count_j = jResp.SizeOfArray("items[i].taxesOnShipping")
    Do While j < count_j
        jResp.J = j
        name = jResp.StringOf("items[i].taxesOnShipping[j].name")
        value = jResp.IntOf("items[i].taxesOnShipping[j].value")
        total_str = jResp.StringOf("items[i].taxesOnShipping[j].total")
        j = j + 1
    Loop
    j = 0
    count_j = jResp.SizeOfArray("items[i].orderExtraFields")
    Do While j < count_j
        jResp.J = j
        id = jResp.StringOf("items[i].orderExtraFields[j].id")
        value_str = jResp.StringOf("items[i].orderExtraFields[j].value")
        customerInputType = jResp.StringOf("items[i].orderExtraFields[j].customerInputType")
        title = jResp.StringOf("items[i].orderExtraFields[j].title")
        orderDetailsDisplaySection = jResp.StringOf("items[i].orderExtraFields[j].orderDetailsDisplaySection")
        orderBy = jResp.StringOf("items[i].orderExtraFields[j].orderBy")
        j = j + 1
    Loop
    i = i + 1
Loop

%>
</body>
</html>