B4X Requires Chilkat v11.0.0+
B4X
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 B4X Downloads
Dim success As Boolean = False
' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
Dim http As ChilkatHttp
http.Initialize("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
Dim jsonToken As ChilkatJsonObject
jsonToken.Initialize
jsonToken.LoadFile("qa_data/tokens/ecwid.json")
http.SetRequestHeader("Accept", "application/json")
Dim params As ChilkatJsonObject
params.Initialize
params.UpdateInt("limit", 100)
params.UpdateString("email", "joe@example.com")
params.UpdateString("token", jsonToken.StringOf("access_token"))
Dim resp As ChilkatHttpResponse
resp.Initialize
success = http.HttpParams("GET", "https://app.ecwid.com/api/v3/storeId/orders", params, resp)
If success = False Then
Log(http.LastErrorText)
Return
End If
Dim sbResponseBody As ChilkatStringBuilder
sbResponseBody.Initialize
resp.GetBodySb(sbResponseBody)
Dim jResp As ChilkatJsonObject
jResp.Initialize
jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False
Log("Response Body:")
Log(jResp.Emit)
Dim respStatusCode As Int = resp.StatusCode
Log("Response Status Code = " & respStatusCode)
If respStatusCode <> 200 Then
Log("Failed.")
Return
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 Int
Dim refererUrl As String
Dim globalReferer As String
Dim createDate As String
Dim updateDate As String
Dim createTimestamp As Int
Dim updateTimestamp As Int
Dim hidden As Boolean
Dim orderComments As String
Dim privateAdminNotes As String
Dim email As String
Dim ipAddress As String
Dim customerId As Int
Dim customerGroupId As Int
Dim customerGroup As String
Dim customerTaxExempt As Boolean
Dim customerTaxId As String
Dim customerTaxIdValid As Boolean
Dim reversedTaxApplied As Boolean
Dim discount As Int
Dim couponDiscount As Int
Dim volumeDiscount As Int
Dim membershipBasedDiscount As Int
Dim totalAndMembershipBasedDiscount As Int
Dim discountCouponId As Int
Dim discountCouponName As String
Dim discountCouponCode As String
Dim discountCouponDiscountType As String
Dim discountCouponStatus As String
Dim discountCouponDiscount As Int
Dim discountCouponLaunchDate As String
Dim discountCouponUsesLimit As String
Dim discountCouponApplicationLimit As String
Dim discountCouponCreationDate As String
Dim discountCouponUpdateDate As String
Dim discountCouponOrderCount As Int
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 Int
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 Int
Dim count_j As Int
Dim value As Int
Dim v_type As String
Dim base As String
Dim orderTotal As Int
Dim id_int As Int
Dim productId As Int
Dim categoryId As Int
Dim price As Int
Dim productPrice As Int
Dim sku As String
Dim quantity As Int
Dim shortDescription As String
Dim shipping As Int
Dim quantityInStock As Int
Dim name As String
Dim isShippingRequired As Boolean
Dim weight As Int
Dim trackQuantity As Boolean
Dim fixedShippingRateOnly As Boolean
Dim imageUrl As String
Dim smallThumbnailUrl As String
Dim hdThumbnailUrl As String
Dim fixedShippingRate As Int
Dim digital As Boolean
Dim couponApplied As Boolean
Dim dimensionsLength As Int
Dim dimensionsWidth As Int
Dim dimensionsHeight As Int
Dim couponAmount As String
Dim subscriptionId As Int
Dim recurringChargeSettingsRecurringInterval As String
Dim recurringChargeSettingsRecurringIntervalCount As Int
Dim k As Int
Dim count_k As Int
Dim value_str As String
Dim json1 As ChilkatJsonObject
json1.Initialize
Dim i1 As Int
Dim count_i1 As Int
Dim strVal As String
Dim selectionTitle As String
Dim selectionModifier As Int
Dim selectionModifierType As String
Dim taxOnDiscountedSubtotal As String
Dim taxOnShipping As Int
Dim includeInPrice As Boolean
Dim discountInfoValue As Int
Dim discountInfoType As String
Dim discountInfoBase As String
Dim discountInfoOrderTotal As Int
Dim date As String
Dim source As String
Dim reason As String
Dim amount As String
Dim length As Int
Dim width As Int
Dim height As Int
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 Int
Dim parcelWidth As Int
Dim parcelHeight As Int
Dim parcelLength As Int
Dim parcelDimensionUnit As Int
Dim shippingServiceCarrier As Int
Dim shippingServiceCarrierName As Int
Dim shippingServiceCarrierServiceName As String
Dim shippingServiceCarrierServiceCode As String
Dim trackingTracking_number As String
Dim trackingTracking_url As String
Dim trackingEstimatedDays As Int
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 Int = jResp.IntOf("total")
Dim count As Int = jResp.IntOf("count")
Dim offset As Int = jResp.IntOf("offset")
Dim limit As Int = jResp.IntOf("limit")
Dim i As Int = 0
Dim count_i As Int = 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")
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
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