DataFlex
DataFlex
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 DataFlex Downloads
Use ChilkatAx-win32.pkg
Procedure Test
Boolean iSuccess
Handle hoHttp
Handle hoJsonToken
Variant vParams
Handle hoParams
Variant vResp
Handle hoResp
Variant vSbResponseBody
Handle hoSbResponseBody
Handle hoJResp
Integer iRespStatusCode
String sId
String sSubtotal
String sTotal_str
String sGiftCardRedemption
String sTotalBeforeGiftCardRedemption
Boolean iGiftCardDoubleSpending
String sUsdTotal
String sTax
String sPaymentMethod
String sPaymentStatus
String sFulfillmentStatus
String sVendorOrderNumber
Integer iOrderNumber
String sRefererUrl
String sGlobalReferer
String sCreateDate
String sUpdateDate
Integer iCreateTimestamp
Integer iUpdateTimestamp
Boolean iHidden
String sOrderComments
String sPrivateAdminNotes
String sEmail
String sIpAddress
Integer iCustomerId
Integer iCustomerGroupId
String sCustomerGroup
Boolean iCustomerTaxExempt
String sCustomerTaxId
Boolean iCustomerTaxIdValid
Boolean iReversedTaxApplied
Integer iDiscount
Integer iCouponDiscount
Integer iVolumeDiscount
Integer iMembershipBasedDiscount
Integer iTotalAndMembershipBasedDiscount
Integer iDiscountCouponId
String sDiscountCouponName
String sDiscountCouponCode
String sDiscountCouponDiscountType
String sDiscountCouponStatus
Integer iDiscountCouponDiscount
String sDiscountCouponLaunchDate
String sDiscountCouponUsesLimit
String sDiscountCouponApplicationLimit
String sDiscountCouponCreationDate
String sDiscountCouponUpdateDate
Integer iDiscountCouponOrderCount
String sRefundedAmount
String sBillingPersonName
String sBillingPersonCompanyName
String sBillingPersonStreet
String sBillingPersonCity
String sBillingPersonCountryCode
String sBillingPersonCountryName
String sBillingPersonPostalCode
String sBillingPersonStateOrProvinceCode
String sBillingPersonStateOrProvinceName
String sBillingPersonPhone
String sShippingPersonName
String sShippingPersonCompanyName
String sShippingPersonStreet
String sShippingPersonCity
String sShippingPersonCountryCode
String sShippingPersonCountryName
String sShippingPersonPostalCode
String sShippingPersonStateOrProvinceCode
String sShippingPersonStateOrProvinceName
String sShippingPersonPhone
String sShippingOptionShippingCarrierName
String sShippingOptionShippingMethodName
String sShippingOptionShippingRate
String sShippingOptionEstimatedTransitTime
Boolean iShippingOptionIsPickup
String sHandlingFeeName
Integer iHandlingFeeValue
String sHandlingFeeDescription
String sPaymentModule
String sAdditionalInfoGoogle_customer_id
Boolean iAcceptMarketing
String sRefererId
Boolean iDisableAllCustomerNotifications
Boolean iExternalFulfillment
Boolean iPricesIncludeTax
Integer j
Integer iCount_j
Integer iValue
String sV_type
String sBase
Integer iOrderTotal
Integer iId_int
Integer iProductId
Integer iCategoryId
Integer iPrice
Integer iProductPrice
String sSku
Integer iQuantity
String sShortDescription
Integer iShipping
Integer iQuantityInStock
String sName
Boolean iIsShippingRequired
Integer iWeight
Boolean iTrackQuantity
Boolean iFixedShippingRateOnly
String sImageUrl
String sSmallThumbnailUrl
String sHdThumbnailUrl
Integer iFixedShippingRate
Boolean iDigital
Boolean iCouponApplied
Integer iDimensionsLength
Integer iDimensionsWidth
Integer iDimensionsHeight
String sCouponAmount
Integer iSubscriptionId
String sRecurringChargeSettingsRecurringInterval
Integer iRecurringChargeSettingsRecurringIntervalCount
Integer k
Integer iCount_k
String sValue_str
Variant vJson1
Handle hoJson1
Integer iI1
Integer iCount_i1
String sStrVal
String sSelectionTitle
Integer iSelectionModifier
String sSelectionModifierType
String sTaxOnDiscountedSubtotal
Integer iTaxOnShipping
Boolean iIncludeInPrice
Integer iDiscountInfoValue
String sDiscountInfoType
String sDiscountInfoBase
Integer iDiscountInfoOrderTotal
String sDate
String sSource
String sReason
String sAmount
Integer iLength
Integer iWidth
Integer iHeight
String sWeight_str
String sDeclaredValue
String sCreated
String sShipToName
String sShipToCompanyName
String sShipToStreet
String sShipToCity
String sShipToCountryCode
String sShipToCountryName
String sShipToPostalCode
String sShipToStateOrProvinceCode
String sShipToStateOrProvinceName
String sShipToPhone
String sShipFromCompanyName
String sShipFromStreet
String sShipFromCity
String sShipFromCountryCode
String sShipFromCountryName
String sShipFromPostalCode
String sShipFromStateOrProvinceCode
String sShipFromStateOrProvinceName
String sShipFromPhone
String sParcelWeight
Integer iParcelWeightUnit
Integer iParcelWidth
Integer iParcelHeight
Integer iParcelLength
Integer iParcelDimensionUnit
Integer iShippingServiceCarrier
Integer iShippingServiceCarrierName
String sShippingServiceCarrierServiceName
String sShippingServiceCarrierServiceCode
String sTrackingTracking_number
String sTrackingTracking_url
Integer iTrackingEstimatedDays
String sShippingLabelLabel_url
String sShippingLabelCommercial_invoice_url
String sCustomerInputType
String sTitle
String sOrderDetailsDisplaySection
String sOrderBy
Integer iTotal
Integer iCount
Integer iOffset
Integer iLimit
Integer i
Integer iCount_i
String sTemp1
Move False To iSuccess
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
Get Create (RefClass(cComChilkatHttp)) To hoHttp
If (Not(IsComObjectCreated(hoHttp))) Begin
Send CreateComObject of hoHttp
End
// 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
Get Create (RefClass(cComChilkatJsonObject)) To hoJsonToken
If (Not(IsComObjectCreated(hoJsonToken))) Begin
Send CreateComObject of hoJsonToken
End
Get ComLoadFile Of hoJsonToken "qa_data/tokens/ecwid.json" To iSuccess
Send ComSetRequestHeader To hoHttp "Accept" "application/json"
Get Create (RefClass(cComChilkatJsonObject)) To hoParams
If (Not(IsComObjectCreated(hoParams))) Begin
Send CreateComObject of hoParams
End
Get ComUpdateInt Of hoParams "limit" 100 To iSuccess
Get ComUpdateString Of hoParams "email" "joe@example.com" To iSuccess
Get ComStringOf Of hoJsonToken "access_token" To sTemp1
Get ComUpdateString Of hoParams "token" sTemp1 To iSuccess
Get Create (RefClass(cComChilkatHttpResponse)) To hoResp
If (Not(IsComObjectCreated(hoResp))) Begin
Send CreateComObject of hoResp
End
Get pvComObject of hoParams to vParams
Get pvComObject of hoResp to vResp
Get ComHttpParams Of hoHttp "GET" "https://app.ecwid.com/api/v3/storeId/orders" vParams vResp To iSuccess
If (iSuccess = False) Begin
Get ComLastErrorText Of hoHttp To sTemp1
Showln sTemp1
Procedure_Return
End
Get Create (RefClass(cComChilkatStringBuilder)) To hoSbResponseBody
If (Not(IsComObjectCreated(hoSbResponseBody))) Begin
Send CreateComObject of hoSbResponseBody
End
Get pvComObject of hoSbResponseBody to vSbResponseBody
Get ComGetBodySb Of hoResp vSbResponseBody To iSuccess
Get Create (RefClass(cComChilkatJsonObject)) To hoJResp
If (Not(IsComObjectCreated(hoJResp))) Begin
Send CreateComObject of hoJResp
End
Get pvComObject of hoSbResponseBody to vSbResponseBody
Get ComLoadSb Of hoJResp vSbResponseBody To iSuccess
Set ComEmitCompact Of hoJResp To False
Showln "Response Body:"
Get ComEmit Of hoJResp To sTemp1
Showln sTemp1
Get ComStatusCode Of hoResp To iRespStatusCode
Showln "Response Status Code = " iRespStatusCode
If (iRespStatusCode <> 200) Begin
Showln "Failed."
Procedure_Return
End
// 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
Get Create (RefClass(cComChilkatJsonObject)) To hoJson1
If (Not(IsComObjectCreated(hoJson1))) Begin
Send CreateComObject of hoJson1
End
Get ComIntOf Of hoJResp "total" To iTotal
Get ComIntOf Of hoJResp "count" To iCount
Get ComIntOf Of hoJResp "offset" To iOffset
Get ComIntOf Of hoJResp "limit" To iLimit
Move 0 To i
Get ComSizeOfArray Of hoJResp "items" To iCount_i
While (i < iCount_i)
Set ComI Of hoJResp To i
Get ComStringOf Of hoJResp "items[i].id" To sId
Get ComStringOf Of hoJResp "items[i].subtotal" To sSubtotal
Get ComStringOf Of hoJResp "items[i].total" To sTotal_str
Get ComStringOf Of hoJResp "items[i].giftCardRedemption" To sGiftCardRedemption
Get ComStringOf Of hoJResp "items[i].totalBeforeGiftCardRedemption" To sTotalBeforeGiftCardRedemption
Get ComBoolOf Of hoJResp "items[i].giftCardDoubleSpending" To iGiftCardDoubleSpending
Get ComStringOf Of hoJResp "items[i].usdTotal" To sUsdTotal
Get ComStringOf Of hoJResp "items[i].tax" To sTax
Get ComStringOf Of hoJResp "items[i].paymentMethod" To sPaymentMethod
Get ComStringOf Of hoJResp "items[i].paymentStatus" To sPaymentStatus
Get ComStringOf Of hoJResp "items[i].fulfillmentStatus" To sFulfillmentStatus
Get ComStringOf Of hoJResp "items[i].vendorOrderNumber" To sVendorOrderNumber
Get ComIntOf Of hoJResp "items[i].orderNumber" To iOrderNumber
Get ComStringOf Of hoJResp "items[i].refererUrl" To sRefererUrl
Get ComStringOf Of hoJResp "items[i].globalReferer" To sGlobalReferer
Get ComStringOf Of hoJResp "items[i].createDate" To sCreateDate
Get ComStringOf Of hoJResp "items[i].updateDate" To sUpdateDate
Get ComIntOf Of hoJResp "items[i].createTimestamp" To iCreateTimestamp
Get ComIntOf Of hoJResp "items[i].updateTimestamp" To iUpdateTimestamp
Get ComBoolOf Of hoJResp "items[i].hidden" To iHidden
Get ComStringOf Of hoJResp "items[i].orderComments" To sOrderComments
Get ComStringOf Of hoJResp "items[i].privateAdminNotes" To sPrivateAdminNotes
Get ComStringOf Of hoJResp "items[i].email" To sEmail
Get ComStringOf Of hoJResp "items[i].ipAddress" To sIpAddress
Get ComIntOf Of hoJResp "items[i].customerId" To iCustomerId
Get ComIntOf Of hoJResp "items[i].customerGroupId" To iCustomerGroupId
Get ComStringOf Of hoJResp "items[i].customerGroup" To sCustomerGroup
Get ComBoolOf Of hoJResp "items[i].customerTaxExempt" To iCustomerTaxExempt
Get ComStringOf Of hoJResp "items[i].customerTaxId" To sCustomerTaxId
Get ComBoolOf Of hoJResp "items[i].customerTaxIdValid" To iCustomerTaxIdValid
Get ComBoolOf Of hoJResp "items[i].reversedTaxApplied" To iReversedTaxApplied
Get ComIntOf Of hoJResp "items[i].discount" To iDiscount
Get ComIntOf Of hoJResp "items[i].couponDiscount" To iCouponDiscount
Get ComIntOf Of hoJResp "items[i].volumeDiscount" To iVolumeDiscount
Get ComIntOf Of hoJResp "items[i].membershipBasedDiscount" To iMembershipBasedDiscount
Get ComIntOf Of hoJResp "items[i].totalAndMembershipBasedDiscount" To iTotalAndMembershipBasedDiscount
Get ComIntOf Of hoJResp "items[i].discountCoupon.id" To iDiscountCouponId
Get ComStringOf Of hoJResp "items[i].discountCoupon.name" To sDiscountCouponName
Get ComStringOf Of hoJResp "items[i].discountCoupon.code" To sDiscountCouponCode
Get ComStringOf Of hoJResp "items[i].discountCoupon.discountType" To sDiscountCouponDiscountType
Get ComStringOf Of hoJResp "items[i].discountCoupon.status" To sDiscountCouponStatus
Get ComIntOf Of hoJResp "items[i].discountCoupon.discount" To iDiscountCouponDiscount
Get ComStringOf Of hoJResp "items[i].discountCoupon.launchDate" To sDiscountCouponLaunchDate
Get ComStringOf Of hoJResp "items[i].discountCoupon.usesLimit" To sDiscountCouponUsesLimit
Get ComStringOf Of hoJResp "items[i].discountCoupon.applicationLimit" To sDiscountCouponApplicationLimit
Get ComStringOf Of hoJResp "items[i].discountCoupon.creationDate" To sDiscountCouponCreationDate
Get ComStringOf Of hoJResp "items[i].discountCoupon.updateDate" To sDiscountCouponUpdateDate
Get ComIntOf Of hoJResp "items[i].discountCoupon.orderCount" To iDiscountCouponOrderCount
Get ComStringOf Of hoJResp "items[i].refundedAmount" To sRefundedAmount
Get ComStringOf Of hoJResp "items[i].billingPerson.name" To sBillingPersonName
Get ComStringOf Of hoJResp "items[i].billingPerson.companyName" To sBillingPersonCompanyName
Get ComStringOf Of hoJResp "items[i].billingPerson.street" To sBillingPersonStreet
Get ComStringOf Of hoJResp "items[i].billingPerson.city" To sBillingPersonCity
Get ComStringOf Of hoJResp "items[i].billingPerson.countryCode" To sBillingPersonCountryCode
Get ComStringOf Of hoJResp "items[i].billingPerson.countryName" To sBillingPersonCountryName
Get ComStringOf Of hoJResp "items[i].billingPerson.postalCode" To sBillingPersonPostalCode
Get ComStringOf Of hoJResp "items[i].billingPerson.stateOrProvinceCode" To sBillingPersonStateOrProvinceCode
Get ComStringOf Of hoJResp "items[i].billingPerson.stateOrProvinceName" To sBillingPersonStateOrProvinceName
Get ComStringOf Of hoJResp "items[i].billingPerson.phone" To sBillingPersonPhone
Get ComStringOf Of hoJResp "items[i].shippingPerson.name" To sShippingPersonName
Get ComStringOf Of hoJResp "items[i].shippingPerson.companyName" To sShippingPersonCompanyName
Get ComStringOf Of hoJResp "items[i].shippingPerson.street" To sShippingPersonStreet
Get ComStringOf Of hoJResp "items[i].shippingPerson.city" To sShippingPersonCity
Get ComStringOf Of hoJResp "items[i].shippingPerson.countryCode" To sShippingPersonCountryCode
Get ComStringOf Of hoJResp "items[i].shippingPerson.countryName" To sShippingPersonCountryName
Get ComStringOf Of hoJResp "items[i].shippingPerson.postalCode" To sShippingPersonPostalCode
Get ComStringOf Of hoJResp "items[i].shippingPerson.stateOrProvinceCode" To sShippingPersonStateOrProvinceCode
Get ComStringOf Of hoJResp "items[i].shippingPerson.stateOrProvinceName" To sShippingPersonStateOrProvinceName
Get ComStringOf Of hoJResp "items[i].shippingPerson.phone" To sShippingPersonPhone
Get ComStringOf Of hoJResp "items[i].shippingOption.shippingCarrierName" To sShippingOptionShippingCarrierName
Get ComStringOf Of hoJResp "items[i].shippingOption.shippingMethodName" To sShippingOptionShippingMethodName
Get ComStringOf Of hoJResp "items[i].shippingOption.shippingRate" To sShippingOptionShippingRate
Get ComStringOf Of hoJResp "items[i].shippingOption.estimatedTransitTime" To sShippingOptionEstimatedTransitTime
Get ComBoolOf Of hoJResp "items[i].shippingOption.isPickup" To iShippingOptionIsPickup
Get ComStringOf Of hoJResp "items[i].handlingFee.name" To sHandlingFeeName
Get ComIntOf Of hoJResp "items[i].handlingFee.value" To iHandlingFeeValue
Get ComStringOf Of hoJResp "items[i].handlingFee.description" To sHandlingFeeDescription
Get ComStringOf Of hoJResp "items[i].paymentModule" To sPaymentModule
Get ComStringOf Of hoJResp "items[i].additionalInfo.google_customer_id" To sAdditionalInfoGoogle_customer_id
Get ComBoolOf Of hoJResp "items[i].acceptMarketing" To iAcceptMarketing
Get ComStringOf Of hoJResp "items[i].refererId" To sRefererId
Get ComBoolOf Of hoJResp "items[i].disableAllCustomerNotifications" To iDisableAllCustomerNotifications
Get ComBoolOf Of hoJResp "items[i].externalFulfillment" To iExternalFulfillment
Get ComBoolOf Of hoJResp "items[i].pricesIncludeTax" To iPricesIncludeTax
Move 0 To j
Get ComSizeOfArray Of hoJResp "items[i].customDiscount" To iCount_j
While (j < iCount_j)
Set ComJ Of hoJResp To j
Move (j + 1) To j
Loop
Move 0 To j
Get ComSizeOfArray Of hoJResp "items[i].discountInfo" To iCount_j
While (j < iCount_j)
Set ComJ Of hoJResp To j
Get ComIntOf Of hoJResp "items[i].discountInfo[j].value" To iValue
Get ComStringOf Of hoJResp "items[i].discountInfo[j].type" To sV_type
Get ComStringOf Of hoJResp "items[i].discountInfo[j].base" To sBase
Get ComIntOf Of hoJResp "items[i].discountInfo[j].orderTotal" To iOrderTotal
Move (j + 1) To j
Loop
Move 0 To j
Get ComSizeOfArray Of hoJResp "items[i].items" To iCount_j
While (j < iCount_j)
Set ComJ Of hoJResp To j
Get ComIntOf Of hoJResp "items[i].items[j].id" To iId_int
Get ComIntOf Of hoJResp "items[i].items[j].productId" To iProductId
Get ComIntOf Of hoJResp "items[i].items[j].categoryId" To iCategoryId
Get ComIntOf Of hoJResp "items[i].items[j].price" To iPrice
Get ComIntOf Of hoJResp "items[i].items[j].productPrice" To iProductPrice
Get ComStringOf Of hoJResp "items[i].items[j].sku" To sSku
Get ComIntOf Of hoJResp "items[i].items[j].quantity" To iQuantity
Get ComStringOf Of hoJResp "items[i].items[j].shortDescription" To sShortDescription
Get ComStringOf Of hoJResp "items[i].items[j].tax" To sTax
Get ComIntOf Of hoJResp "items[i].items[j].shipping" To iShipping
Get ComIntOf Of hoJResp "items[i].items[j].quantityInStock" To iQuantityInStock
Get ComStringOf Of hoJResp "items[i].items[j].name" To sName
Get ComBoolOf Of hoJResp "items[i].items[j].isShippingRequired" To iIsShippingRequired
Get ComIntOf Of hoJResp "items[i].items[j].weight" To iWeight
Get ComBoolOf Of hoJResp "items[i].items[j].trackQuantity" To iTrackQuantity
Get ComBoolOf Of hoJResp "items[i].items[j].fixedShippingRateOnly" To iFixedShippingRateOnly
Get ComStringOf Of hoJResp "items[i].items[j].imageUrl" To sImageUrl
Get ComStringOf Of hoJResp "items[i].items[j].smallThumbnailUrl" To sSmallThumbnailUrl
Get ComStringOf Of hoJResp "items[i].items[j].hdThumbnailUrl" To sHdThumbnailUrl
Get ComIntOf Of hoJResp "items[i].items[j].fixedShippingRate" To iFixedShippingRate
Get ComBoolOf Of hoJResp "items[i].items[j].digital" To iDigital
Get ComBoolOf Of hoJResp "items[i].items[j].couponApplied" To iCouponApplied
Get ComIntOf Of hoJResp "items[i].items[j].dimensions.length" To iDimensionsLength
Get ComIntOf Of hoJResp "items[i].items[j].dimensions.width" To iDimensionsWidth
Get ComIntOf Of hoJResp "items[i].items[j].dimensions.height" To iDimensionsHeight
Get ComStringOf Of hoJResp "items[i].items[j].couponAmount" To sCouponAmount
Get ComIntOf Of hoJResp "items[i].items[j].subscriptionId" To iSubscriptionId
Get ComStringOf Of hoJResp "items[i].items[j].recurringChargeSettings.recurringInterval" To sRecurringChargeSettingsRecurringInterval
Get ComIntOf Of hoJResp "items[i].items[j].recurringChargeSettings.recurringIntervalCount" To iRecurringChargeSettingsRecurringIntervalCount
Move 0 To k
Get ComSizeOfArray Of hoJResp "items[i].items[j].selectedOptions" To iCount_k
While (k < iCount_k)
Set ComK Of hoJResp To k
Get ComStringOf Of hoJResp "items[i].items[j].selectedOptions[k].name" To sName
Get ComStringOf Of hoJResp "items[i].items[j].selectedOptions[k].value" To sValue_str
Get ComStringOf Of hoJResp "items[i].items[j].selectedOptions[k].type" To sV_type
Get pvComObject of hoJson1 to vJson1
Get ComObjectOf2 Of hoJResp "items[i].items[j].selectedOptions[k]" vJson1 To iSuccess
Move 0 To iI1
Get ComSizeOfArray Of hoJson1 "valuesArray" To iCount_i1
While (iI1 < iCount_i1)
Set ComI Of hoJson1 To iI1
Get ComStringOf Of hoJson1 "valuesArray[i]" To sStrVal
Move (iI1 + 1) To iI1
Loop
Get pvComObject of hoJson1 to vJson1
Get ComObjectOf2 Of hoJResp "items[i].items[j].selectedOptions[k]" vJson1 To iSuccess
Move 0 To iI1
Get ComSizeOfArray Of hoJson1 "selections" To iCount_i1
While (iI1 < iCount_i1)
Set ComI Of hoJson1 To iI1
Get ComStringOf Of hoJson1 "selections[i].selectionTitle" To sSelectionTitle
Get ComIntOf Of hoJson1 "selections[i].selectionModifier" To iSelectionModifier
Get ComStringOf Of hoJson1 "selections[i].selectionModifierType" To sSelectionModifierType
Move (iI1 + 1) To iI1
Loop
Move (k + 1) To k
Loop
Move 0 To k
Get ComSizeOfArray Of hoJResp "items[i].items[j].taxes" To iCount_k
While (k < iCount_k)
Set ComK Of hoJResp To k
Get ComStringOf Of hoJResp "items[i].items[j].taxes[k].name" To sName
Get ComIntOf Of hoJResp "items[i].items[j].taxes[k].value" To iValue
Get ComStringOf Of hoJResp "items[i].items[j].taxes[k].total" To sTotal_str
Get ComStringOf Of hoJResp "items[i].items[j].taxes[k].taxOnDiscountedSubtotal" To sTaxOnDiscountedSubtotal
Get ComIntOf Of hoJResp "items[i].items[j].taxes[k].taxOnShipping" To iTaxOnShipping
Get ComBoolOf Of hoJResp "items[i].items[j].taxes[k].includeInPrice" To iIncludeInPrice
Move (k + 1) To k
Loop
Move 0 To k
Get ComSizeOfArray Of hoJResp "items[i].items[j].discounts" To iCount_k
While (k < iCount_k)
Set ComK Of hoJResp To k
Get ComIntOf Of hoJResp "items[i].items[j].discounts[k].discountInfo.value" To iDiscountInfoValue
Get ComStringOf Of hoJResp "items[i].items[j].discounts[k].discountInfo.type" To sDiscountInfoType
Get ComStringOf Of hoJResp "items[i].items[j].discounts[k].discountInfo.base" To sDiscountInfoBase
Get ComIntOf Of hoJResp "items[i].items[j].discounts[k].discountInfo.orderTotal" To iDiscountInfoOrderTotal
Get ComStringOf Of hoJResp "items[i].items[j].discounts[k].total" To sTotal_str
Move (k + 1) To k
Loop
Move (j + 1) To j
Loop
Move 0 To j
Get ComSizeOfArray Of hoJResp "items[i].refunds" To iCount_j
While (j < iCount_j)
Set ComJ Of hoJResp To j
Get ComStringOf Of hoJResp "items[i].refunds[j].date" To sDate
Get ComStringOf Of hoJResp "items[i].refunds[j].source" To sSource
Get ComStringOf Of hoJResp "items[i].refunds[j].reason" To sReason
Get ComStringOf Of hoJResp "items[i].refunds[j].amount" To sAmount
Move (j + 1) To j
Loop
Move 0 To j
Get ComSizeOfArray Of hoJResp "items[i].predictedPackage" To iCount_j
While (j < iCount_j)
Set ComJ Of hoJResp To j
Get ComIntOf Of hoJResp "items[i].predictedPackage[j].length" To iLength
Get ComIntOf Of hoJResp "items[i].predictedPackage[j].width" To iWidth
Get ComIntOf Of hoJResp "items[i].predictedPackage[j].height" To iHeight
Get ComStringOf Of hoJResp "items[i].predictedPackage[j].weight" To sWeight_str
Get ComStringOf Of hoJResp "items[i].predictedPackage[j].declaredValue" To sDeclaredValue
Move (j + 1) To j
Loop
Move 0 To j
Get ComSizeOfArray Of hoJResp "items[i].shipments" To iCount_j
While (j < iCount_j)
Set ComJ Of hoJResp To j
Get ComStringOf Of hoJResp "items[i].shipments[j].id" To sId
Get ComStringOf Of hoJResp "items[i].shipments[j].created" To sCreated
Get ComStringOf Of hoJResp "items[i].shipments[j].shipTo.name" To sShipToName
Get ComStringOf Of hoJResp "items[i].shipments[j].shipTo.companyName" To sShipToCompanyName
Get ComStringOf Of hoJResp "items[i].shipments[j].shipTo.street" To sShipToStreet
Get ComStringOf Of hoJResp "items[i].shipments[j].shipTo.city" To sShipToCity
Get ComStringOf Of hoJResp "items[i].shipments[j].shipTo.countryCode" To sShipToCountryCode
Get ComStringOf Of hoJResp "items[i].shipments[j].shipTo.countryName" To sShipToCountryName
Get ComStringOf Of hoJResp "items[i].shipments[j].shipTo.postalCode" To sShipToPostalCode
Get ComStringOf Of hoJResp "items[i].shipments[j].shipTo.stateOrProvinceCode" To sShipToStateOrProvinceCode
Get ComStringOf Of hoJResp "items[i].shipments[j].shipTo.stateOrProvinceName" To sShipToStateOrProvinceName
Get ComStringOf Of hoJResp "items[i].shipments[j].shipTo.phone" To sShipToPhone
Get ComStringOf Of hoJResp "items[i].shipments[j].shipFrom.companyName" To sShipFromCompanyName
Get ComStringOf Of hoJResp "items[i].shipments[j].shipFrom.street" To sShipFromStreet
Get ComStringOf Of hoJResp "items[i].shipments[j].shipFrom.city" To sShipFromCity
Get ComStringOf Of hoJResp "items[i].shipments[j].shipFrom.countryCode" To sShipFromCountryCode
Get ComStringOf Of hoJResp "items[i].shipments[j].shipFrom.countryName" To sShipFromCountryName
Get ComStringOf Of hoJResp "items[i].shipments[j].shipFrom.postalCode" To sShipFromPostalCode
Get ComStringOf Of hoJResp "items[i].shipments[j].shipFrom.stateOrProvinceCode" To sShipFromStateOrProvinceCode
Get ComStringOf Of hoJResp "items[i].shipments[j].shipFrom.stateOrProvinceName" To sShipFromStateOrProvinceName
Get ComStringOf Of hoJResp "items[i].shipments[j].shipFrom.phone" To sShipFromPhone
Get ComStringOf Of hoJResp "items[i].shipments[j].parcel.weight" To sParcelWeight
Get ComIntOf Of hoJResp "items[i].shipments[j].parcel.weightUnit" To iParcelWeightUnit
Get ComIntOf Of hoJResp "items[i].shipments[j].parcel.width" To iParcelWidth
Get ComIntOf Of hoJResp "items[i].shipments[j].parcel.height" To iParcelHeight
Get ComIntOf Of hoJResp "items[i].shipments[j].parcel.length" To iParcelLength
Get ComIntOf Of hoJResp "items[i].shipments[j].parcel.dimensionUnit" To iParcelDimensionUnit
Get ComIntOf Of hoJResp "items[i].shipments[j].shippingService.carrier" To iShippingServiceCarrier
Get ComIntOf Of hoJResp "items[i].shipments[j].shippingService.carrierName" To iShippingServiceCarrierName
Get ComStringOf Of hoJResp "items[i].shipments[j].shippingService.carrierServiceName" To sShippingServiceCarrierServiceName
Get ComStringOf Of hoJResp "items[i].shipments[j].shippingService.carrierServiceCode" To sShippingServiceCarrierServiceCode
Get ComStringOf Of hoJResp "items[i].shipments[j].tracking.tracking_number" To sTrackingTracking_number
Get ComStringOf Of hoJResp "items[i].shipments[j].tracking.tracking_url" To sTrackingTracking_url
Get ComIntOf Of hoJResp "items[i].shipments[j].tracking.estimatedDays" To iTrackingEstimatedDays
Get ComStringOf Of hoJResp "items[i].shipments[j].shippingLabel.label_url" To sShippingLabelLabel_url
Get ComStringOf Of hoJResp "items[i].shipments[j].shippingLabel.commercial_invoice_url" To sShippingLabelCommercial_invoice_url
Move (j + 1) To j
Loop
Move 0 To j
Get ComSizeOfArray Of hoJResp "items[i].taxesOnShipping" To iCount_j
While (j < iCount_j)
Set ComJ Of hoJResp To j
Get ComStringOf Of hoJResp "items[i].taxesOnShipping[j].name" To sName
Get ComIntOf Of hoJResp "items[i].taxesOnShipping[j].value" To iValue
Get ComStringOf Of hoJResp "items[i].taxesOnShipping[j].total" To sTotal_str
Move (j + 1) To j
Loop
Move 0 To j
Get ComSizeOfArray Of hoJResp "items[i].orderExtraFields" To iCount_j
While (j < iCount_j)
Set ComJ Of hoJResp To j
Get ComStringOf Of hoJResp "items[i].orderExtraFields[j].id" To sId
Get ComStringOf Of hoJResp "items[i].orderExtraFields[j].value" To sValue_str
Get ComStringOf Of hoJResp "items[i].orderExtraFields[j].customerInputType" To sCustomerInputType
Get ComStringOf Of hoJResp "items[i].orderExtraFields[j].title" To sTitle
Get ComStringOf Of hoJResp "items[i].orderExtraFields[j].orderDetailsDisplaySection" To sOrderDetailsDisplaySection
Get ComStringOf Of hoJResp "items[i].orderExtraFields[j].orderBy" To sOrderBy
Move (j + 1) To j
Loop
Move (i + 1) To i
Loop
End_Procedure