(Visual Basic 6.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.

For more information, see https://api-docs.ecwid.com/reference/orders#search-orders

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

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

Dim http As New ChilkatHttp
Dim success As Long

' 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
Dim jsonToken As New ChilkatJsonObject
success = jsonToken.LoadFile("qa_data/tokens/ecwid.json")

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

Dim params As New ChilkatJsonObject
success = params.UpdateInt("limit",100)
success = params.UpdateString("email","joe@example.com")
success = params.UpdateString("token",jsonToken.StringOf("access_token"))

Dim resp As ChilkatHttpResponse
Set resp = http.QuickRequestParams("GET","https://app.ecwid.com/api/v3/storeId/orders",params)
If (http.LastMethodSuccess = 0) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim sbResponseBody As New ChilkatStringBuilder
success = resp.GetBodySb(sbResponseBody)
Dim jResp As New ChilkatJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = 0

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

Dim respStatusCode As Long
respStatusCode = resp.StatusCode

Debug.Print "Response Status Code = " & respStatusCode
If (respStatusCode <> 200) Then
    Debug.Print "Failed."
    Exit Sub
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

Dim id As String
Dim subtotal As String
Dim total_str As String
Dim giftCardRedemption As String
Dim totalBeforeGiftCardRedemption As String
Dim giftCardDoubleSpending As Long
Dim usdTotal As String
Dim tax As String
Dim paymentMethod As String
Dim paymentStatus As String
Dim fulfillmentStatus As String
Dim vendorOrderNumber As String
Dim orderNumber As Long
Dim refererUrl As String
Dim globalReferer As String
Dim createDate As String
Dim updateDate As String
Dim createTimestamp As Long
Dim updateTimestamp As Long
Dim hidden As Long
Dim orderComments As String
Dim privateAdminNotes As String
Dim email As String
Dim ipAddress As String
Dim customerId As Long
Dim customerGroupId As Long
Dim customerGroup As String
Dim customerTaxExempt As Long
Dim customerTaxId As String
Dim customerTaxIdValid As Long
Dim reversedTaxApplied As Long
Dim discount As Long
Dim couponDiscount As Long
Dim volumeDiscount As Long
Dim membershipBasedDiscount As Long
Dim totalAndMembershipBasedDiscount As Long
Dim discountCouponId As Long
Dim discountCouponName As String
Dim discountCouponCode As String
Dim discountCouponDiscountType As String
Dim discountCouponStatus As String
Dim discountCouponDiscount As Long
Dim discountCouponLaunchDate As String
Dim discountCouponUsesLimit As String
Dim discountCouponApplicationLimit As String
Dim discountCouponCreationDate As String
Dim discountCouponUpdateDate As String
Dim discountCouponOrderCount As Long
Dim refundedAmount As String
Dim billingPersonName As String
Dim billingPersonCompanyName As String
Dim billingPersonStreet As String
Dim billingPersonCity As String
Dim billingPersonCountryCode As String
Dim billingPersonCountryName As String
Dim billingPersonPostalCode As String
Dim billingPersonStateOrProvinceCode As String
Dim billingPersonStateOrProvinceName As String
Dim billingPersonPhone As String
Dim shippingPersonName As String
Dim shippingPersonCompanyName As String
Dim shippingPersonStreet As String
Dim shippingPersonCity As String
Dim shippingPersonCountryCode As String
Dim shippingPersonCountryName As String
Dim shippingPersonPostalCode As String
Dim shippingPersonStateOrProvinceCode As String
Dim shippingPersonStateOrProvinceName As String
Dim shippingPersonPhone As String
Dim shippingOptionShippingCarrierName As String
Dim shippingOptionShippingMethodName As String
Dim shippingOptionShippingRate As String
Dim shippingOptionEstimatedTransitTime As String
Dim shippingOptionIsPickup As Long
Dim handlingFeeName As String
Dim handlingFeeValue As Long
Dim handlingFeeDescription As String
Dim paymentModule As String
Dim additionalInfoGoogle_customer_id As String
Dim acceptMarketing As Long
Dim refererId As String
Dim disableAllCustomerNotifications As Long
Dim externalFulfillment As Long
Dim pricesIncludeTax As Long
Dim j As Long
Dim count_j As Long
Dim value As Long
Dim v_type As String
Dim base As String
Dim orderTotal As Long
Dim id_int As Long
Dim productId As Long
Dim categoryId As Long
Dim price As Long
Dim productPrice As Long
Dim sku As String
Dim quantity As Long
Dim shortDescription As String
Dim shipping As Long
Dim quantityInStock As Long
Dim name As String
Dim isShippingRequired As Long
Dim weight As Long
Dim trackQuantity As Long
Dim fixedShippingRateOnly As Long
Dim imageUrl As String
Dim smallThumbnailUrl As String
Dim hdThumbnailUrl As String
Dim fixedShippingRate As Long
Dim digital As Long
Dim couponApplied As Long
Dim dimensionsLength As Long
Dim dimensionsWidth As Long
Dim dimensionsHeight As Long
Dim couponAmount As String
Dim subscriptionId As Long
Dim recurringChargeSettingsRecurringInterval As String
Dim recurringChargeSettingsRecurringIntervalCount As Long
Dim k As Long
Dim count_k As Long
Dim value_str As String
Dim json1 As ChilkatJsonObject
Dim i1 As Long
Dim count_i1 As Long
Dim strVal As String
Dim selectionTitle As String
Dim selectionModifier As Long
Dim selectionModifierType As String
Dim taxOnDiscountedSubtotal As String
Dim taxOnShipping As Long
Dim includeInPrice As Long
Dim discountInfoValue As Long
Dim discountInfoType As String
Dim discountInfoBase As String
Dim discountInfoOrderTotal As Long
Dim date As String
Dim source As String
Dim reason As String
Dim amount As String
Dim length As Long
Dim width As Long
Dim height As Long
Dim weight_str As String
Dim declaredValue As String
Dim created As String
Dim shipToName As String
Dim shipToCompanyName As String
Dim shipToStreet As String
Dim shipToCity As String
Dim shipToCountryCode As String
Dim shipToCountryName As String
Dim shipToPostalCode As String
Dim shipToStateOrProvinceCode As String
Dim shipToStateOrProvinceName As String
Dim shipToPhone As String
Dim shipFromCompanyName As String
Dim shipFromStreet As String
Dim shipFromCity As String
Dim shipFromCountryCode As String
Dim shipFromCountryName As String
Dim shipFromPostalCode As String
Dim shipFromStateOrProvinceCode As String
Dim shipFromStateOrProvinceName As String
Dim shipFromPhone As String
Dim parcelWeight As String
Dim parcelWeightUnit As Long
Dim parcelWidth As Long
Dim parcelHeight As Long
Dim parcelLength As Long
Dim parcelDimensionUnit As Long
Dim shippingServiceCarrier As Long
Dim shippingServiceCarrierName As Long
Dim shippingServiceCarrierServiceName As String
Dim shippingServiceCarrierServiceCode As String
Dim trackingTracking_number As String
Dim trackingTracking_url As String
Dim trackingEstimatedDays As Long
Dim shippingLabelLabel_url As String
Dim shippingLabelCommercial_invoice_url As String
Dim customerInputType As String
Dim title As String
Dim orderDetailsDisplaySection As String
Dim orderBy As String

Dim total As Long
total = jResp.IntOf("total")
Dim count As Long
count = jResp.IntOf("count")
Dim offset As Long
offset = jResp.IntOf("offset")
Dim limit As Long
limit = jResp.IntOf("limit")
Dim i As Long
i = 0
Dim count_i As Long
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")

            Set json1 = jResp.ObjectOf("items[i].items[j].selectedOptions[k]")
            i1 = 0
            count_i1 = json1.SizeOfArray("valuesArray")
            Do While i1 < count_i1
                json1.I = i1
                strVal = json1.StringOf("valuesArray[i]")
                i1 = i1 + 1
            Loop

            Set json1 = jResp.ObjectOf("items[i].items[j].selectedOptions[k]")
            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