|
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
(Xojo Plugin) 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
// This example assumes the Chilkat API to have been previously unlocked. // See Global Unlock Sample for sample code. Dim http As New Chilkat.Http Dim success As Boolean // Implements the following CURL command: // curl --request GET \ // --url 'https://app.ecwid.com/api/v3/storeId/orders?token=token' \ // --header 'Accept: application/json' // Use the following online tool to generate HTTP code from a CURL command // Convert a cURL Command to HTTP Source Code // Load the access token previously obtained in Ecwid Get Access Token Dim jsonToken As New Chilkat.JsonObject success = jsonToken.LoadFile("qa_data/tokens/ecwid.json") http.SetRequestHeader "Accept","application/json" Dim params As New Chilkat.JsonObject success = params.UpdateInt("limit",100) success = params.UpdateString("email","joe@example.com") success = params.UpdateString("token",jsonToken.StringOf("access_token")) Dim resp As Chilkat.HttpResponse resp = http.QuickRequestParams("GET","https://app.ecwid.com/api/v3/storeId/orders",params) If (http.LastMethodSuccess = False) Then System.DebugLog(http.LastErrorText) Return End If Dim sbResponseBody As New Chilkat.StringBuilder success = resp.GetBodySb(sbResponseBody) Dim jResp As New Chilkat.JsonObject success = jResp.LoadSb(sbResponseBody) jResp.EmitCompact = False System.DebugLog("Response Body:") System.DebugLog(jResp.Emit()) Dim respStatusCode As Int32 respStatusCode = resp.StatusCode System.DebugLog("Response Status Code = " + Str(respStatusCode)) If (respStatusCode <> 200) Then System.DebugLog("Failed.") Return End If // Sample JSON response: // (Sample code for parsing the JSON response is shown below) // { // "total": 1, // "count": 1, // "offset": 0, // "limit": 100, // "items": [ // { // "id": "XJ12H", // "subtotal": 1076.64, // "total": 2014.97, // "giftCardRedemption": 2.23, // "totalBeforeGiftCardRedemption": 2.23, // "giftCardDoubleSpending": false, // "usdTotal": 2014.97, // "tax": 488.48, // "paymentMethod": "Credit or debit card (Mollie)", // "paymentStatus": "PARTIALLY_REFUNDED", // "fulfillmentStatus": "DELIVERED", // "vendorOrderNumber": "XJ12H", // "orderNumber": 1082727626, // "refererUrl": "https://mdemo.ecwid.com/", // "globalReferer": "https://my.ecwid.com/", // "createDate": "2018-05-31 15:08:36 +0000", // "updateDate": "2018-05-31 15:09:35 +0000", // "createTimestamp": 1527779316, // "updateTimestamp": 1527779375, // "hidden": false, // "orderComments": "Test order comments", // "privateAdminNotes": "Must be delivered till Sunday.", // "email": "mscott@gmail.com", // "ipAddress": "123.431.234.243", // "customerId": 40201284, // "customerGroupId": 12345, // "customerGroup": "Gold", // "customerTaxExempt": false, // "customerTaxId": "", // "customerTaxIdValid": false, // "reversedTaxApplied": false, // "discount": 4, // "couponDiscount": 22, // "volumeDiscount": 4, // "membershipBasedDiscount": 0, // "totalAndMembershipBasedDiscount": 0, // "customDiscount": [ // ], // "discountCoupon": { // "id": 29567026, // "name": "API Testing", // "code": "APITESTING", // "discountType": "ABS", // "status": "ACTIVE", // "discount": 22, // "launchDate": "2018-05-24 20:00:00 +0000", // "usesLimit": "UNLIMITED", // "applicationLimit": "UNLIMITED", // "creationDate": "2018-05-31 15:08:33 +0000", // "updateDate": "2018-05-24 13:40:32 +0000", // "orderCount": 0 // }, // "discountInfo": [ // { // "value": 4, // "type": "ABS", // "base": "ON_TOTAL", // "orderTotal": 1 // } // ], // "items": [ // { // "id": 140273658, // "productId": 66722487, // "categoryId": 19563207, // "price": 1060, // "productPrice": 1000, // "sku": "ABCA-IAC", // "quantity": 1, // "shortDescription": "", // "tax": 331.01, // "shipping": 0, // "quantityInStock": 0, // "name": "iMac", // "isShippingRequired": true, // "weight": 0, // "trackQuantity": false, // "fixedShippingRateOnly": false, // "imageUrl": "https://ecwid-images-ru.gcdn.co/images/5035009/391870914.jpg", // "smallThumbnailUrl": "https://ecwid-images-ru.gcdn.co/images/5035009/650638292.jpg", // "hdThumbnailUrl": "https://ecwid-images-ru.gcdn.co/images/5035009/650638293.jpg", // "fixedShippingRate": 0, // "digital": false, // "couponApplied": true, // "selectedOptions": [ // { // "name": "Price-Optimizer", // "value": "6", // "valuesArray": [ // "6" // ], // "selections": [ // { // "selectionTitle": "6", // "selectionModifier": 6, // "selectionModifierType": "PERCENT" // } // ], // "type": "CHOICE" // } // ], // "taxes": [ // { // "name": "State tax", // "value": 12, // "total": 124.13, // "taxOnDiscountedSubtotal": 124.13, // "taxOnShipping": 0, // "includeInPrice": false // }, // { // "name": "TVA", // "value": 20, // "total": 206.88, // "taxOnDiscountedSubtotal": 206.88, // "taxOnShipping": 0, // "includeInPrice": true // } // ], // "dimensions": { // "length": 0, // "width": 0, // "height": 0 // }, // "couponAmount": 21.66, // "discounts": [ // { // "discountInfo": { // "value": 4, // "type": "ABS", // "base": "ON_TOTAL", // "orderTotal": 1 // }, // "total": 3.94 // } // ] // }, // { // "id": 140273659, // "productId": 66821181, // "categoryId": 0, // "price": 16.64, // "productPrice": 16, // "sku": "001001", // "quantity": 1, // "shortDescription": "This sturdy white, glossy ceramic mug is an essential to your cupboard. This brawny version of ceramic mugs shows it’s ...", // "tax": 157.47, // "shipping": 471.85, // "quantityInStock": 0, // "name": "Mug", // "isShippingRequired": true, // "weight": 0.4, // "trackQuantity": false, // "fixedShippingRateOnly": false, // "imageUrl": "https://ecwid-images-ru.gcdn.co/images/5035009/389900000.jpg", // "smallThumbnailUrl": "https://ecwid-images-ru.gcdn.co/images/5035009/475772545.jpg", // "hdThumbnailUrl": "https://ecwid-images-ru.gcdn.co/images/5035009/408631478.jpg", // "fixedShippingRate": 0, // "digital": false, // "couponApplied": true, // "selectedOptions": [ // { // "name": "Color", // "value": "White", // "valuesArray": [ // "White" // ], // "selections": [ // { // "selectionTitle": "White", // "selectionModifier": 0, // "selectionModifierType": "ABSOLUTE" // } // ], // "type": "CHOICE" // }, // { // "name": "Size", // "value": "11oz", // "valuesArray": [ // "11oz" // ], // "selections": [ // { // "selectionTitle": "11oz", // "selectionModifier": 0, // "selectionModifierType": "ABSOLUTE" // } // ], // "type": "CHOICE" // }, // { // "name": "Price-Optimizer", // "value": "4", // "valuesArray": [ // "4" // ], // "selections": [ // { // "selectionTitle": "4", // "selectionModifier": 4, // "selectionModifierType": "PERCENT" // } // ], // "type": "CHOICE" // } // ], // "taxes": [ // { // "name": "State tax", // "value": 12, // "total": 59.05, // "taxOnDiscountedSubtotal": 1.95, // "taxOnShipping": 57.1, // "includeInPrice": false // }, // { // "name": "TVA", // "value": 20, // "total": 98.42, // "taxOnDiscountedSubtotal": 3.25, // "taxOnShipping": 95.17, // "includeInPrice": true // } // ], // "dimensions": { // "length": 0, // "width": 0, // "height": 0 // }, // "couponAmount": 0.34, // "discounts": [ // { // "discountInfo": { // "value": 4, // "type": "ABS", // "base": "ON_TOTAL", // "orderTotal": 1 // }, // "total": 0.06 // } // ] // }, // { // "subscriptionId": 123456, // "recurringChargeSettings": { // "recurringInterval": "month", // "recurringIntervalCount": 1 // } // } // ], // "refundedAmount": 3.5, // "refunds": [ // { // "date": "2017-09-12 10:12:56 +0000", // "source": "CP", // "reason": "Testing!", // "amount": 3.5 // } // ], // "billingPerson": { // "name": "Michael Scott", // "companyName": "", // "street": "555 Lackawanna Ave", // "city": "Scranton", // "countryCode": "US", // "countryName": "United States", // "postalCode": "18508", // "stateOrProvinceCode": "PA", // "stateOrProvinceName": "Pennsylvania", // "phone": "" // }, // "shippingPerson": { // "name": "Michael Scott", // "companyName": "", // "street": "555 Lackawanna Ave", // "city": "Scranton", // "countryCode": "US", // "countryName": "United States", // "postalCode": "18508", // "stateOrProvinceCode": "PA", // "stateOrProvinceName": "Pennsylvania", // "phone": "" // }, // "shippingOption": { // "shippingCarrierName": "Shipping app the-printful", // "shippingMethodName": "USPS Priority Mail", // "shippingRate": 471.85, // "estimatedTransitTime": "1-3", // "isPickup": false // }, // "handlingFee": { // "name": "Handling Fee", // "value": 4, // "description": "" // }, // "predictedPackage": [ // { // "length": 0, // "width": 0, // "height": 0, // "weight": 0.4, // "declaredValue": 1076.64 // } // ], // "shipments": [ // { // "id": "5e79bd4f-9ebf-4ab8-b901-24c9b48b19eb", // "created": "2020-04-23 19:13:43 +0000", // "shipTo": { // "name": "Michael Scott", // "companyName": "", // "street": "555 Lackawanna Ave", // "city": "Scranton", // "countryCode": "US", // "countryName": "United States", // "postalCode": "18508", // "stateOrProvinceCode": "PA", // "stateOrProvinceName": "Pennsylvania", // "phone": "" // }, // "shipFrom": { // "companyName": "Roga Kopyty Inc", // "street": "444 fff", // "city": "New York", // "countryCode": "US", // "countryName": "United States", // "postalCode": "10001", // "stateOrProvinceCode": "NY", // "stateOrProvinceName": "New York", // "phone": "1011991919" // }, // "parcel": { // "weight": 0.5, // "weightUnit": 'KILOGRAM', // "width": 10, // "height": 10, // "length": 10, // "dimensionUnit": 'CM' // }, // "shippingService": { // "carrier": 'USPS', // "carrierName": 'Shipping, // "carrierServiceName": "Priority Mail", // "carrierServiceCode": "usps_priority" // }, // "tracking": { // "tracking_number": "9499907123456123456781", // "tracking_url": "https://tools.usps.com/go/TrackConfirmAction_input?origTrackNum=9499907123456123456781", // "estimatedDays": 3 // }, // "shippingLabel": { // "label_url": "https://shippo-delivery.s3.amazonaws.com/70ae8117ee1749e393f249d5b77c45e0.pdf?Signature=vDw1ltcyGveVR1OQoUDdzC43BY8%3D&Expires=1437093830&AWSAccessKeyId=AKIAJTHP3LLFMYAWALIA", // "commercial_invoice_url": "" // } // } // ], // "taxesOnShipping": [ // { // "name": "State tax", // "value": 12, // "total": 57.1 // }, // { // "name": "TVA", // "value": 20, // "total": 95.17 // } // ], // "paymentModule": "CUSTOM_PAYMENT_APP-mollie-pg", // "additionalInfo": { // "google_customer_id": "2008512504.1526280224" // }, // "paymentParams": {}, // "orderExtraFields": [ // { // "id": "lang", // "value": "en", // "customerInputType": "", // "title": "", // "orderDetailsDisplaySection": "", // "orderBy": "1" // }, // { // "id": "askHowYouFoundUsApp", // "value": "From a friend", // "customerInputType": "SELECT", // "title": "How did you hear about us?", // "orderDetailsDisplaySection": "order_comments", // "orderBy": "2" // } // ], // "acceptMarketing": true, // "refererId": "Amazon", // "disableAllCustomerNotifications": false, // "externalFulfillment": false, // "pricesIncludeTax": false // } // ] // } // Sample code for parsing the JSON response... // Use the following online tool to generate parsing code from sample JSON: // Generate Parsing Code from JSON Dim id As String Dim subtotal As String Dim total_str As String Dim giftCardRedemption As String Dim totalBeforeGiftCardRedemption As String Dim giftCardDoubleSpending As Boolean Dim usdTotal As String Dim tax As String Dim paymentMethod As String Dim paymentStatus As String Dim fulfillmentStatus As String Dim vendorOrderNumber As String Dim orderNumber As Int32 Dim refererUrl As String Dim globalReferer As String Dim createDate As String Dim updateDate As String Dim createTimestamp As Int32 Dim updateTimestamp As Int32 Dim hidden As Boolean Dim orderComments As String Dim privateAdminNotes As String Dim email As String Dim ipAddress As String Dim customerId As Int32 Dim customerGroupId As Int32 Dim customerGroup As String Dim customerTaxExempt As Boolean Dim customerTaxId As String Dim customerTaxIdValid As Boolean Dim reversedTaxApplied As Boolean Dim discount As Int32 Dim couponDiscount As Int32 Dim volumeDiscount As Int32 Dim membershipBasedDiscount As Int32 Dim totalAndMembershipBasedDiscount As Int32 Dim discountCouponId As Int32 Dim discountCouponName As String Dim discountCouponCode As String Dim discountCouponDiscountType As String Dim discountCouponStatus As String Dim discountCouponDiscount As Int32 Dim discountCouponLaunchDate As String Dim discountCouponUsesLimit As String Dim discountCouponApplicationLimit As String Dim discountCouponCreationDate As String Dim discountCouponUpdateDate As String Dim discountCouponOrderCount As Int32 Dim refundedAmount As String Dim billingPersonName As String Dim billingPersonCompanyName As String Dim billingPersonStreet As String Dim billingPersonCity As String Dim billingPersonCountryCode As String Dim billingPersonCountryName As String Dim billingPersonPostalCode As String Dim billingPersonStateOrProvinceCode As String Dim billingPersonStateOrProvinceName As String Dim billingPersonPhone As String Dim shippingPersonName As String Dim shippingPersonCompanyName As String Dim shippingPersonStreet As String Dim shippingPersonCity As String Dim shippingPersonCountryCode As String Dim shippingPersonCountryName As String Dim shippingPersonPostalCode As String Dim shippingPersonStateOrProvinceCode As String Dim shippingPersonStateOrProvinceName As String Dim shippingPersonPhone As String Dim shippingOptionShippingCarrierName As String Dim shippingOptionShippingMethodName As String Dim shippingOptionShippingRate As String Dim shippingOptionEstimatedTransitTime As String Dim shippingOptionIsPickup As Boolean Dim handlingFeeName As String Dim handlingFeeValue As Int32 Dim handlingFeeDescription As String Dim paymentModule As String Dim additionalInfoGoogle_customer_id As String Dim acceptMarketing As Boolean Dim refererId As String Dim disableAllCustomerNotifications As Boolean Dim externalFulfillment As Boolean Dim pricesIncludeTax As Boolean Dim j As Int32 Dim count_j As Int32 Dim value As Int32 Dim v_type As String Dim base As String Dim orderTotal As Int32 Dim id_int As Int32 Dim productId As Int32 Dim categoryId As Int32 Dim price As Int32 Dim productPrice As Int32 Dim sku As String Dim quantity As Int32 Dim shortDescription As String Dim shipping As Int32 Dim quantityInStock As Int32 Dim name As String Dim isShippingRequired As Boolean Dim weight As Int32 Dim trackQuantity As Boolean Dim fixedShippingRateOnly As Boolean Dim imageUrl As String Dim smallThumbnailUrl As String Dim hdThumbnailUrl As String Dim fixedShippingRate As Int32 Dim digital As Boolean Dim couponApplied As Boolean Dim dimensionsLength As Int32 Dim dimensionsWidth As Int32 Dim dimensionsHeight As Int32 Dim couponAmount As String Dim subscriptionId As Int32 Dim recurringChargeSettingsRecurringInterval As String Dim recurringChargeSettingsRecurringIntervalCount As Int32 Dim k As Int32 Dim count_k As Int32 Dim value_str As String Dim json1 As Chilkat.JsonObject Dim i1 As Int32 Dim count_i1 As Int32 Dim strVal As String Dim selectionTitle As String Dim selectionModifier As Int32 Dim selectionModifierType As String Dim taxOnDiscountedSubtotal As String Dim taxOnShipping As Int32 Dim includeInPrice As Boolean Dim discountInfoValue As Int32 Dim discountInfoType As String Dim discountInfoBase As String Dim discountInfoOrderTotal As Int32 Dim date As String Dim source As String Dim reason As String Dim amount As String Dim length As Int32 Dim width As Int32 Dim height As Int32 Dim weight_str As String Dim declaredValue As String Dim created As String Dim shipToName As String Dim shipToCompanyName As String Dim shipToStreet As String Dim shipToCity As String Dim shipToCountryCode As String Dim shipToCountryName As String Dim shipToPostalCode As String Dim shipToStateOrProvinceCode As String Dim shipToStateOrProvinceName As String Dim shipToPhone As String Dim shipFromCompanyName As String Dim shipFromStreet As String Dim shipFromCity As String Dim shipFromCountryCode As String Dim shipFromCountryName As String Dim shipFromPostalCode As String Dim shipFromStateOrProvinceCode As String Dim shipFromStateOrProvinceName As String Dim shipFromPhone As String Dim parcelWeight As String Dim parcelWeightUnit As Int32 Dim parcelWidth As Int32 Dim parcelHeight As Int32 Dim parcelLength As Int32 Dim parcelDimensionUnit As Int32 Dim shippingServiceCarrier As Int32 Dim shippingServiceCarrierName As Int32 Dim shippingServiceCarrierServiceName As String Dim shippingServiceCarrierServiceCode As String Dim trackingTracking_number As String Dim trackingTracking_url As String Dim trackingEstimatedDays As Int32 Dim shippingLabelLabel_url As String Dim shippingLabelCommercial_invoice_url As String Dim customerInputType As String Dim title As String Dim orderDetailsDisplaySection As String Dim orderBy As String Dim total As Int32 total = jResp.IntOf("total") Dim count As Int32 count = jResp.IntOf("count") Dim offset As Int32 offset = jResp.IntOf("offset") Dim limit As Int32 limit = jResp.IntOf("limit") Dim i As Int32 i = 0 Dim count_i As Int32 count_i = jResp.SizeOfArray("items") While i < count_i jResp.I = i id = jResp.StringOf("items[i].id") subtotal = jResp.StringOf("items[i].subtotal") total_str = jResp.StringOf("items[i].total") giftCardRedemption = jResp.StringOf("items[i].giftCardRedemption") totalBeforeGiftCardRedemption = jResp.StringOf("items[i].totalBeforeGiftCardRedemption") giftCardDoubleSpending = jResp.BoolOf("items[i].giftCardDoubleSpending") usdTotal = jResp.StringOf("items[i].usdTotal") tax = jResp.StringOf("items[i].tax") paymentMethod = jResp.StringOf("items[i].paymentMethod") paymentStatus = jResp.StringOf("items[i].paymentStatus") fulfillmentStatus = jResp.StringOf("items[i].fulfillmentStatus") vendorOrderNumber = jResp.StringOf("items[i].vendorOrderNumber") orderNumber = jResp.IntOf("items[i].orderNumber") refererUrl = jResp.StringOf("items[i].refererUrl") globalReferer = jResp.StringOf("items[i].globalReferer") createDate = jResp.StringOf("items[i].createDate") updateDate = jResp.StringOf("items[i].updateDate") createTimestamp = jResp.IntOf("items[i].createTimestamp") updateTimestamp = jResp.IntOf("items[i].updateTimestamp") hidden = jResp.BoolOf("items[i].hidden") orderComments = jResp.StringOf("items[i].orderComments") privateAdminNotes = jResp.StringOf("items[i].privateAdminNotes") email = jResp.StringOf("items[i].email") ipAddress = jResp.StringOf("items[i].ipAddress") customerId = jResp.IntOf("items[i].customerId") customerGroupId = jResp.IntOf("items[i].customerGroupId") customerGroup = jResp.StringOf("items[i].customerGroup") customerTaxExempt = jResp.BoolOf("items[i].customerTaxExempt") customerTaxId = jResp.StringOf("items[i].customerTaxId") customerTaxIdValid = jResp.BoolOf("items[i].customerTaxIdValid") reversedTaxApplied = jResp.BoolOf("items[i].reversedTaxApplied") discount = jResp.IntOf("items[i].discount") couponDiscount = jResp.IntOf("items[i].couponDiscount") volumeDiscount = jResp.IntOf("items[i].volumeDiscount") membershipBasedDiscount = jResp.IntOf("items[i].membershipBasedDiscount") totalAndMembershipBasedDiscount = jResp.IntOf("items[i].totalAndMembershipBasedDiscount") discountCouponId = jResp.IntOf("items[i].discountCoupon.id") discountCouponName = jResp.StringOf("items[i].discountCoupon.name") discountCouponCode = jResp.StringOf("items[i].discountCoupon.code") discountCouponDiscountType = jResp.StringOf("items[i].discountCoupon.discountType") discountCouponStatus = jResp.StringOf("items[i].discountCoupon.status") discountCouponDiscount = jResp.IntOf("items[i].discountCoupon.discount") discountCouponLaunchDate = jResp.StringOf("items[i].discountCoupon.launchDate") discountCouponUsesLimit = jResp.StringOf("items[i].discountCoupon.usesLimit") discountCouponApplicationLimit = jResp.StringOf("items[i].discountCoupon.applicationLimit") discountCouponCreationDate = jResp.StringOf("items[i].discountCoupon.creationDate") discountCouponUpdateDate = jResp.StringOf("items[i].discountCoupon.updateDate") discountCouponOrderCount = jResp.IntOf("items[i].discountCoupon.orderCount") refundedAmount = jResp.StringOf("items[i].refundedAmount") billingPersonName = jResp.StringOf("items[i].billingPerson.name") billingPersonCompanyName = jResp.StringOf("items[i].billingPerson.companyName") billingPersonStreet = jResp.StringOf("items[i].billingPerson.street") billingPersonCity = jResp.StringOf("items[i].billingPerson.city") billingPersonCountryCode = jResp.StringOf("items[i].billingPerson.countryCode") billingPersonCountryName = jResp.StringOf("items[i].billingPerson.countryName") billingPersonPostalCode = jResp.StringOf("items[i].billingPerson.postalCode") billingPersonStateOrProvinceCode = jResp.StringOf("items[i].billingPerson.stateOrProvinceCode") billingPersonStateOrProvinceName = jResp.StringOf("items[i].billingPerson.stateOrProvinceName") billingPersonPhone = jResp.StringOf("items[i].billingPerson.phone") shippingPersonName = jResp.StringOf("items[i].shippingPerson.name") shippingPersonCompanyName = jResp.StringOf("items[i].shippingPerson.companyName") shippingPersonStreet = jResp.StringOf("items[i].shippingPerson.street") shippingPersonCity = jResp.StringOf("items[i].shippingPerson.city") shippingPersonCountryCode = jResp.StringOf("items[i].shippingPerson.countryCode") shippingPersonCountryName = jResp.StringOf("items[i].shippingPerson.countryName") shippingPersonPostalCode = jResp.StringOf("items[i].shippingPerson.postalCode") shippingPersonStateOrProvinceCode = jResp.StringOf("items[i].shippingPerson.stateOrProvinceCode") shippingPersonStateOrProvinceName = jResp.StringOf("items[i].shippingPerson.stateOrProvinceName") shippingPersonPhone = jResp.StringOf("items[i].shippingPerson.phone") shippingOptionShippingCarrierName = jResp.StringOf("items[i].shippingOption.shippingCarrierName") shippingOptionShippingMethodName = jResp.StringOf("items[i].shippingOption.shippingMethodName") shippingOptionShippingRate = jResp.StringOf("items[i].shippingOption.shippingRate") shippingOptionEstimatedTransitTime = jResp.StringOf("items[i].shippingOption.estimatedTransitTime") shippingOptionIsPickup = jResp.BoolOf("items[i].shippingOption.isPickup") handlingFeeName = jResp.StringOf("items[i].handlingFee.name") handlingFeeValue = jResp.IntOf("items[i].handlingFee.value") handlingFeeDescription = jResp.StringOf("items[i].handlingFee.description") paymentModule = jResp.StringOf("items[i].paymentModule") additionalInfoGoogle_customer_id = jResp.StringOf("items[i].additionalInfo.google_customer_id") acceptMarketing = jResp.BoolOf("items[i].acceptMarketing") refererId = jResp.StringOf("items[i].refererId") disableAllCustomerNotifications = jResp.BoolOf("items[i].disableAllCustomerNotifications") externalFulfillment = jResp.BoolOf("items[i].externalFulfillment") pricesIncludeTax = jResp.BoolOf("items[i].pricesIncludeTax") j = 0 count_j = jResp.SizeOfArray("items[i].customDiscount") While j < count_j jResp.J = j j = j + 1 Wend j = 0 count_j = jResp.SizeOfArray("items[i].discountInfo") While j < count_j jResp.J = j value = jResp.IntOf("items[i].discountInfo[j].value") v_type = jResp.StringOf("items[i].discountInfo[j].type") base = jResp.StringOf("items[i].discountInfo[j].base") orderTotal = jResp.IntOf("items[i].discountInfo[j].orderTotal") j = j + 1 Wend j = 0 count_j = jResp.SizeOfArray("items[i].items") While j < count_j jResp.J = j id_int = jResp.IntOf("items[i].items[j].id") productId = jResp.IntOf("items[i].items[j].productId") categoryId = jResp.IntOf("items[i].items[j].categoryId") price = jResp.IntOf("items[i].items[j].price") productPrice = jResp.IntOf("items[i].items[j].productPrice") sku = jResp.StringOf("items[i].items[j].sku") quantity = jResp.IntOf("items[i].items[j].quantity") shortDescription = jResp.StringOf("items[i].items[j].shortDescription") tax = jResp.StringOf("items[i].items[j].tax") shipping = jResp.IntOf("items[i].items[j].shipping") quantityInStock = jResp.IntOf("items[i].items[j].quantityInStock") name = jResp.StringOf("items[i].items[j].name") isShippingRequired = jResp.BoolOf("items[i].items[j].isShippingRequired") weight = jResp.IntOf("items[i].items[j].weight") trackQuantity = jResp.BoolOf("items[i].items[j].trackQuantity") fixedShippingRateOnly = jResp.BoolOf("items[i].items[j].fixedShippingRateOnly") imageUrl = jResp.StringOf("items[i].items[j].imageUrl") smallThumbnailUrl = jResp.StringOf("items[i].items[j].smallThumbnailUrl") hdThumbnailUrl = jResp.StringOf("items[i].items[j].hdThumbnailUrl") fixedShippingRate = jResp.IntOf("items[i].items[j].fixedShippingRate") digital = jResp.BoolOf("items[i].items[j].digital") couponApplied = jResp.BoolOf("items[i].items[j].couponApplied") dimensionsLength = jResp.IntOf("items[i].items[j].dimensions.length") dimensionsWidth = jResp.IntOf("items[i].items[j].dimensions.width") dimensionsHeight = jResp.IntOf("items[i].items[j].dimensions.height") couponAmount = jResp.StringOf("items[i].items[j].couponAmount") subscriptionId = jResp.IntOf("items[i].items[j].subscriptionId") recurringChargeSettingsRecurringInterval = jResp.StringOf("items[i].items[j].recurringChargeSettings.recurringInterval") recurringChargeSettingsRecurringIntervalCount = jResp.IntOf("items[i].items[j].recurringChargeSettings.recurringIntervalCount") k = 0 count_k = jResp.SizeOfArray("items[i].items[j].selectedOptions") While k < count_k jResp.K = k name = jResp.StringOf("items[i].items[j].selectedOptions[k].name") value_str = jResp.StringOf("items[i].items[j].selectedOptions[k].value") v_type = jResp.StringOf("items[i].items[j].selectedOptions[k].type") json1 = jResp.ObjectOf("items[i].items[j].selectedOptions[k]") i1 = 0 count_i1 = json1.SizeOfArray("valuesArray") While i1 < count_i1 json1.I = i1 strVal = json1.StringOf("valuesArray[i]") i1 = i1 + 1 Wend json1 = jResp.ObjectOf("items[i].items[j].selectedOptions[k]") i1 = 0 count_i1 = json1.SizeOfArray("selections") While i1 < count_i1 json1.I = i1 selectionTitle = json1.StringOf("selections[i].selectionTitle") selectionModifier = json1.IntOf("selections[i].selectionModifier") selectionModifierType = json1.StringOf("selections[i].selectionModifierType") i1 = i1 + 1 Wend k = k + 1 Wend k = 0 count_k = jResp.SizeOfArray("items[i].items[j].taxes") While k < count_k jResp.K = k name = jResp.StringOf("items[i].items[j].taxes[k].name") value = jResp.IntOf("items[i].items[j].taxes[k].value") total_str = jResp.StringOf("items[i].items[j].taxes[k].total") taxOnDiscountedSubtotal = jResp.StringOf("items[i].items[j].taxes[k].taxOnDiscountedSubtotal") taxOnShipping = jResp.IntOf("items[i].items[j].taxes[k].taxOnShipping") includeInPrice = jResp.BoolOf("items[i].items[j].taxes[k].includeInPrice") k = k + 1 Wend k = 0 count_k = jResp.SizeOfArray("items[i].items[j].discounts") While k < count_k jResp.K = k discountInfoValue = jResp.IntOf("items[i].items[j].discounts[k].discountInfo.value") discountInfoType = jResp.StringOf("items[i].items[j].discounts[k].discountInfo.type") discountInfoBase = jResp.StringOf("items[i].items[j].discounts[k].discountInfo.base") discountInfoOrderTotal = jResp.IntOf("items[i].items[j].discounts[k].discountInfo.orderTotal") total_str = jResp.StringOf("items[i].items[j].discounts[k].total") k = k + 1 Wend j = j + 1 Wend j = 0 count_j = jResp.SizeOfArray("items[i].refunds") While j < count_j jResp.J = j date = jResp.StringOf("items[i].refunds[j].date") source = jResp.StringOf("items[i].refunds[j].source") reason = jResp.StringOf("items[i].refunds[j].reason") amount = jResp.StringOf("items[i].refunds[j].amount") j = j + 1 Wend j = 0 count_j = jResp.SizeOfArray("items[i].predictedPackage") While j < count_j jResp.J = j length = jResp.IntOf("items[i].predictedPackage[j].length") width = jResp.IntOf("items[i].predictedPackage[j].width") height = jResp.IntOf("items[i].predictedPackage[j].height") weight_str = jResp.StringOf("items[i].predictedPackage[j].weight") declaredValue = jResp.StringOf("items[i].predictedPackage[j].declaredValue") j = j + 1 Wend j = 0 count_j = jResp.SizeOfArray("items[i].shipments") While j < count_j jResp.J = j id = jResp.StringOf("items[i].shipments[j].id") created = jResp.StringOf("items[i].shipments[j].created") shipToName = jResp.StringOf("items[i].shipments[j].shipTo.name") shipToCompanyName = jResp.StringOf("items[i].shipments[j].shipTo.companyName") shipToStreet = jResp.StringOf("items[i].shipments[j].shipTo.street") shipToCity = jResp.StringOf("items[i].shipments[j].shipTo.city") shipToCountryCode = jResp.StringOf("items[i].shipments[j].shipTo.countryCode") shipToCountryName = jResp.StringOf("items[i].shipments[j].shipTo.countryName") shipToPostalCode = jResp.StringOf("items[i].shipments[j].shipTo.postalCode") shipToStateOrProvinceCode = jResp.StringOf("items[i].shipments[j].shipTo.stateOrProvinceCode") shipToStateOrProvinceName = jResp.StringOf("items[i].shipments[j].shipTo.stateOrProvinceName") shipToPhone = jResp.StringOf("items[i].shipments[j].shipTo.phone") shipFromCompanyName = jResp.StringOf("items[i].shipments[j].shipFrom.companyName") shipFromStreet = jResp.StringOf("items[i].shipments[j].shipFrom.street") shipFromCity = jResp.StringOf("items[i].shipments[j].shipFrom.city") shipFromCountryCode = jResp.StringOf("items[i].shipments[j].shipFrom.countryCode") shipFromCountryName = jResp.StringOf("items[i].shipments[j].shipFrom.countryName") shipFromPostalCode = jResp.StringOf("items[i].shipments[j].shipFrom.postalCode") shipFromStateOrProvinceCode = jResp.StringOf("items[i].shipments[j].shipFrom.stateOrProvinceCode") shipFromStateOrProvinceName = jResp.StringOf("items[i].shipments[j].shipFrom.stateOrProvinceName") shipFromPhone = jResp.StringOf("items[i].shipments[j].shipFrom.phone") parcelWeight = jResp.StringOf("items[i].shipments[j].parcel.weight") parcelWeightUnit = jResp.IntOf("items[i].shipments[j].parcel.weightUnit") parcelWidth = jResp.IntOf("items[i].shipments[j].parcel.width") parcelHeight = jResp.IntOf("items[i].shipments[j].parcel.height") parcelLength = jResp.IntOf("items[i].shipments[j].parcel.length") parcelDimensionUnit = jResp.IntOf("items[i].shipments[j].parcel.dimensionUnit") shippingServiceCarrier = jResp.IntOf("items[i].shipments[j].shippingService.carrier") shippingServiceCarrierName = jResp.IntOf("items[i].shipments[j].shippingService.carrierName") shippingServiceCarrierServiceName = jResp.StringOf("items[i].shipments[j].shippingService.carrierServiceName") shippingServiceCarrierServiceCode = jResp.StringOf("items[i].shipments[j].shippingService.carrierServiceCode") trackingTracking_number = jResp.StringOf("items[i].shipments[j].tracking.tracking_number") trackingTracking_url = jResp.StringOf("items[i].shipments[j].tracking.tracking_url") trackingEstimatedDays = jResp.IntOf("items[i].shipments[j].tracking.estimatedDays") shippingLabelLabel_url = jResp.StringOf("items[i].shipments[j].shippingLabel.label_url") shippingLabelCommercial_invoice_url = jResp.StringOf("items[i].shipments[j].shippingLabel.commercial_invoice_url") j = j + 1 Wend j = 0 count_j = jResp.SizeOfArray("items[i].taxesOnShipping") While j < count_j jResp.J = j name = jResp.StringOf("items[i].taxesOnShipping[j].name") value = jResp.IntOf("items[i].taxesOnShipping[j].value") total_str = jResp.StringOf("items[i].taxesOnShipping[j].total") j = j + 1 Wend j = 0 count_j = jResp.SizeOfArray("items[i].orderExtraFields") While j < count_j jResp.J = j id = jResp.StringOf("items[i].orderExtraFields[j].id") value_str = jResp.StringOf("items[i].orderExtraFields[j].value") customerInputType = jResp.StringOf("items[i].orderExtraFields[j].customerInputType") title = jResp.StringOf("items[i].orderExtraFields[j].title") orderDetailsDisplaySection = jResp.StringOf("items[i].orderExtraFields[j].orderDetailsDisplaySection") orderBy = jResp.StringOf("items[i].orderExtraFields[j].orderBy") j = j + 1 Wend i = i + 1 Wend |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.