VBScript
VBScript
Ecwid - Search Orders
See more Ecwid Examples
Search or filter orders in an Ecwid store. The response provides full details of the found orders.Chilkat VBScript Downloads
Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)
success = 0
' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
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
set jsonToken = CreateObject("Chilkat.JsonObject")
success = jsonToken.LoadFile("qa_data/tokens/ecwid.json")
http.SetRequestHeader "Accept","application/json"
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"))
set resp = CreateObject("Chilkat.HttpResponse")
success = http.HttpParams("GET","https://app.ecwid.com/api/v3/storeId/orders",params,resp)
If (success = 0) Then
outFile.WriteLine(http.LastErrorText)
WScript.Quit
End If
set sbResponseBody = CreateObject("Chilkat.StringBuilder")
success = resp.GetBodySb(sbResponseBody)
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
set json1 = CreateObject("Chilkat.JsonObject")
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")
success = jResp.ObjectOf2("items[i].items[j].selectedOptions[k]",json1)
i1 = 0
count_i1 = json1.SizeOfArray("valuesArray")
Do While i1 < count_i1
json1.I = i1
strVal = json1.StringOf("valuesArray[i]")
i1 = i1 + 1
Loop
success = jResp.ObjectOf2("items[i].items[j].selectedOptions[k]",json1)
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