|
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
(PowerShell) 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
Add-Type -Path "C:\chilkat\ChilkatDotNet47-9.5.0-x64\ChilkatDotNet47.dll" # This example assumes the Chilkat API to have been previously unlocked. # See Global Unlock Sample for sample code. $http = New-Object 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 $jsonToken = New-Object Chilkat.JsonObject $jsonToken.LoadFile("qa_data/tokens/ecwid.json") $http.SetRequestHeader("Accept","application/json") $params = New-Object Chilkat.JsonObject $params.UpdateInt("limit",100) $params.UpdateString("email","joe@example.com") $params.UpdateString("token",$jsonToken.StringOf("access_token")) $resp = $http.QuickRequestParams("GET","https://app.ecwid.com/api/v3/storeId/orders",$params) if ($http.LastMethodSuccess -eq $false) { $($http.LastErrorText) exit } $sbResponseBody = New-Object Chilkat.StringBuilder $resp.GetBodySb($sbResponseBody) $jResp = New-Object Chilkat.JsonObject $jResp.LoadSb($sbResponseBody) $jResp.EmitCompact = $false $("Response Body:") $($jResp.Emit()) $respStatusCode = $resp.StatusCode $("Response Status Code = " + $respStatusCode) if ($respStatusCode -ne 200) { $("Failed.") exit } # 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") while ($i -lt $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 -lt $count_j) { $jResp.J = $j $j = $j + 1 } $j = 0 $count_j = $jResp.SizeOfArray("items[i].discountInfo") while ($j -lt $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 } $j = 0 $count_j = $jResp.SizeOfArray("items[i].items") while ($j -lt $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 -lt $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 -lt $count_i1) { $json1.I = $i1 $strVal = $json1.StringOf("valuesArray[i]") $i1 = $i1 + 1 } $json1 = $jResp.ObjectOf("items[i].items[j].selectedOptions[k]") $i1 = 0 $count_i1 = $json1.SizeOfArray("selections") while ($i1 -lt $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 } $k = $k + 1 } $k = 0 $count_k = $jResp.SizeOfArray("items[i].items[j].taxes") while ($k -lt $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 } $k = 0 $count_k = $jResp.SizeOfArray("items[i].items[j].discounts") while ($k -lt $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 } $j = $j + 1 } $j = 0 $count_j = $jResp.SizeOfArray("items[i].refunds") while ($j -lt $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 } $j = 0 $count_j = $jResp.SizeOfArray("items[i].predictedPackage") while ($j -lt $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 } $j = 0 $count_j = $jResp.SizeOfArray("items[i].shipments") while ($j -lt $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 } $j = 0 $count_j = $jResp.SizeOfArray("items[i].taxesOnShipping") while ($j -lt $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 } $j = 0 $count_j = $jResp.SizeOfArray("items[i].orderExtraFields") while ($j -lt $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 } $i = $i + 1 } |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.