(VB.NET) 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 .NET Downloads Chilkat .NET Assemblies Chilkat for .NET Core Chilkat for Mono

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

Dim http As New Chilkat.Http
Dim success As Boolean

' 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 Chilkat.JsonObject
jsonToken.LoadFile("qa_data/tokens/ecwid.json")

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

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

Dim resp As Chilkat.HttpResponse = http.QuickRequestParams("GET","https://app.ecwid.com/api/v3/storeId/orders",params)
If (http.LastMethodSuccess = False) Then
    Debug.WriteLine(http.LastErrorText)
    Exit Sub
End If


Dim sbResponseBody As New Chilkat.StringBuilder
resp.GetBodySb(sbResponseBody)
Dim jResp As New Chilkat.JsonObject
jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False

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

Dim respStatusCode As Integer = resp.StatusCode


Debug.WriteLine("Response Status Code = " & respStatusCode)
If (respStatusCode <> 200) Then
    Debug.WriteLine("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 Boolean
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 Integer
Dim refererUrl As String
Dim globalReferer As String
Dim createDate As String
Dim updateDate As String
Dim createTimestamp As Integer
Dim updateTimestamp As Integer
Dim hidden As Boolean
Dim orderComments As String
Dim privateAdminNotes As String
Dim email As String
Dim ipAddress As String
Dim customerId As Integer
Dim customerGroupId As Integer
Dim customerGroup As String
Dim customerTaxExempt As Boolean
Dim customerTaxId As String
Dim customerTaxIdValid As Boolean
Dim reversedTaxApplied As Boolean
Dim discount As Integer
Dim couponDiscount As Integer
Dim volumeDiscount As Integer
Dim membershipBasedDiscount As Integer
Dim totalAndMembershipBasedDiscount As Integer
Dim discountCouponId As Integer
Dim discountCouponName As String
Dim discountCouponCode As String
Dim discountCouponDiscountType As String
Dim discountCouponStatus As String
Dim discountCouponDiscount As Integer
Dim discountCouponLaunchDate As String
Dim discountCouponUsesLimit As String
Dim discountCouponApplicationLimit As String
Dim discountCouponCreationDate As String
Dim discountCouponUpdateDate As String
Dim discountCouponOrderCount As Integer
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 Boolean
Dim handlingFeeName As String
Dim handlingFeeValue As Integer
Dim handlingFeeDescription As String
Dim paymentModule As String
Dim additionalInfoGoogle_customer_id As String
Dim acceptMarketing As Boolean
Dim refererId As String
Dim disableAllCustomerNotifications As Boolean
Dim externalFulfillment As Boolean
Dim pricesIncludeTax As Boolean
Dim j As Integer
Dim count_j As Integer
Dim value As Integer
Dim v_type As String
Dim base As String
Dim orderTotal As Integer
Dim id_int As Integer
Dim productId As Integer
Dim categoryId As Integer
Dim price As Integer
Dim productPrice As Integer
Dim sku As String
Dim quantity As Integer
Dim shortDescription As String
Dim shipping As Integer
Dim quantityInStock As Integer
Dim name As String
Dim isShippingRequired As Boolean
Dim weight As Integer
Dim trackQuantity As Boolean
Dim fixedShippingRateOnly As Boolean
Dim imageUrl As String
Dim smallThumbnailUrl As String
Dim hdThumbnailUrl As String
Dim fixedShippingRate As Integer
Dim digital As Boolean
Dim couponApplied As Boolean
Dim dimensionsLength As Integer
Dim dimensionsWidth As Integer
Dim dimensionsHeight As Integer
Dim couponAmount As String
Dim subscriptionId As Integer
Dim recurringChargeSettingsRecurringInterval As String
Dim recurringChargeSettingsRecurringIntervalCount As Integer
Dim k As Integer
Dim count_k As Integer
Dim value_str As String
Dim json1 As Chilkat.JsonObject
Dim i1 As Integer
Dim count_i1 As Integer
Dim strVal As String
Dim selectionTitle As String
Dim selectionModifier As Integer
Dim selectionModifierType As String
Dim taxOnDiscountedSubtotal As String
Dim taxOnShipping As Integer
Dim includeInPrice As Boolean
Dim discountInfoValue As Integer
Dim discountInfoType As String
Dim discountInfoBase As String
Dim discountInfoOrderTotal As Integer
Dim date As String
Dim source As String
Dim reason As String
Dim amount As String
Dim length As Integer
Dim width As Integer
Dim height As Integer
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 Integer
Dim parcelWidth As Integer
Dim parcelHeight As Integer
Dim parcelLength As Integer
Dim parcelDimensionUnit As Integer
Dim shippingServiceCarrier As Integer
Dim shippingServiceCarrierName As Integer
Dim shippingServiceCarrierServiceName As String
Dim shippingServiceCarrierServiceCode As String
Dim trackingTracking_number As String
Dim trackingTracking_url As String
Dim trackingEstimatedDays As Integer
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 Integer = jResp.IntOf("total")
Dim count As Integer = jResp.IntOf("count")
Dim offset As Integer = jResp.IntOf("offset")
Dim limit As Integer = jResp.IntOf("limit")
Dim i As Integer = 0
Dim count_i As Integer = jResp.SizeOfArray("items")
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")
    While j < count_j
        jResp.J = j
        j = j + 1
    End While
    j = 0
    count_j = jResp.SizeOfArray("items[i].discountInfo")
    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
    End While
    j = 0
    count_j = jResp.SizeOfArray("items[i].items")
    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")
        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")

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


            json1 = jResp.ObjectOf("items[i].items[j].selectedOptions[k]")
            i1 = 0
            count_i1 = json1.SizeOfArray("selections")
            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
            End While

            k = k + 1
        End While
        k = 0
        count_k = jResp.SizeOfArray("items[i].items[j].taxes")
        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
        End While
        k = 0
        count_k = jResp.SizeOfArray("items[i].items[j].discounts")
        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
        End While
        j = j + 1
    End While
    j = 0
    count_j = jResp.SizeOfArray("items[i].refunds")
    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
    End While
    j = 0
    count_j = jResp.SizeOfArray("items[i].predictedPackage")
    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
    End While
    j = 0
    count_j = jResp.SizeOfArray("items[i].shipments")
    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
    End While
    j = 0
    count_j = jResp.SizeOfArray("items[i].taxesOnShipping")
    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
    End While
    j = 0
    count_j = jResp.SizeOfArray("items[i].orderExtraFields")
    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
    End While
    i = i + 1
End While