Xbase++ Requires Chilkat v11.0.0+
Xbase++
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 Xbase++ Downloads
LOCAL nSuccess
LOCAL oHttp
LOCAL oJsonToken
LOCAL oParams
LOCAL oResp
LOCAL oSbResponseBody
LOCAL oJResp
LOCAL nRespStatusCode
LOCAL cId
LOCAL cSubtotal
LOCAL cTotal_str
LOCAL cGiftCardRedemption
LOCAL cTotalBeforeGiftCardRedemption
LOCAL nGiftCardDoubleSpending
LOCAL cUsdTotal
LOCAL cTax
LOCAL cPaymentMethod
LOCAL cPaymentStatus
LOCAL cFulfillmentStatus
LOCAL cVendorOrderNumber
LOCAL nOrderNumber
LOCAL cRefererUrl
LOCAL cGlobalReferer
LOCAL cCreateDate
LOCAL cUpdateDate
LOCAL nCreateTimestamp
LOCAL nUpdateTimestamp
LOCAL nHidden
LOCAL cOrderComments
LOCAL cPrivateAdminNotes
LOCAL cEmail
LOCAL cIpAddress
LOCAL nCustomerId
LOCAL nCustomerGroupId
LOCAL cCustomerGroup
LOCAL nCustomerTaxExempt
LOCAL cCustomerTaxId
LOCAL nCustomerTaxIdValid
LOCAL nReversedTaxApplied
LOCAL nDiscount
LOCAL nCouponDiscount
LOCAL nVolumeDiscount
LOCAL nMembershipBasedDiscount
LOCAL nTotalAndMembershipBasedDiscount
LOCAL nDiscountCouponId
LOCAL cDiscountCouponName
LOCAL cDiscountCouponCode
LOCAL cDiscountCouponDiscountType
LOCAL cDiscountCouponStatus
LOCAL nDiscountCouponDiscount
LOCAL cDiscountCouponLaunchDate
LOCAL cDiscountCouponUsesLimit
LOCAL cDiscountCouponApplicationLimit
LOCAL cDiscountCouponCreationDate
LOCAL cDiscountCouponUpdateDate
LOCAL nDiscountCouponOrderCount
LOCAL cRefundedAmount
LOCAL cBillingPersonName
LOCAL cBillingPersonCompanyName
LOCAL cBillingPersonStreet
LOCAL cBillingPersonCity
LOCAL cBillingPersonCountryCode
LOCAL cBillingPersonCountryName
LOCAL cBillingPersonPostalCode
LOCAL cBillingPersonStateOrProvinceCode
LOCAL cBillingPersonStateOrProvinceName
LOCAL cBillingPersonPhone
LOCAL cShippingPersonName
LOCAL cShippingPersonCompanyName
LOCAL cShippingPersonStreet
LOCAL cShippingPersonCity
LOCAL cShippingPersonCountryCode
LOCAL cShippingPersonCountryName
LOCAL cShippingPersonPostalCode
LOCAL cShippingPersonStateOrProvinceCode
LOCAL cShippingPersonStateOrProvinceName
LOCAL cShippingPersonPhone
LOCAL cShippingOptionShippingCarrierName
LOCAL cShippingOptionShippingMethodName
LOCAL cShippingOptionShippingRate
LOCAL cShippingOptionEstimatedTransitTime
LOCAL nShippingOptionIsPickup
LOCAL cHandlingFeeName
LOCAL nHandlingFeeValue
LOCAL cHandlingFeeDescription
LOCAL cPaymentModule
LOCAL cAdditionalInfoGoogle_customer_id
LOCAL nAcceptMarketing
LOCAL cRefererId
LOCAL nDisableAllCustomerNotifications
LOCAL nExternalFulfillment
LOCAL nPricesIncludeTax
LOCAL j
LOCAL nCount_j
LOCAL nValue
LOCAL cV_type
LOCAL cBase
LOCAL nOrderTotal
LOCAL nId_int
LOCAL nProductId
LOCAL nCategoryId
LOCAL nPrice
LOCAL nProductPrice
LOCAL cSku
LOCAL nQuantity
LOCAL cShortDescription
LOCAL nShipping
LOCAL nQuantityInStock
LOCAL cName
LOCAL nIsShippingRequired
LOCAL nWeight
LOCAL nTrackQuantity
LOCAL nFixedShippingRateOnly
LOCAL cImageUrl
LOCAL cSmallThumbnailUrl
LOCAL cHdThumbnailUrl
LOCAL nFixedShippingRate
LOCAL nDigital
LOCAL nCouponApplied
LOCAL nDimensionsLength
LOCAL nDimensionsWidth
LOCAL nDimensionsHeight
LOCAL cCouponAmount
LOCAL nSubscriptionId
LOCAL cRecurringChargeSettingsRecurringInterval
LOCAL nRecurringChargeSettingsRecurringIntervalCount
LOCAL k
LOCAL nCount_k
LOCAL cValue_str
LOCAL oJson1
LOCAL nI1
LOCAL nCount_i1
LOCAL cStrVal
LOCAL cSelectionTitle
LOCAL nSelectionModifier
LOCAL cSelectionModifierType
LOCAL cTaxOnDiscountedSubtotal
LOCAL nTaxOnShipping
LOCAL nIncludeInPrice
LOCAL nDiscountInfoValue
LOCAL cDiscountInfoType
LOCAL cDiscountInfoBase
LOCAL nDiscountInfoOrderTotal
LOCAL cDate
LOCAL cSource
LOCAL cReason
LOCAL cAmount
LOCAL nLength
LOCAL nWidth
LOCAL nHeight
LOCAL cWeight_str
LOCAL cDeclaredValue
LOCAL cCreated
LOCAL cShipToName
LOCAL cShipToCompanyName
LOCAL cShipToStreet
LOCAL cShipToCity
LOCAL cShipToCountryCode
LOCAL cShipToCountryName
LOCAL cShipToPostalCode
LOCAL cShipToStateOrProvinceCode
LOCAL cShipToStateOrProvinceName
LOCAL cShipToPhone
LOCAL cShipFromCompanyName
LOCAL cShipFromStreet
LOCAL cShipFromCity
LOCAL cShipFromCountryCode
LOCAL cShipFromCountryName
LOCAL cShipFromPostalCode
LOCAL cShipFromStateOrProvinceCode
LOCAL cShipFromStateOrProvinceName
LOCAL cShipFromPhone
LOCAL cParcelWeight
LOCAL nParcelWeightUnit
LOCAL nParcelWidth
LOCAL nParcelHeight
LOCAL nParcelLength
LOCAL nParcelDimensionUnit
LOCAL nShippingServiceCarrier
LOCAL nShippingServiceCarrierName
LOCAL cShippingServiceCarrierServiceName
LOCAL cShippingServiceCarrierServiceCode
LOCAL cTrackingTracking_number
LOCAL cTrackingTracking_url
LOCAL nTrackingEstimatedDays
LOCAL cShippingLabelLabel_url
LOCAL cShippingLabelCommercial_invoice_url
LOCAL cCustomerInputType
LOCAL cTitle
LOCAL cOrderDetailsDisplaySection
LOCAL cOrderBy
LOCAL nTotal
LOCAL nCount
LOCAL nOffset
LOCAL nLimit
LOCAL i
LOCAL nCount_i
nSuccess := 0
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
oHttp := CreateObject("Chilkat.Http")
// Implements the following CURL command:
// curl --request GET \
// --url 'https://app.ecwid.com/api/v3/storeId/orders?token=token' \
// --header 'Accept: application/json'
// Use the following online tool to generate HTTP code from a CURL command
// Convert a cURL Command to HTTP Source Code
// Load the access token previously obtained in Ecwid Get Access Token
oJsonToken := CreateObject("Chilkat.JsonObject")
oJsonToken:LoadFile("qa_data/tokens/ecwid.json")
oHttp:SetRequestHeader("Accept", "application/json")
oParams := CreateObject("Chilkat.JsonObject")
oParams:UpdateInt("limit", 100)
oParams:UpdateString("email", "joe@example.com")
oParams:UpdateString("token", oJsonToken:StringOf("access_token"))
oResp := CreateObject("Chilkat.HttpResponse")
nSuccess := oHttp:HttpParams("GET", "https://app.ecwid.com/api/v3/storeId/orders", oParams, oResp)
IF (nSuccess == 0)
? oHttp:LastErrorText
oHttp:destroy()
oJsonToken:destroy()
oParams:destroy()
oResp:destroy()
RETURN
ENDIF
oSbResponseBody := CreateObject("Chilkat.StringBuilder")
oResp:GetBodySb(oSbResponseBody)
oJResp := CreateObject("Chilkat.JsonObject")
oJResp:LoadSb(oSbResponseBody)
oJResp:EmitCompact := 0
? "Response Body:"
? oJResp:Emit()
nRespStatusCode := oResp:StatusCode
? "Response Status Code = " + Str(nRespStatusCode)
IF (nRespStatusCode != 200)
? "Failed."
oHttp:destroy()
oJsonToken:destroy()
oParams:destroy()
oResp:destroy()
oSbResponseBody:destroy()
oJResp:destroy()
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
oJson1 := CreateObject("Chilkat.JsonObject")
nTotal := oJResp:IntOf("total")
nCount := oJResp:IntOf("count")
nOffset := oJResp:IntOf("offset")
nLimit := oJResp:IntOf("limit")
i := 0
nCount_i := oJResp:SizeOfArray("items")
DO WHILE i < nCount_i
oJResp:I := i
cId := oJResp:StringOf("items[i].id")
cSubtotal := oJResp:StringOf("items[i].subtotal")
cTotal_str := oJResp:StringOf("items[i].total")
cGiftCardRedemption := oJResp:StringOf("items[i].giftCardRedemption")
cTotalBeforeGiftCardRedemption := oJResp:StringOf("items[i].totalBeforeGiftCardRedemption")
nGiftCardDoubleSpending := oJResp:BoolOf("items[i].giftCardDoubleSpending")
cUsdTotal := oJResp:StringOf("items[i].usdTotal")
cTax := oJResp:StringOf("items[i].tax")
cPaymentMethod := oJResp:StringOf("items[i].paymentMethod")
cPaymentStatus := oJResp:StringOf("items[i].paymentStatus")
cFulfillmentStatus := oJResp:StringOf("items[i].fulfillmentStatus")
cVendorOrderNumber := oJResp:StringOf("items[i].vendorOrderNumber")
nOrderNumber := oJResp:IntOf("items[i].orderNumber")
cRefererUrl := oJResp:StringOf("items[i].refererUrl")
cGlobalReferer := oJResp:StringOf("items[i].globalReferer")
cCreateDate := oJResp:StringOf("items[i].createDate")
cUpdateDate := oJResp:StringOf("items[i].updateDate")
nCreateTimestamp := oJResp:IntOf("items[i].createTimestamp")
nUpdateTimestamp := oJResp:IntOf("items[i].updateTimestamp")
nHidden := oJResp:BoolOf("items[i].hidden")
cOrderComments := oJResp:StringOf("items[i].orderComments")
cPrivateAdminNotes := oJResp:StringOf("items[i].privateAdminNotes")
cEmail := oJResp:StringOf("items[i].email")
cIpAddress := oJResp:StringOf("items[i].ipAddress")
nCustomerId := oJResp:IntOf("items[i].customerId")
nCustomerGroupId := oJResp:IntOf("items[i].customerGroupId")
cCustomerGroup := oJResp:StringOf("items[i].customerGroup")
nCustomerTaxExempt := oJResp:BoolOf("items[i].customerTaxExempt")
cCustomerTaxId := oJResp:StringOf("items[i].customerTaxId")
nCustomerTaxIdValid := oJResp:BoolOf("items[i].customerTaxIdValid")
nReversedTaxApplied := oJResp:BoolOf("items[i].reversedTaxApplied")
nDiscount := oJResp:IntOf("items[i].discount")
nCouponDiscount := oJResp:IntOf("items[i].couponDiscount")
nVolumeDiscount := oJResp:IntOf("items[i].volumeDiscount")
nMembershipBasedDiscount := oJResp:IntOf("items[i].membershipBasedDiscount")
nTotalAndMembershipBasedDiscount := oJResp:IntOf("items[i].totalAndMembershipBasedDiscount")
nDiscountCouponId := oJResp:IntOf("items[i].discountCoupon.id")
cDiscountCouponName := oJResp:StringOf("items[i].discountCoupon.name")
cDiscountCouponCode := oJResp:StringOf("items[i].discountCoupon.code")
cDiscountCouponDiscountType := oJResp:StringOf("items[i].discountCoupon.discountType")
cDiscountCouponStatus := oJResp:StringOf("items[i].discountCoupon.status")
nDiscountCouponDiscount := oJResp:IntOf("items[i].discountCoupon.discount")
cDiscountCouponLaunchDate := oJResp:StringOf("items[i].discountCoupon.launchDate")
cDiscountCouponUsesLimit := oJResp:StringOf("items[i].discountCoupon.usesLimit")
cDiscountCouponApplicationLimit := oJResp:StringOf("items[i].discountCoupon.applicationLimit")
cDiscountCouponCreationDate := oJResp:StringOf("items[i].discountCoupon.creationDate")
cDiscountCouponUpdateDate := oJResp:StringOf("items[i].discountCoupon.updateDate")
nDiscountCouponOrderCount := oJResp:IntOf("items[i].discountCoupon.orderCount")
cRefundedAmount := oJResp:StringOf("items[i].refundedAmount")
cBillingPersonName := oJResp:StringOf("items[i].billingPerson.name")
cBillingPersonCompanyName := oJResp:StringOf("items[i].billingPerson.companyName")
cBillingPersonStreet := oJResp:StringOf("items[i].billingPerson.street")
cBillingPersonCity := oJResp:StringOf("items[i].billingPerson.city")
cBillingPersonCountryCode := oJResp:StringOf("items[i].billingPerson.countryCode")
cBillingPersonCountryName := oJResp:StringOf("items[i].billingPerson.countryName")
cBillingPersonPostalCode := oJResp:StringOf("items[i].billingPerson.postalCode")
cBillingPersonStateOrProvinceCode := oJResp:StringOf("items[i].billingPerson.stateOrProvinceCode")
cBillingPersonStateOrProvinceName := oJResp:StringOf("items[i].billingPerson.stateOrProvinceName")
cBillingPersonPhone := oJResp:StringOf("items[i].billingPerson.phone")
cShippingPersonName := oJResp:StringOf("items[i].shippingPerson.name")
cShippingPersonCompanyName := oJResp:StringOf("items[i].shippingPerson.companyName")
cShippingPersonStreet := oJResp:StringOf("items[i].shippingPerson.street")
cShippingPersonCity := oJResp:StringOf("items[i].shippingPerson.city")
cShippingPersonCountryCode := oJResp:StringOf("items[i].shippingPerson.countryCode")
cShippingPersonCountryName := oJResp:StringOf("items[i].shippingPerson.countryName")
cShippingPersonPostalCode := oJResp:StringOf("items[i].shippingPerson.postalCode")
cShippingPersonStateOrProvinceCode := oJResp:StringOf("items[i].shippingPerson.stateOrProvinceCode")
cShippingPersonStateOrProvinceName := oJResp:StringOf("items[i].shippingPerson.stateOrProvinceName")
cShippingPersonPhone := oJResp:StringOf("items[i].shippingPerson.phone")
cShippingOptionShippingCarrierName := oJResp:StringOf("items[i].shippingOption.shippingCarrierName")
cShippingOptionShippingMethodName := oJResp:StringOf("items[i].shippingOption.shippingMethodName")
cShippingOptionShippingRate := oJResp:StringOf("items[i].shippingOption.shippingRate")
cShippingOptionEstimatedTransitTime := oJResp:StringOf("items[i].shippingOption.estimatedTransitTime")
nShippingOptionIsPickup := oJResp:BoolOf("items[i].shippingOption.isPickup")
cHandlingFeeName := oJResp:StringOf("items[i].handlingFee.name")
nHandlingFeeValue := oJResp:IntOf("items[i].handlingFee.value")
cHandlingFeeDescription := oJResp:StringOf("items[i].handlingFee.description")
cPaymentModule := oJResp:StringOf("items[i].paymentModule")
cAdditionalInfoGoogle_customer_id := oJResp:StringOf("items[i].additionalInfo.google_customer_id")
nAcceptMarketing := oJResp:BoolOf("items[i].acceptMarketing")
cRefererId := oJResp:StringOf("items[i].refererId")
nDisableAllCustomerNotifications := oJResp:BoolOf("items[i].disableAllCustomerNotifications")
nExternalFulfillment := oJResp:BoolOf("items[i].externalFulfillment")
nPricesIncludeTax := oJResp:BoolOf("items[i].pricesIncludeTax")
j := 0
nCount_j := oJResp:SizeOfArray("items[i].customDiscount")
DO WHILE j < nCount_j
oJResp:J := j
j := j + 1
ENDDO
j := 0
nCount_j := oJResp:SizeOfArray("items[i].discountInfo")
DO WHILE j < nCount_j
oJResp:J := j
nValue := oJResp:IntOf("items[i].discountInfo[j].value")
cV_type := oJResp:StringOf("items[i].discountInfo[j].type")
cBase := oJResp:StringOf("items[i].discountInfo[j].base")
nOrderTotal := oJResp:IntOf("items[i].discountInfo[j].orderTotal")
j := j + 1
ENDDO
j := 0
nCount_j := oJResp:SizeOfArray("items[i].items")
DO WHILE j < nCount_j
oJResp:J := j
nId_int := oJResp:IntOf("items[i].items[j].id")
nProductId := oJResp:IntOf("items[i].items[j].productId")
nCategoryId := oJResp:IntOf("items[i].items[j].categoryId")
nPrice := oJResp:IntOf("items[i].items[j].price")
nProductPrice := oJResp:IntOf("items[i].items[j].productPrice")
cSku := oJResp:StringOf("items[i].items[j].sku")
nQuantity := oJResp:IntOf("items[i].items[j].quantity")
cShortDescription := oJResp:StringOf("items[i].items[j].shortDescription")
cTax := oJResp:StringOf("items[i].items[j].tax")
nShipping := oJResp:IntOf("items[i].items[j].shipping")
nQuantityInStock := oJResp:IntOf("items[i].items[j].quantityInStock")
cName := oJResp:StringOf("items[i].items[j].name")
nIsShippingRequired := oJResp:BoolOf("items[i].items[j].isShippingRequired")
nWeight := oJResp:IntOf("items[i].items[j].weight")
nTrackQuantity := oJResp:BoolOf("items[i].items[j].trackQuantity")
nFixedShippingRateOnly := oJResp:BoolOf("items[i].items[j].fixedShippingRateOnly")
cImageUrl := oJResp:StringOf("items[i].items[j].imageUrl")
cSmallThumbnailUrl := oJResp:StringOf("items[i].items[j].smallThumbnailUrl")
cHdThumbnailUrl := oJResp:StringOf("items[i].items[j].hdThumbnailUrl")
nFixedShippingRate := oJResp:IntOf("items[i].items[j].fixedShippingRate")
nDigital := oJResp:BoolOf("items[i].items[j].digital")
nCouponApplied := oJResp:BoolOf("items[i].items[j].couponApplied")
nDimensionsLength := oJResp:IntOf("items[i].items[j].dimensions.length")
nDimensionsWidth := oJResp:IntOf("items[i].items[j].dimensions.width")
nDimensionsHeight := oJResp:IntOf("items[i].items[j].dimensions.height")
cCouponAmount := oJResp:StringOf("items[i].items[j].couponAmount")
nSubscriptionId := oJResp:IntOf("items[i].items[j].subscriptionId")
cRecurringChargeSettingsRecurringInterval := oJResp:StringOf("items[i].items[j].recurringChargeSettings.recurringInterval")
nRecurringChargeSettingsRecurringIntervalCount := oJResp:IntOf("items[i].items[j].recurringChargeSettings.recurringIntervalCount")
k := 0
nCount_k := oJResp:SizeOfArray("items[i].items[j].selectedOptions")
DO WHILE k < nCount_k
oJResp:K := k
cName := oJResp:StringOf("items[i].items[j].selectedOptions[k].name")
cValue_str := oJResp:StringOf("items[i].items[j].selectedOptions[k].value")
cV_type := oJResp:StringOf("items[i].items[j].selectedOptions[k].type")
oJResp:ObjectOf2("items[i].items[j].selectedOptions[k]", oJson1)
nI1 := 0
nCount_i1 := oJson1:SizeOfArray("valuesArray")
DO WHILE nI1 < nCount_i1
oJson1:I := nI1
cStrVal := oJson1:StringOf("valuesArray[i]")
nI1 := nI1 + 1
ENDDO
oJResp:ObjectOf2("items[i].items[j].selectedOptions[k]", oJson1)
nI1 := 0
nCount_i1 := oJson1:SizeOfArray("selections")
DO WHILE nI1 < nCount_i1
oJson1:I := nI1
cSelectionTitle := oJson1:StringOf("selections[i].selectionTitle")
nSelectionModifier := oJson1:IntOf("selections[i].selectionModifier")
cSelectionModifierType := oJson1:StringOf("selections[i].selectionModifierType")
nI1 := nI1 + 1
ENDDO
k := k + 1
ENDDO
k := 0
nCount_k := oJResp:SizeOfArray("items[i].items[j].taxes")
DO WHILE k < nCount_k
oJResp:K := k
cName := oJResp:StringOf("items[i].items[j].taxes[k].name")
nValue := oJResp:IntOf("items[i].items[j].taxes[k].value")
cTotal_str := oJResp:StringOf("items[i].items[j].taxes[k].total")
cTaxOnDiscountedSubtotal := oJResp:StringOf("items[i].items[j].taxes[k].taxOnDiscountedSubtotal")
nTaxOnShipping := oJResp:IntOf("items[i].items[j].taxes[k].taxOnShipping")
nIncludeInPrice := oJResp:BoolOf("items[i].items[j].taxes[k].includeInPrice")
k := k + 1
ENDDO
k := 0
nCount_k := oJResp:SizeOfArray("items[i].items[j].discounts")
DO WHILE k < nCount_k
oJResp:K := k
nDiscountInfoValue := oJResp:IntOf("items[i].items[j].discounts[k].discountInfo.value")
cDiscountInfoType := oJResp:StringOf("items[i].items[j].discounts[k].discountInfo.type")
cDiscountInfoBase := oJResp:StringOf("items[i].items[j].discounts[k].discountInfo.base")
nDiscountInfoOrderTotal := oJResp:IntOf("items[i].items[j].discounts[k].discountInfo.orderTotal")
cTotal_str := oJResp:StringOf("items[i].items[j].discounts[k].total")
k := k + 1
ENDDO
j := j + 1
ENDDO
j := 0
nCount_j := oJResp:SizeOfArray("items[i].refunds")
DO WHILE j < nCount_j
oJResp:J := j
cDate := oJResp:StringOf("items[i].refunds[j].date")
cSource := oJResp:StringOf("items[i].refunds[j].source")
cReason := oJResp:StringOf("items[i].refunds[j].reason")
cAmount := oJResp:StringOf("items[i].refunds[j].amount")
j := j + 1
ENDDO
j := 0
nCount_j := oJResp:SizeOfArray("items[i].predictedPackage")
DO WHILE j < nCount_j
oJResp:J := j
nLength := oJResp:IntOf("items[i].predictedPackage[j].length")
nWidth := oJResp:IntOf("items[i].predictedPackage[j].width")
nHeight := oJResp:IntOf("items[i].predictedPackage[j].height")
cWeight_str := oJResp:StringOf("items[i].predictedPackage[j].weight")
cDeclaredValue := oJResp:StringOf("items[i].predictedPackage[j].declaredValue")
j := j + 1
ENDDO
j := 0
nCount_j := oJResp:SizeOfArray("items[i].shipments")
DO WHILE j < nCount_j
oJResp:J := j
cId := oJResp:StringOf("items[i].shipments[j].id")
cCreated := oJResp:StringOf("items[i].shipments[j].created")
cShipToName := oJResp:StringOf("items[i].shipments[j].shipTo.name")
cShipToCompanyName := oJResp:StringOf("items[i].shipments[j].shipTo.companyName")
cShipToStreet := oJResp:StringOf("items[i].shipments[j].shipTo.street")
cShipToCity := oJResp:StringOf("items[i].shipments[j].shipTo.city")
cShipToCountryCode := oJResp:StringOf("items[i].shipments[j].shipTo.countryCode")
cShipToCountryName := oJResp:StringOf("items[i].shipments[j].shipTo.countryName")
cShipToPostalCode := oJResp:StringOf("items[i].shipments[j].shipTo.postalCode")
cShipToStateOrProvinceCode := oJResp:StringOf("items[i].shipments[j].shipTo.stateOrProvinceCode")
cShipToStateOrProvinceName := oJResp:StringOf("items[i].shipments[j].shipTo.stateOrProvinceName")
cShipToPhone := oJResp:StringOf("items[i].shipments[j].shipTo.phone")
cShipFromCompanyName := oJResp:StringOf("items[i].shipments[j].shipFrom.companyName")
cShipFromStreet := oJResp:StringOf("items[i].shipments[j].shipFrom.street")
cShipFromCity := oJResp:StringOf("items[i].shipments[j].shipFrom.city")
cShipFromCountryCode := oJResp:StringOf("items[i].shipments[j].shipFrom.countryCode")
cShipFromCountryName := oJResp:StringOf("items[i].shipments[j].shipFrom.countryName")
cShipFromPostalCode := oJResp:StringOf("items[i].shipments[j].shipFrom.postalCode")
cShipFromStateOrProvinceCode := oJResp:StringOf("items[i].shipments[j].shipFrom.stateOrProvinceCode")
cShipFromStateOrProvinceName := oJResp:StringOf("items[i].shipments[j].shipFrom.stateOrProvinceName")
cShipFromPhone := oJResp:StringOf("items[i].shipments[j].shipFrom.phone")
cParcelWeight := oJResp:StringOf("items[i].shipments[j].parcel.weight")
nParcelWeightUnit := oJResp:IntOf("items[i].shipments[j].parcel.weightUnit")
nParcelWidth := oJResp:IntOf("items[i].shipments[j].parcel.width")
nParcelHeight := oJResp:IntOf("items[i].shipments[j].parcel.height")
nParcelLength := oJResp:IntOf("items[i].shipments[j].parcel.length")
nParcelDimensionUnit := oJResp:IntOf("items[i].shipments[j].parcel.dimensionUnit")
nShippingServiceCarrier := oJResp:IntOf("items[i].shipments[j].shippingService.carrier")
nShippingServiceCarrierName := oJResp:IntOf("items[i].shipments[j].shippingService.carrierName")
cShippingServiceCarrierServiceName := oJResp:StringOf("items[i].shipments[j].shippingService.carrierServiceName")
cShippingServiceCarrierServiceCode := oJResp:StringOf("items[i].shipments[j].shippingService.carrierServiceCode")
cTrackingTracking_number := oJResp:StringOf("items[i].shipments[j].tracking.tracking_number")
cTrackingTracking_url := oJResp:StringOf("items[i].shipments[j].tracking.tracking_url")
nTrackingEstimatedDays := oJResp:IntOf("items[i].shipments[j].tracking.estimatedDays")
cShippingLabelLabel_url := oJResp:StringOf("items[i].shipments[j].shippingLabel.label_url")
cShippingLabelCommercial_invoice_url := oJResp:StringOf("items[i].shipments[j].shippingLabel.commercial_invoice_url")
j := j + 1
ENDDO
j := 0
nCount_j := oJResp:SizeOfArray("items[i].taxesOnShipping")
DO WHILE j < nCount_j
oJResp:J := j
cName := oJResp:StringOf("items[i].taxesOnShipping[j].name")
nValue := oJResp:IntOf("items[i].taxesOnShipping[j].value")
cTotal_str := oJResp:StringOf("items[i].taxesOnShipping[j].total")
j := j + 1
ENDDO
j := 0
nCount_j := oJResp:SizeOfArray("items[i].orderExtraFields")
DO WHILE j < nCount_j
oJResp:J := j
cId := oJResp:StringOf("items[i].orderExtraFields[j].id")
cValue_str := oJResp:StringOf("items[i].orderExtraFields[j].value")
cCustomerInputType := oJResp:StringOf("items[i].orderExtraFields[j].customerInputType")
cTitle := oJResp:StringOf("items[i].orderExtraFields[j].title")
cOrderDetailsDisplaySection := oJResp:StringOf("items[i].orderExtraFields[j].orderDetailsDisplaySection")
cOrderBy := oJResp:StringOf("items[i].orderExtraFields[j].orderBy")
j := j + 1
ENDDO
i := i + 1
ENDDO
oHttp:destroy()
oJsonToken:destroy()
oParams:destroy()
oResp:destroy()
oSbResponseBody:destroy()
oJResp:destroy()
oJson1:destroy()