|
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
(VB.NET) 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 jsonToken.LoadFile("qa_data/tokens/ecwid.json") http.SetRequestHeader("Accept","application/json") Dim params As New Chilkat.JsonObject params.UpdateInt("limit",100) params.UpdateString("email","joe@example.com") params.UpdateString("token",jsonToken.StringOf("access_token")) Dim resp As Chilkat.HttpResponse = http.QuickRequestParams("GET","https://app.ecwid.com/api/v3/storeId/orders",params) If (http.LastMethodSuccess = False) Then Debug.WriteLine(http.LastErrorText) Exit Sub End If Dim sbResponseBody As New Chilkat.StringBuilder resp.GetBodySb(sbResponseBody) Dim jResp As New Chilkat.JsonObject jResp.LoadSb(sbResponseBody) jResp.EmitCompact = False Debug.WriteLine("Response Body:") Debug.WriteLine(jResp.Emit()) Dim respStatusCode As Integer = resp.StatusCode Debug.WriteLine("Response Status Code = " & respStatusCode) If (respStatusCode <> 200) Then Debug.WriteLine("Failed.") Exit Sub 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 Integer Dim refererUrl As String Dim globalReferer As String Dim createDate As String Dim updateDate As String Dim createTimestamp As Integer Dim updateTimestamp As Integer Dim hidden As Boolean Dim orderComments As String Dim privateAdminNotes As String Dim email As String Dim ipAddress As String Dim customerId As Integer Dim customerGroupId As Integer Dim customerGroup As String Dim customerTaxExempt As Boolean Dim customerTaxId As String Dim customerTaxIdValid As Boolean Dim reversedTaxApplied As Boolean Dim discount As Integer Dim couponDiscount As Integer Dim volumeDiscount As Integer Dim membershipBasedDiscount As Integer Dim totalAndMembershipBasedDiscount As Integer Dim discountCouponId As Integer Dim discountCouponName As String Dim discountCouponCode As String Dim discountCouponDiscountType As String Dim discountCouponStatus As String Dim discountCouponDiscount As Integer Dim discountCouponLaunchDate As String Dim discountCouponUsesLimit As String Dim discountCouponApplicationLimit As String Dim discountCouponCreationDate As String Dim discountCouponUpdateDate As String Dim discountCouponOrderCount As Integer 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 Integer 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 Integer Dim count_j As Integer Dim value As Integer Dim v_type As String Dim base As String Dim orderTotal As Integer Dim id_int As Integer Dim productId As Integer Dim categoryId As Integer Dim price As Integer Dim productPrice As Integer Dim sku As String Dim quantity As Integer Dim shortDescription As String Dim shipping As Integer Dim quantityInStock As Integer Dim name As String Dim isShippingRequired As Boolean Dim weight As Integer Dim trackQuantity As Boolean Dim fixedShippingRateOnly As Boolean Dim imageUrl As String Dim smallThumbnailUrl As String Dim hdThumbnailUrl As String Dim fixedShippingRate As Integer Dim digital As Boolean Dim couponApplied As Boolean Dim dimensionsLength As Integer Dim dimensionsWidth As Integer Dim dimensionsHeight As Integer Dim couponAmount As String Dim subscriptionId As Integer Dim recurringChargeSettingsRecurringInterval As String Dim recurringChargeSettingsRecurringIntervalCount As Integer Dim k As Integer Dim count_k As Integer Dim value_str As String Dim json1 As Chilkat.JsonObject Dim i1 As Integer Dim count_i1 As Integer Dim strVal As String Dim selectionTitle As String Dim selectionModifier As Integer Dim selectionModifierType As String Dim taxOnDiscountedSubtotal As String Dim taxOnShipping As Integer Dim includeInPrice As Boolean Dim discountInfoValue As Integer Dim discountInfoType As String Dim discountInfoBase As String Dim discountInfoOrderTotal As Integer Dim date As String Dim source As String Dim reason As String Dim amount As String Dim length As Integer Dim width As Integer Dim height As Integer 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 Integer Dim parcelWidth As Integer Dim parcelHeight As Integer Dim parcelLength As Integer Dim parcelDimensionUnit As Integer Dim shippingServiceCarrier As Integer Dim shippingServiceCarrierName As Integer Dim shippingServiceCarrierServiceName As String Dim shippingServiceCarrierServiceCode As String Dim trackingTracking_number As String Dim trackingTracking_url As String Dim trackingEstimatedDays As Integer 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 Integer = jResp.IntOf("total") Dim count As Integer = jResp.IntOf("count") Dim offset As Integer = jResp.IntOf("offset") Dim limit As Integer = jResp.IntOf("limit") Dim i As Integer = 0 Dim count_i As Integer = 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 End While 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 End While 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 End While 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 End While k = k + 1 End While 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 End While 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 End While j = j + 1 End While 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 End While 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 End While 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 End While 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 End While 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 End While i = i + 1 End While |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.