Lianja
Lianja
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 Lianja Downloads
llSuccess = .F.
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
loHttp = createobject("CkHttp")
// 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
loJsonToken = createobject("CkJsonObject")
loJsonToken.LoadFile("qa_data/tokens/ecwid.json")
loHttp.SetRequestHeader("Accept","application/json")
loParams = createobject("CkJsonObject")
loParams.UpdateInt("limit",100)
loParams.UpdateString("email","joe@example.com")
loParams.UpdateString("token",loJsonToken.StringOf("access_token"))
loResp = createobject("CkHttpResponse")
llSuccess = loHttp.HttpParams("GET","https://app.ecwid.com/api/v3/storeId/orders",loParams,loResp)
if (llSuccess = .F.) then
? loHttp.LastErrorText
release loHttp
release loJsonToken
release loParams
release loResp
return
endif
loSbResponseBody = createobject("CkStringBuilder")
loResp.GetBodySb(loSbResponseBody)
loJResp = createobject("CkJsonObject")
loJResp.LoadSb(loSbResponseBody)
loJResp.EmitCompact = .F.
? "Response Body:"
? loJResp.Emit()
lnRespStatusCode = loResp.StatusCode
? "Response Status Code = " + str(lnRespStatusCode)
if (lnRespStatusCode <> 200) then
? "Failed."
release loHttp
release loJsonToken
release loParams
release loResp
release loSbResponseBody
release loJResp
return
endif
// 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
loJson1 = createobject("CkJsonObject")
lnTotal = loJResp.IntOf("total")
lnCount = loJResp.IntOf("count")
lnOffset = loJResp.IntOf("offset")
lnLimit = loJResp.IntOf("limit")
i = 0
lnCount_i = loJResp.SizeOfArray("items")
do while i < lnCount_i
loJResp.I = i
lcId = loJResp.StringOf("items[i].id")
lcSubtotal = loJResp.StringOf("items[i].subtotal")
lcTotal_str = loJResp.StringOf("items[i].total")
lcGiftCardRedemption = loJResp.StringOf("items[i].giftCardRedemption")
lcTotalBeforeGiftCardRedemption = loJResp.StringOf("items[i].totalBeforeGiftCardRedemption")
llGiftCardDoubleSpending = loJResp.BoolOf("items[i].giftCardDoubleSpending")
lcUsdTotal = loJResp.StringOf("items[i].usdTotal")
lcTax = loJResp.StringOf("items[i].tax")
lcPaymentMethod = loJResp.StringOf("items[i].paymentMethod")
lcPaymentStatus = loJResp.StringOf("items[i].paymentStatus")
lcFulfillmentStatus = loJResp.StringOf("items[i].fulfillmentStatus")
lcVendorOrderNumber = loJResp.StringOf("items[i].vendorOrderNumber")
lnOrderNumber = loJResp.IntOf("items[i].orderNumber")
lcRefererUrl = loJResp.StringOf("items[i].refererUrl")
lcGlobalReferer = loJResp.StringOf("items[i].globalReferer")
lcCreateDate = loJResp.StringOf("items[i].createDate")
lcUpdateDate = loJResp.StringOf("items[i].updateDate")
lnCreateTimestamp = loJResp.IntOf("items[i].createTimestamp")
lnUpdateTimestamp = loJResp.IntOf("items[i].updateTimestamp")
llHidden = loJResp.BoolOf("items[i].hidden")
lcOrderComments = loJResp.StringOf("items[i].orderComments")
lcPrivateAdminNotes = loJResp.StringOf("items[i].privateAdminNotes")
lcEmail = loJResp.StringOf("items[i].email")
lcIpAddress = loJResp.StringOf("items[i].ipAddress")
lnCustomerId = loJResp.IntOf("items[i].customerId")
lnCustomerGroupId = loJResp.IntOf("items[i].customerGroupId")
lcCustomerGroup = loJResp.StringOf("items[i].customerGroup")
llCustomerTaxExempt = loJResp.BoolOf("items[i].customerTaxExempt")
lcCustomerTaxId = loJResp.StringOf("items[i].customerTaxId")
llCustomerTaxIdValid = loJResp.BoolOf("items[i].customerTaxIdValid")
llReversedTaxApplied = loJResp.BoolOf("items[i].reversedTaxApplied")
lnDiscount = loJResp.IntOf("items[i].discount")
lnCouponDiscount = loJResp.IntOf("items[i].couponDiscount")
lnVolumeDiscount = loJResp.IntOf("items[i].volumeDiscount")
lnMembershipBasedDiscount = loJResp.IntOf("items[i].membershipBasedDiscount")
lnTotalAndMembershipBasedDiscount = loJResp.IntOf("items[i].totalAndMembershipBasedDiscount")
lnDiscountCouponId = loJResp.IntOf("items[i].discountCoupon.id")
lcDiscountCouponName = loJResp.StringOf("items[i].discountCoupon.name")
lcDiscountCouponCode = loJResp.StringOf("items[i].discountCoupon.code")
lcDiscountCouponDiscountType = loJResp.StringOf("items[i].discountCoupon.discountType")
lcDiscountCouponStatus = loJResp.StringOf("items[i].discountCoupon.status")
lnDiscountCouponDiscount = loJResp.IntOf("items[i].discountCoupon.discount")
lcDiscountCouponLaunchDate = loJResp.StringOf("items[i].discountCoupon.launchDate")
lcDiscountCouponUsesLimit = loJResp.StringOf("items[i].discountCoupon.usesLimit")
lcDiscountCouponApplicationLimit = loJResp.StringOf("items[i].discountCoupon.applicationLimit")
lcDiscountCouponCreationDate = loJResp.StringOf("items[i].discountCoupon.creationDate")
lcDiscountCouponUpdateDate = loJResp.StringOf("items[i].discountCoupon.updateDate")
lnDiscountCouponOrderCount = loJResp.IntOf("items[i].discountCoupon.orderCount")
lcRefundedAmount = loJResp.StringOf("items[i].refundedAmount")
lcBillingPersonName = loJResp.StringOf("items[i].billingPerson.name")
lcBillingPersonCompanyName = loJResp.StringOf("items[i].billingPerson.companyName")
lcBillingPersonStreet = loJResp.StringOf("items[i].billingPerson.street")
lcBillingPersonCity = loJResp.StringOf("items[i].billingPerson.city")
lcBillingPersonCountryCode = loJResp.StringOf("items[i].billingPerson.countryCode")
lcBillingPersonCountryName = loJResp.StringOf("items[i].billingPerson.countryName")
lcBillingPersonPostalCode = loJResp.StringOf("items[i].billingPerson.postalCode")
lcBillingPersonStateOrProvinceCode = loJResp.StringOf("items[i].billingPerson.stateOrProvinceCode")
lcBillingPersonStateOrProvinceName = loJResp.StringOf("items[i].billingPerson.stateOrProvinceName")
lcBillingPersonPhone = loJResp.StringOf("items[i].billingPerson.phone")
lcShippingPersonName = loJResp.StringOf("items[i].shippingPerson.name")
lcShippingPersonCompanyName = loJResp.StringOf("items[i].shippingPerson.companyName")
lcShippingPersonStreet = loJResp.StringOf("items[i].shippingPerson.street")
lcShippingPersonCity = loJResp.StringOf("items[i].shippingPerson.city")
lcShippingPersonCountryCode = loJResp.StringOf("items[i].shippingPerson.countryCode")
lcShippingPersonCountryName = loJResp.StringOf("items[i].shippingPerson.countryName")
lcShippingPersonPostalCode = loJResp.StringOf("items[i].shippingPerson.postalCode")
lcShippingPersonStateOrProvinceCode = loJResp.StringOf("items[i].shippingPerson.stateOrProvinceCode")
lcShippingPersonStateOrProvinceName = loJResp.StringOf("items[i].shippingPerson.stateOrProvinceName")
lcShippingPersonPhone = loJResp.StringOf("items[i].shippingPerson.phone")
lcShippingOptionShippingCarrierName = loJResp.StringOf("items[i].shippingOption.shippingCarrierName")
lcShippingOptionShippingMethodName = loJResp.StringOf("items[i].shippingOption.shippingMethodName")
lcShippingOptionShippingRate = loJResp.StringOf("items[i].shippingOption.shippingRate")
lcShippingOptionEstimatedTransitTime = loJResp.StringOf("items[i].shippingOption.estimatedTransitTime")
llShippingOptionIsPickup = loJResp.BoolOf("items[i].shippingOption.isPickup")
lcHandlingFeeName = loJResp.StringOf("items[i].handlingFee.name")
lnHandlingFeeValue = loJResp.IntOf("items[i].handlingFee.value")
lcHandlingFeeDescription = loJResp.StringOf("items[i].handlingFee.description")
lcPaymentModule = loJResp.StringOf("items[i].paymentModule")
lcAdditionalInfoGoogle_customer_id = loJResp.StringOf("items[i].additionalInfo.google_customer_id")
llAcceptMarketing = loJResp.BoolOf("items[i].acceptMarketing")
lcRefererId = loJResp.StringOf("items[i].refererId")
llDisableAllCustomerNotifications = loJResp.BoolOf("items[i].disableAllCustomerNotifications")
llExternalFulfillment = loJResp.BoolOf("items[i].externalFulfillment")
llPricesIncludeTax = loJResp.BoolOf("items[i].pricesIncludeTax")
j = 0
lnCount_j = loJResp.SizeOfArray("items[i].customDiscount")
do while j < lnCount_j
loJResp.J = j
j = j + 1
enddo
j = 0
lnCount_j = loJResp.SizeOfArray("items[i].discountInfo")
do while j < lnCount_j
loJResp.J = j
lnValue = loJResp.IntOf("items[i].discountInfo[j].value")
lcV_type = loJResp.StringOf("items[i].discountInfo[j].type")
lcBase = loJResp.StringOf("items[i].discountInfo[j].base")
lnOrderTotal = loJResp.IntOf("items[i].discountInfo[j].orderTotal")
j = j + 1
enddo
j = 0
lnCount_j = loJResp.SizeOfArray("items[i].items")
do while j < lnCount_j
loJResp.J = j
lnId_int = loJResp.IntOf("items[i].items[j].id")
lnProductId = loJResp.IntOf("items[i].items[j].productId")
lnCategoryId = loJResp.IntOf("items[i].items[j].categoryId")
lnPrice = loJResp.IntOf("items[i].items[j].price")
lnProductPrice = loJResp.IntOf("items[i].items[j].productPrice")
lcSku = loJResp.StringOf("items[i].items[j].sku")
lnQuantity = loJResp.IntOf("items[i].items[j].quantity")
lcShortDescription = loJResp.StringOf("items[i].items[j].shortDescription")
lcTax = loJResp.StringOf("items[i].items[j].tax")
lnShipping = loJResp.IntOf("items[i].items[j].shipping")
lnQuantityInStock = loJResp.IntOf("items[i].items[j].quantityInStock")
lcName = loJResp.StringOf("items[i].items[j].name")
llIsShippingRequired = loJResp.BoolOf("items[i].items[j].isShippingRequired")
lnWeight = loJResp.IntOf("items[i].items[j].weight")
llTrackQuantity = loJResp.BoolOf("items[i].items[j].trackQuantity")
llFixedShippingRateOnly = loJResp.BoolOf("items[i].items[j].fixedShippingRateOnly")
lcImageUrl = loJResp.StringOf("items[i].items[j].imageUrl")
lcSmallThumbnailUrl = loJResp.StringOf("items[i].items[j].smallThumbnailUrl")
lcHdThumbnailUrl = loJResp.StringOf("items[i].items[j].hdThumbnailUrl")
lnFixedShippingRate = loJResp.IntOf("items[i].items[j].fixedShippingRate")
llDigital = loJResp.BoolOf("items[i].items[j].digital")
llCouponApplied = loJResp.BoolOf("items[i].items[j].couponApplied")
lnDimensionsLength = loJResp.IntOf("items[i].items[j].dimensions.length")
lnDimensionsWidth = loJResp.IntOf("items[i].items[j].dimensions.width")
lnDimensionsHeight = loJResp.IntOf("items[i].items[j].dimensions.height")
lcCouponAmount = loJResp.StringOf("items[i].items[j].couponAmount")
lnSubscriptionId = loJResp.IntOf("items[i].items[j].subscriptionId")
lcRecurringChargeSettingsRecurringInterval = loJResp.StringOf("items[i].items[j].recurringChargeSettings.recurringInterval")
lnRecurringChargeSettingsRecurringIntervalCount = loJResp.IntOf("items[i].items[j].recurringChargeSettings.recurringIntervalCount")
k = 0
lnCount_k = loJResp.SizeOfArray("items[i].items[j].selectedOptions")
do while k < lnCount_k
loJResp.K = k
lcName = loJResp.StringOf("items[i].items[j].selectedOptions[k].name")
lcValue_str = loJResp.StringOf("items[i].items[j].selectedOptions[k].value")
lcV_type = loJResp.StringOf("items[i].items[j].selectedOptions[k].type")
loJResp.ObjectOf2("items[i].items[j].selectedOptions[k]",loJson1)
lnI1 = 0
lnCount_i1 = loJson1.SizeOfArray("valuesArray")
do while lnI1 < lnCount_i1
loJson1.I = lnI1
lcStrVal = loJson1.StringOf("valuesArray[i]")
lnI1 = lnI1 + 1
enddo
loJResp.ObjectOf2("items[i].items[j].selectedOptions[k]",loJson1)
lnI1 = 0
lnCount_i1 = loJson1.SizeOfArray("selections")
do while lnI1 < lnCount_i1
loJson1.I = lnI1
lcSelectionTitle = loJson1.StringOf("selections[i].selectionTitle")
lnSelectionModifier = loJson1.IntOf("selections[i].selectionModifier")
lcSelectionModifierType = loJson1.StringOf("selections[i].selectionModifierType")
lnI1 = lnI1 + 1
enddo
k = k + 1
enddo
k = 0
lnCount_k = loJResp.SizeOfArray("items[i].items[j].taxes")
do while k < lnCount_k
loJResp.K = k
lcName = loJResp.StringOf("items[i].items[j].taxes[k].name")
lnValue = loJResp.IntOf("items[i].items[j].taxes[k].value")
lcTotal_str = loJResp.StringOf("items[i].items[j].taxes[k].total")
lcTaxOnDiscountedSubtotal = loJResp.StringOf("items[i].items[j].taxes[k].taxOnDiscountedSubtotal")
lnTaxOnShipping = loJResp.IntOf("items[i].items[j].taxes[k].taxOnShipping")
llIncludeInPrice = loJResp.BoolOf("items[i].items[j].taxes[k].includeInPrice")
k = k + 1
enddo
k = 0
lnCount_k = loJResp.SizeOfArray("items[i].items[j].discounts")
do while k < lnCount_k
loJResp.K = k
lnDiscountInfoValue = loJResp.IntOf("items[i].items[j].discounts[k].discountInfo.value")
lcDiscountInfoType = loJResp.StringOf("items[i].items[j].discounts[k].discountInfo.type")
lcDiscountInfoBase = loJResp.StringOf("items[i].items[j].discounts[k].discountInfo.base")
lnDiscountInfoOrderTotal = loJResp.IntOf("items[i].items[j].discounts[k].discountInfo.orderTotal")
lcTotal_str = loJResp.StringOf("items[i].items[j].discounts[k].total")
k = k + 1
enddo
j = j + 1
enddo
j = 0
lnCount_j = loJResp.SizeOfArray("items[i].refunds")
do while j < lnCount_j
loJResp.J = j
lcDate = loJResp.StringOf("items[i].refunds[j].date")
lcSource = loJResp.StringOf("items[i].refunds[j].source")
lcReason = loJResp.StringOf("items[i].refunds[j].reason")
lcAmount = loJResp.StringOf("items[i].refunds[j].amount")
j = j + 1
enddo
j = 0
lnCount_j = loJResp.SizeOfArray("items[i].predictedPackage")
do while j < lnCount_j
loJResp.J = j
lnLength = loJResp.IntOf("items[i].predictedPackage[j].length")
lnWidth = loJResp.IntOf("items[i].predictedPackage[j].width")
lnHeight = loJResp.IntOf("items[i].predictedPackage[j].height")
lcWeight_str = loJResp.StringOf("items[i].predictedPackage[j].weight")
lcDeclaredValue = loJResp.StringOf("items[i].predictedPackage[j].declaredValue")
j = j + 1
enddo
j = 0
lnCount_j = loJResp.SizeOfArray("items[i].shipments")
do while j < lnCount_j
loJResp.J = j
lcId = loJResp.StringOf("items[i].shipments[j].id")
lcCreated = loJResp.StringOf("items[i].shipments[j].created")
lcShipToName = loJResp.StringOf("items[i].shipments[j].shipTo.name")
lcShipToCompanyName = loJResp.StringOf("items[i].shipments[j].shipTo.companyName")
lcShipToStreet = loJResp.StringOf("items[i].shipments[j].shipTo.street")
lcShipToCity = loJResp.StringOf("items[i].shipments[j].shipTo.city")
lcShipToCountryCode = loJResp.StringOf("items[i].shipments[j].shipTo.countryCode")
lcShipToCountryName = loJResp.StringOf("items[i].shipments[j].shipTo.countryName")
lcShipToPostalCode = loJResp.StringOf("items[i].shipments[j].shipTo.postalCode")
lcShipToStateOrProvinceCode = loJResp.StringOf("items[i].shipments[j].shipTo.stateOrProvinceCode")
lcShipToStateOrProvinceName = loJResp.StringOf("items[i].shipments[j].shipTo.stateOrProvinceName")
lcShipToPhone = loJResp.StringOf("items[i].shipments[j].shipTo.phone")
lcShipFromCompanyName = loJResp.StringOf("items[i].shipments[j].shipFrom.companyName")
lcShipFromStreet = loJResp.StringOf("items[i].shipments[j].shipFrom.street")
lcShipFromCity = loJResp.StringOf("items[i].shipments[j].shipFrom.city")
lcShipFromCountryCode = loJResp.StringOf("items[i].shipments[j].shipFrom.countryCode")
lcShipFromCountryName = loJResp.StringOf("items[i].shipments[j].shipFrom.countryName")
lcShipFromPostalCode = loJResp.StringOf("items[i].shipments[j].shipFrom.postalCode")
lcShipFromStateOrProvinceCode = loJResp.StringOf("items[i].shipments[j].shipFrom.stateOrProvinceCode")
lcShipFromStateOrProvinceName = loJResp.StringOf("items[i].shipments[j].shipFrom.stateOrProvinceName")
lcShipFromPhone = loJResp.StringOf("items[i].shipments[j].shipFrom.phone")
lcParcelWeight = loJResp.StringOf("items[i].shipments[j].parcel.weight")
lnParcelWeightUnit = loJResp.IntOf("items[i].shipments[j].parcel.weightUnit")
lnParcelWidth = loJResp.IntOf("items[i].shipments[j].parcel.width")
lnParcelHeight = loJResp.IntOf("items[i].shipments[j].parcel.height")
lnParcelLength = loJResp.IntOf("items[i].shipments[j].parcel.length")
lnParcelDimensionUnit = loJResp.IntOf("items[i].shipments[j].parcel.dimensionUnit")
lnShippingServiceCarrier = loJResp.IntOf("items[i].shipments[j].shippingService.carrier")
lnShippingServiceCarrierName = loJResp.IntOf("items[i].shipments[j].shippingService.carrierName")
lcShippingServiceCarrierServiceName = loJResp.StringOf("items[i].shipments[j].shippingService.carrierServiceName")
lcShippingServiceCarrierServiceCode = loJResp.StringOf("items[i].shipments[j].shippingService.carrierServiceCode")
lcTrackingTracking_number = loJResp.StringOf("items[i].shipments[j].tracking.tracking_number")
lcTrackingTracking_url = loJResp.StringOf("items[i].shipments[j].tracking.tracking_url")
lnTrackingEstimatedDays = loJResp.IntOf("items[i].shipments[j].tracking.estimatedDays")
lcShippingLabelLabel_url = loJResp.StringOf("items[i].shipments[j].shippingLabel.label_url")
lcShippingLabelCommercial_invoice_url = loJResp.StringOf("items[i].shipments[j].shippingLabel.commercial_invoice_url")
j = j + 1
enddo
j = 0
lnCount_j = loJResp.SizeOfArray("items[i].taxesOnShipping")
do while j < lnCount_j
loJResp.J = j
lcName = loJResp.StringOf("items[i].taxesOnShipping[j].name")
lnValue = loJResp.IntOf("items[i].taxesOnShipping[j].value")
lcTotal_str = loJResp.StringOf("items[i].taxesOnShipping[j].total")
j = j + 1
enddo
j = 0
lnCount_j = loJResp.SizeOfArray("items[i].orderExtraFields")
do while j < lnCount_j
loJResp.J = j
lcId = loJResp.StringOf("items[i].orderExtraFields[j].id")
lcValue_str = loJResp.StringOf("items[i].orderExtraFields[j].value")
lcCustomerInputType = loJResp.StringOf("items[i].orderExtraFields[j].customerInputType")
lcTitle = loJResp.StringOf("items[i].orderExtraFields[j].title")
lcOrderDetailsDisplaySection = loJResp.StringOf("items[i].orderExtraFields[j].orderDetailsDisplaySection")
lcOrderBy = loJResp.StringOf("items[i].orderExtraFields[j].orderBy")
j = j + 1
enddo
i = i + 1
enddo
release loHttp
release loJsonToken
release loParams
release loResp
release loSbResponseBody
release loJResp
release loJson1