|
Chilkat • HOME • .NET Core C# • Android™ • AutoIt • C • C# • C++ • Chilkat2-Python • CkPython • Classic ASP • DataFlex • Delphi ActiveX • Delphi DLL • Go • Java • Lianja • Mono C# • Node.js • Objective-C • PHP ActiveX • PHP Extension • Perl • PowerBuilder • PowerShell • PureBasic • Ruby • SQL Server • Swift 2 • Swift 3,4,5... • Tcl • Unicode C • Unicode C++ • VB.NET • VBScript • Visual Basic 6.0 • Visual FoxPro • Xojo Plugin
(DataFlex) Ecwid - Search OrdersSee more Ecwid ExamplesSearch or filter orders in an Ecwid store. The response provides full details of the found orders. For more information, see https://api-docs.ecwid.com/reference/orders#search-orders
Use ChilkatAx-win32.pkg Procedure Test Handle hoHttp Boolean iSuccess 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 Boolean bTemp1 // 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 pvComObject of hoParams to vParams Get ComQuickRequestParams Of hoHttp "GET" "https://app.ecwid.com/api/v3/storeId/orders" vParams To vResp If (IsComObject(vResp)) Begin Get Create (RefClass(cComChilkatHttpResponse)) To hoResp Set pvComObject Of hoResp To vResp End Get ComLastMethodSuccess Of hoHttp To bTemp1 If (bTemp1 = 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 Send Destroy of hoResp 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 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 ComObjectOf Of hoJResp "items[i].items[j].selectedOptions[k]" To vJson1 If (IsComObject(vJson1)) Begin Get Create (RefClass(cComChilkatJsonObject)) To hoJson1 Set pvComObject Of hoJson1 To vJson1 End 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 Send Destroy of hoJson1 Get ComObjectOf Of hoJResp "items[i].items[j].selectedOptions[k]" To vJson1 If (IsComObject(vJson1)) Begin Get Create (RefClass(cComChilkatJsonObject)) To hoJson1 Set pvComObject Of hoJson1 To vJson1 End 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 Send Destroy of hoJson1 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 |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.