Chilkat Examples

ChilkatHOME.NET Core C#Android™AutoItCC#C++Chilkat2-PythonCkPythonClassic ASPDataFlexDelphi ActiveXDelphi DLLGoJavaLianjaMono C#Node.jsObjective-CPHP ActiveXPHP ExtensionPerlPowerBuilderPowerShellPureBasicRubySQL ServerSwift 2Swift 3,4,5...TclUnicode CUnicode C++VB.NETVBScriptVisual Basic 6.0Visual FoxProXojo Plugin

CkPython Web API Examples

Primary Categories

ABN AMRO
AWS Secrets Manager
AWS Security Token Service
AWS Translate
Activix CRM
Adyen
Alibaba Cloud OSS
Amazon Cognito
Amazon DynamoDB
Amazon MWS
Amazon Pay
Amazon Rekognition
Amazon SP-API
Amazon Voice ID
Aruba Fatturazione
Azure Maps
Azure Monitor
Azure OAuth2
Azure Storage Accounts
Backblaze S3
Banco Inter
Belgian eHealth Platform
Bitfinex v2 REST
Bluzone
BrickLink
Bunny CDN
CallRail
CardConnect
Cerved
ClickBank
Clickatell
Cloudfare
Constant Contact
DocuSign
Duo Auth MFA
ETrade
Ecwid
Egypt ITIDA
Egypt eReceipt
Etsy
Facebook
Faire
Frame.io
GeoOp
GetHarvest
Global Payments
Google People
Google Search Console
Google Translate
Hungary NAV Invoicing
IBM Text to Speech
Ibanity
IntakeQ
Jira
Lightspeed
MYOB
Magento
Mailgun
Mastercard

MedTunnel
MercadoLibre
MessageMedia
Microsoft Calendar
Microsoft Group
Microsoft Tasks and Plans
Microsoft Teams
Moody's
Okta OAuth/OIDC
OneLogin OIDC
OneNote
OpenAI ChatGPT
PRODA
PayPal
Paynow.pl
Peoplevox
Populi
QuickBooks
Rabobank
Refinitiv
Royal Mail OBA
SCiS Schools Catalogue
SII Chile
SMSAPI
SOAP finkok.com
SendGrid
Shippo
Shopify
Shopware
Shopware 6
SimpleTexting
Square
Stripe
SugarCRM
TicketBAI
Trello
Twilio
Twitter API v2
Twitter v1
UPS
UniPin
VoiceBase
Vonage
WaTrend
Walmart v3
Wasabi
WhatsApp
WiX
WooCommerce
WordPress
Xero
Yahoo Mail
Yapily
Yousign
ZATCA
Zendesk
Zoom
_Miscellaneous_
eBay
effectconnect
hacienda.go.cr

 

 

 

(CkPython) Ecwid - Search Orders

See more Ecwid Examples

Search 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

Chilkat Python Downloads

Python Module for Windows, MacOS, Linux, Alpine Linux, Solaris

import sys
import chilkat

# This example assumes the Chilkat API to have been previously unlocked.
# See Global Unlock Sample for sample code.

http = chilkat.CkHttp()

# 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 = chilkat.CkJsonObject()
jsonToken.LoadFile("qa_data/tokens/ecwid.json")

http.SetRequestHeader("Accept","application/json")

params = chilkat.CkJsonObject()
params.UpdateInt("limit",100)
params.UpdateString("email","joe@example.com")
params.UpdateString("token",jsonToken.stringOf("access_token"))

# resp is a CkHttpResponse
resp = http.QuickRequestParams("GET","https://app.ecwid.com/api/v3/storeId/orders",params)
if (http.get_LastMethodSuccess() == False):
    print(http.lastErrorText())
    sys.exit()

sbResponseBody = chilkat.CkStringBuilder()
resp.GetBodySb(sbResponseBody)
jResp = chilkat.CkJsonObject()
jResp.LoadSb(sbResponseBody)
jResp.put_EmitCompact(False)

print("Response Body:")
print(jResp.emit())

respStatusCode = resp.get_StatusCode()

print("Response Status Code = " + str(respStatusCode))
if (respStatusCode != 200):
    print("Failed.")
    sys.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 < count_i :
    jResp.put_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.put_J(j)
        j = j + 1

    j = 0
    count_j = jResp.SizeOfArray("items[i].discountInfo")
    while j < count_j :
        jResp.put_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 < count_j :
        jResp.put_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.put_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 CkJsonObject
            json1 = jResp.ObjectOf("items[i].items[j].selectedOptions[k]")
            i1 = 0
            count_i1 = json1.SizeOfArray("valuesArray")
            while i1 < count_i1 :
                json1.put_I(i1)
                strVal = json1.stringOf("valuesArray[i]")
                i1 = i1 + 1

            # json1 is a CkJsonObject
            json1 = jResp.ObjectOf("items[i].items[j].selectedOptions[k]")
            i1 = 0
            count_i1 = json1.SizeOfArray("selections")
            while i1 < count_i1 :
                json1.put_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 < count_k :
            jResp.put_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 < count_k :
            jResp.put_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 < count_j :
        jResp.put_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 < count_j :
        jResp.put_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 < count_j :
        jResp.put_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 < count_j :
        jResp.put_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 < count_j :
        jResp.put_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.