Sample code for 30+ languages & platforms
Classic ASP

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>