|
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
(VBScript) 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
Dim fso, outFile Set fso = CreateObject("Scripting.FileSystemObject") 'Create a Unicode (utf-16) output text file. Set outFile = fso.CreateTextFile("output.txt", True, True) ' This example assumes the Chilkat API to have been previously unlocked. ' See Global Unlock Sample for sample code. ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http") set http = CreateObject("Chilkat.Http") ' Implements the following CURL command: ' curl --request GET \ ' --url 'https://app.ecwid.com/api/v3/storeId/orders?token=token' \ ' --header 'Accept: application/json' ' Use the following online tool to generate HTTP code from a CURL command ' Convert a cURL Command to HTTP Source Code ' Load the access token previously obtained in Ecwid Get Access Token ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject") set jsonToken = CreateObject("Chilkat.JsonObject") success = jsonToken.LoadFile("qa_data/tokens/ecwid.json") http.SetRequestHeader "Accept","application/json" ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject") set params = CreateObject("Chilkat.JsonObject") success = params.UpdateInt("limit",100) success = params.UpdateString("email","joe@example.com") success = params.UpdateString("token",jsonToken.StringOf("access_token")) ' resp is a Chilkat.HttpResponse Set resp = http.QuickRequestParams("GET","https://app.ecwid.com/api/v3/storeId/orders",params) If (http.LastMethodSuccess = 0) Then outFile.WriteLine(http.LastErrorText) WScript.Quit End If ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder") set sbResponseBody = CreateObject("Chilkat.StringBuilder") success = resp.GetBodySb(sbResponseBody) ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject") set jResp = CreateObject("Chilkat.JsonObject") success = jResp.LoadSb(sbResponseBody) jResp.EmitCompact = 0 outFile.WriteLine("Response Body:") outFile.WriteLine(jResp.Emit()) respStatusCode = resp.StatusCode outFile.WriteLine("Response Status Code = " & respStatusCode) If (respStatusCode <> 200) Then outFile.WriteLine("Failed.") WScript.Quit 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 total = jResp.IntOf("total") count = jResp.IntOf("count") offset = jResp.IntOf("offset") limit = jResp.IntOf("limit") i = 0 count_i = jResp.SizeOfArray("items") Do 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") Do While j < count_j jResp.J = j j = j + 1 Loop j = 0 count_j = jResp.SizeOfArray("items[i].discountInfo") Do 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 Loop j = 0 count_j = jResp.SizeOfArray("items[i].items") Do 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") Do 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 is a Chilkat.JsonObject Set json1 = jResp.ObjectOf("items[i].items[j].selectedOptions[k]") i1 = 0 count_i1 = json1.SizeOfArray("valuesArray") Do While i1 < count_i1 json1.I = i1 strVal = json1.StringOf("valuesArray[i]") i1 = i1 + 1 Loop ' json1 is a Chilkat.JsonObject Set json1 = jResp.ObjectOf("items[i].items[j].selectedOptions[k]") i1 = 0 count_i1 = json1.SizeOfArray("selections") Do 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 Loop k = k + 1 Loop k = 0 count_k = jResp.SizeOfArray("items[i].items[j].taxes") Do 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 Loop k = 0 count_k = jResp.SizeOfArray("items[i].items[j].discounts") Do 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 Loop j = j + 1 Loop j = 0 count_j = jResp.SizeOfArray("items[i].refunds") Do 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 Loop j = 0 count_j = jResp.SizeOfArray("items[i].predictedPackage") Do 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 Loop j = 0 count_j = jResp.SizeOfArray("items[i].shipments") Do 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 Loop j = 0 count_j = jResp.SizeOfArray("items[i].taxesOnShipping") Do 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 Loop j = 0 count_j = jResp.SizeOfArray("items[i].orderExtraFields") Do 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 Loop i = i + 1 Loop outFile.Close |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.