Sample code for 30+ languages & platforms
PureBasic Requires Chilkat v11.0.0+

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 PureBasic Downloads

PureBasic
IncludeFile "CkHttpResponse.pb"
IncludeFile "CkHttp.pb"
IncludeFile "CkStringBuilder.pb"
IncludeFile "CkJsonObject.pb"

Procedure ChilkatExample()

    success.i = 0

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

    http.i = CkHttp::ckCreate()
    If http.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    ;  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.i = CkJsonObject::ckCreate()
    If jsonToken.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    CkJsonObject::ckLoadFile(jsonToken,"qa_data/tokens/ecwid.json")

    CkHttp::ckSetRequestHeader(http,"Accept","application/json")

    params.i = CkJsonObject::ckCreate()
    If params.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    CkJsonObject::ckUpdateInt(params,"limit",100)
    CkJsonObject::ckUpdateString(params,"email","joe@example.com")
    CkJsonObject::ckUpdateString(params,"token",CkJsonObject::ckStringOf(jsonToken,"access_token"))

    resp.i = CkHttpResponse::ckCreate()
    If resp.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    success = CkHttp::ckHttpParams(http,"GET","https://app.ecwid.com/api/v3/storeId/orders",params,resp)
    If success = 0
        Debug CkHttp::ckLastErrorText(http)
        CkHttp::ckDispose(http)
        CkJsonObject::ckDispose(jsonToken)
        CkJsonObject::ckDispose(params)
        CkHttpResponse::ckDispose(resp)
        ProcedureReturn
    EndIf

    sbResponseBody.i = CkStringBuilder::ckCreate()
    If sbResponseBody.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    CkHttpResponse::ckGetBodySb(resp,sbResponseBody)
    jResp.i = CkJsonObject::ckCreate()
    If jResp.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    CkJsonObject::ckLoadSb(jResp,sbResponseBody)
    CkJsonObject::setCkEmitCompact(jResp, 0)

    Debug "Response Body:"
    Debug CkJsonObject::ckEmit(jResp)

    respStatusCode.i = CkHttpResponse::ckStatusCode(resp)

    Debug "Response Status Code = " + Str(respStatusCode)
    If respStatusCode <> 200
        Debug "Failed."
        CkHttp::ckDispose(http)
        CkJsonObject::ckDispose(jsonToken)
        CkJsonObject::ckDispose(params)
        CkHttpResponse::ckDispose(resp)
        CkStringBuilder::ckDispose(sbResponseBody)
        CkJsonObject::ckDispose(jResp)
        ProcedureReturn
    EndIf

    ;  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

    id.s
    subtotal.s
    total_str.s
    giftCardRedemption.s
    totalBeforeGiftCardRedemption.s
    giftCardDoubleSpending.i
    usdTotal.s
    tax.s
    paymentMethod.s
    paymentStatus.s
    fulfillmentStatus.s
    vendorOrderNumber.s
    orderNumber.i
    refererUrl.s
    globalReferer.s
    createDate.s
    updateDate.s
    createTimestamp.i
    updateTimestamp.i
    hidden.i
    orderComments.s
    privateAdminNotes.s
    email.s
    ipAddress.s
    customerId.i
    customerGroupId.i
    customerGroup.s
    customerTaxExempt.i
    customerTaxId.s
    customerTaxIdValid.i
    reversedTaxApplied.i
    discount.i
    couponDiscount.i
    volumeDiscount.i
    membershipBasedDiscount.i
    totalAndMembershipBasedDiscount.i
    discountCouponId.i
    discountCouponName.s
    discountCouponCode.s
    discountCouponDiscountType.s
    discountCouponStatus.s
    discountCouponDiscount.i
    discountCouponLaunchDate.s
    discountCouponUsesLimit.s
    discountCouponApplicationLimit.s
    discountCouponCreationDate.s
    discountCouponUpdateDate.s
    discountCouponOrderCount.i
    refundedAmount.s
    billingPersonName.s
    billingPersonCompanyName.s
    billingPersonStreet.s
    billingPersonCity.s
    billingPersonCountryCode.s
    billingPersonCountryName.s
    billingPersonPostalCode.s
    billingPersonStateOrProvinceCode.s
    billingPersonStateOrProvinceName.s
    billingPersonPhone.s
    shippingPersonName.s
    shippingPersonCompanyName.s
    shippingPersonStreet.s
    shippingPersonCity.s
    shippingPersonCountryCode.s
    shippingPersonCountryName.s
    shippingPersonPostalCode.s
    shippingPersonStateOrProvinceCode.s
    shippingPersonStateOrProvinceName.s
    shippingPersonPhone.s
    shippingOptionShippingCarrierName.s
    shippingOptionShippingMethodName.s
    shippingOptionShippingRate.s
    shippingOptionEstimatedTransitTime.s
    shippingOptionIsPickup.i
    handlingFeeName.s
    handlingFeeValue.i
    handlingFeeDescription.s
    paymentModule.s
    additionalInfoGoogle_customer_id.s
    acceptMarketing.i
    refererId.s
    disableAllCustomerNotifications.i
    externalFulfillment.i
    pricesIncludeTax.i
    j.i
    count_j.i
    value.i
    v_type.s
    base.s
    orderTotal.i
    id_int.i
    productId.i
    categoryId.i
    price.i
    productPrice.i
    sku.s
    quantity.i
    shortDescription.s
    shipping.i
    quantityInStock.i
    name.s
    isShippingRequired.i
    weight.i
    trackQuantity.i
    fixedShippingRateOnly.i
    imageUrl.s
    smallThumbnailUrl.s
    hdThumbnailUrl.s
    fixedShippingRate.i
    digital.i
    couponApplied.i
    dimensionsLength.i
    dimensionsWidth.i
    dimensionsHeight.i
    couponAmount.s
    subscriptionId.i
    recurringChargeSettingsRecurringInterval.s
    recurringChargeSettingsRecurringIntervalCount.i
    k.i
    count_k.i
    value_str.s
    json1.i = CkJsonObject::ckCreate()
    If json1.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    i1.i
    count_i1.i
    strVal.s
    selectionTitle.s
    selectionModifier.i
    selectionModifierType.s
    taxOnDiscountedSubtotal.s
    taxOnShipping.i
    includeInPrice.i
    discountInfoValue.i
    discountInfoType.s
    discountInfoBase.s
    discountInfoOrderTotal.i
    date.s
    source.s
    reason.s
    amount.s
    length.i
    width.i
    height.i
    weight_str.s
    declaredValue.s
    created.s
    shipToName.s
    shipToCompanyName.s
    shipToStreet.s
    shipToCity.s
    shipToCountryCode.s
    shipToCountryName.s
    shipToPostalCode.s
    shipToStateOrProvinceCode.s
    shipToStateOrProvinceName.s
    shipToPhone.s
    shipFromCompanyName.s
    shipFromStreet.s
    shipFromCity.s
    shipFromCountryCode.s
    shipFromCountryName.s
    shipFromPostalCode.s
    shipFromStateOrProvinceCode.s
    shipFromStateOrProvinceName.s
    shipFromPhone.s
    parcelWeight.s
    parcelWeightUnit.i
    parcelWidth.i
    parcelHeight.i
    parcelLength.i
    parcelDimensionUnit.i
    shippingServiceCarrier.i
    shippingServiceCarrierName.i
    shippingServiceCarrierServiceName.s
    shippingServiceCarrierServiceCode.s
    trackingTracking_number.s
    trackingTracking_url.s
    trackingEstimatedDays.i
    shippingLabelLabel_url.s
    shippingLabelCommercial_invoice_url.s
    customerInputType.s
    title.s
    orderDetailsDisplaySection.s
    orderBy.s

    total.i = CkJsonObject::ckIntOf(jResp,"total")
    count.i = CkJsonObject::ckIntOf(jResp,"count")
    offset.i = CkJsonObject::ckIntOf(jResp,"offset")
    limit.i = CkJsonObject::ckIntOf(jResp,"limit")
    i.i = 0
    count_i.i = CkJsonObject::ckSizeOfArray(jResp,"items")
    While i < count_i
        CkJsonObject::setCkI(jResp, i)
        id = CkJsonObject::ckStringOf(jResp,"items[i].id")
        subtotal = CkJsonObject::ckStringOf(jResp,"items[i].subtotal")
        total_str = CkJsonObject::ckStringOf(jResp,"items[i].total")
        giftCardRedemption = CkJsonObject::ckStringOf(jResp,"items[i].giftCardRedemption")
        totalBeforeGiftCardRedemption = CkJsonObject::ckStringOf(jResp,"items[i].totalBeforeGiftCardRedemption")
        giftCardDoubleSpending = CkJsonObject::ckBoolOf(jResp,"items[i].giftCardDoubleSpending")
        usdTotal = CkJsonObject::ckStringOf(jResp,"items[i].usdTotal")
        tax = CkJsonObject::ckStringOf(jResp,"items[i].tax")
        paymentMethod = CkJsonObject::ckStringOf(jResp,"items[i].paymentMethod")
        paymentStatus = CkJsonObject::ckStringOf(jResp,"items[i].paymentStatus")
        fulfillmentStatus = CkJsonObject::ckStringOf(jResp,"items[i].fulfillmentStatus")
        vendorOrderNumber = CkJsonObject::ckStringOf(jResp,"items[i].vendorOrderNumber")
        orderNumber = CkJsonObject::ckIntOf(jResp,"items[i].orderNumber")
        refererUrl = CkJsonObject::ckStringOf(jResp,"items[i].refererUrl")
        globalReferer = CkJsonObject::ckStringOf(jResp,"items[i].globalReferer")
        createDate = CkJsonObject::ckStringOf(jResp,"items[i].createDate")
        updateDate = CkJsonObject::ckStringOf(jResp,"items[i].updateDate")
        createTimestamp = CkJsonObject::ckIntOf(jResp,"items[i].createTimestamp")
        updateTimestamp = CkJsonObject::ckIntOf(jResp,"items[i].updateTimestamp")
        hidden = CkJsonObject::ckBoolOf(jResp,"items[i].hidden")
        orderComments = CkJsonObject::ckStringOf(jResp,"items[i].orderComments")
        privateAdminNotes = CkJsonObject::ckStringOf(jResp,"items[i].privateAdminNotes")
        email = CkJsonObject::ckStringOf(jResp,"items[i].email")
        ipAddress = CkJsonObject::ckStringOf(jResp,"items[i].ipAddress")
        customerId = CkJsonObject::ckIntOf(jResp,"items[i].customerId")
        customerGroupId = CkJsonObject::ckIntOf(jResp,"items[i].customerGroupId")
        customerGroup = CkJsonObject::ckStringOf(jResp,"items[i].customerGroup")
        customerTaxExempt = CkJsonObject::ckBoolOf(jResp,"items[i].customerTaxExempt")
        customerTaxId = CkJsonObject::ckStringOf(jResp,"items[i].customerTaxId")
        customerTaxIdValid = CkJsonObject::ckBoolOf(jResp,"items[i].customerTaxIdValid")
        reversedTaxApplied = CkJsonObject::ckBoolOf(jResp,"items[i].reversedTaxApplied")
        discount = CkJsonObject::ckIntOf(jResp,"items[i].discount")
        couponDiscount = CkJsonObject::ckIntOf(jResp,"items[i].couponDiscount")
        volumeDiscount = CkJsonObject::ckIntOf(jResp,"items[i].volumeDiscount")
        membershipBasedDiscount = CkJsonObject::ckIntOf(jResp,"items[i].membershipBasedDiscount")
        totalAndMembershipBasedDiscount = CkJsonObject::ckIntOf(jResp,"items[i].totalAndMembershipBasedDiscount")
        discountCouponId = CkJsonObject::ckIntOf(jResp,"items[i].discountCoupon.id")
        discountCouponName = CkJsonObject::ckStringOf(jResp,"items[i].discountCoupon.name")
        discountCouponCode = CkJsonObject::ckStringOf(jResp,"items[i].discountCoupon.code")
        discountCouponDiscountType = CkJsonObject::ckStringOf(jResp,"items[i].discountCoupon.discountType")
        discountCouponStatus = CkJsonObject::ckStringOf(jResp,"items[i].discountCoupon.status")
        discountCouponDiscount = CkJsonObject::ckIntOf(jResp,"items[i].discountCoupon.discount")
        discountCouponLaunchDate = CkJsonObject::ckStringOf(jResp,"items[i].discountCoupon.launchDate")
        discountCouponUsesLimit = CkJsonObject::ckStringOf(jResp,"items[i].discountCoupon.usesLimit")
        discountCouponApplicationLimit = CkJsonObject::ckStringOf(jResp,"items[i].discountCoupon.applicationLimit")
        discountCouponCreationDate = CkJsonObject::ckStringOf(jResp,"items[i].discountCoupon.creationDate")
        discountCouponUpdateDate = CkJsonObject::ckStringOf(jResp,"items[i].discountCoupon.updateDate")
        discountCouponOrderCount = CkJsonObject::ckIntOf(jResp,"items[i].discountCoupon.orderCount")
        refundedAmount = CkJsonObject::ckStringOf(jResp,"items[i].refundedAmount")
        billingPersonName = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.name")
        billingPersonCompanyName = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.companyName")
        billingPersonStreet = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.street")
        billingPersonCity = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.city")
        billingPersonCountryCode = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.countryCode")
        billingPersonCountryName = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.countryName")
        billingPersonPostalCode = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.postalCode")
        billingPersonStateOrProvinceCode = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.stateOrProvinceCode")
        billingPersonStateOrProvinceName = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.stateOrProvinceName")
        billingPersonPhone = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.phone")
        shippingPersonName = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.name")
        shippingPersonCompanyName = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.companyName")
        shippingPersonStreet = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.street")
        shippingPersonCity = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.city")
        shippingPersonCountryCode = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.countryCode")
        shippingPersonCountryName = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.countryName")
        shippingPersonPostalCode = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.postalCode")
        shippingPersonStateOrProvinceCode = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.stateOrProvinceCode")
        shippingPersonStateOrProvinceName = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.stateOrProvinceName")
        shippingPersonPhone = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.phone")
        shippingOptionShippingCarrierName = CkJsonObject::ckStringOf(jResp,"items[i].shippingOption.shippingCarrierName")
        shippingOptionShippingMethodName = CkJsonObject::ckStringOf(jResp,"items[i].shippingOption.shippingMethodName")
        shippingOptionShippingRate = CkJsonObject::ckStringOf(jResp,"items[i].shippingOption.shippingRate")
        shippingOptionEstimatedTransitTime = CkJsonObject::ckStringOf(jResp,"items[i].shippingOption.estimatedTransitTime")
        shippingOptionIsPickup = CkJsonObject::ckBoolOf(jResp,"items[i].shippingOption.isPickup")
        handlingFeeName = CkJsonObject::ckStringOf(jResp,"items[i].handlingFee.name")
        handlingFeeValue = CkJsonObject::ckIntOf(jResp,"items[i].handlingFee.value")
        handlingFeeDescription = CkJsonObject::ckStringOf(jResp,"items[i].handlingFee.description")
        paymentModule = CkJsonObject::ckStringOf(jResp,"items[i].paymentModule")
        additionalInfoGoogle_customer_id = CkJsonObject::ckStringOf(jResp,"items[i].additionalInfo.google_customer_id")
        acceptMarketing = CkJsonObject::ckBoolOf(jResp,"items[i].acceptMarketing")
        refererId = CkJsonObject::ckStringOf(jResp,"items[i].refererId")
        disableAllCustomerNotifications = CkJsonObject::ckBoolOf(jResp,"items[i].disableAllCustomerNotifications")
        externalFulfillment = CkJsonObject::ckBoolOf(jResp,"items[i].externalFulfillment")
        pricesIncludeTax = CkJsonObject::ckBoolOf(jResp,"items[i].pricesIncludeTax")
        j = 0
        count_j = CkJsonObject::ckSizeOfArray(jResp,"items[i].customDiscount")
        While j < count_j
            CkJsonObject::setCkJ(jResp, j)
            j = j + 1
        Wend
        j = 0
        count_j = CkJsonObject::ckSizeOfArray(jResp,"items[i].discountInfo")
        While j < count_j
            CkJsonObject::setCkJ(jResp, j)
            value = CkJsonObject::ckIntOf(jResp,"items[i].discountInfo[j].value")
            v_type = CkJsonObject::ckStringOf(jResp,"items[i].discountInfo[j].type")
            base = CkJsonObject::ckStringOf(jResp,"items[i].discountInfo[j].base")
            orderTotal = CkJsonObject::ckIntOf(jResp,"items[i].discountInfo[j].orderTotal")
            j = j + 1
        Wend
        j = 0
        count_j = CkJsonObject::ckSizeOfArray(jResp,"items[i].items")
        While j < count_j
            CkJsonObject::setCkJ(jResp, j)
            id_int = CkJsonObject::ckIntOf(jResp,"items[i].items[j].id")
            productId = CkJsonObject::ckIntOf(jResp,"items[i].items[j].productId")
            categoryId = CkJsonObject::ckIntOf(jResp,"items[i].items[j].categoryId")
            price = CkJsonObject::ckIntOf(jResp,"items[i].items[j].price")
            productPrice = CkJsonObject::ckIntOf(jResp,"items[i].items[j].productPrice")
            sku = CkJsonObject::ckStringOf(jResp,"items[i].items[j].sku")
            quantity = CkJsonObject::ckIntOf(jResp,"items[i].items[j].quantity")
            shortDescription = CkJsonObject::ckStringOf(jResp,"items[i].items[j].shortDescription")
            tax = CkJsonObject::ckStringOf(jResp,"items[i].items[j].tax")
            shipping = CkJsonObject::ckIntOf(jResp,"items[i].items[j].shipping")
            quantityInStock = CkJsonObject::ckIntOf(jResp,"items[i].items[j].quantityInStock")
            name = CkJsonObject::ckStringOf(jResp,"items[i].items[j].name")
            isShippingRequired = CkJsonObject::ckBoolOf(jResp,"items[i].items[j].isShippingRequired")
            weight = CkJsonObject::ckIntOf(jResp,"items[i].items[j].weight")
            trackQuantity = CkJsonObject::ckBoolOf(jResp,"items[i].items[j].trackQuantity")
            fixedShippingRateOnly = CkJsonObject::ckBoolOf(jResp,"items[i].items[j].fixedShippingRateOnly")
            imageUrl = CkJsonObject::ckStringOf(jResp,"items[i].items[j].imageUrl")
            smallThumbnailUrl = CkJsonObject::ckStringOf(jResp,"items[i].items[j].smallThumbnailUrl")
            hdThumbnailUrl = CkJsonObject::ckStringOf(jResp,"items[i].items[j].hdThumbnailUrl")
            fixedShippingRate = CkJsonObject::ckIntOf(jResp,"items[i].items[j].fixedShippingRate")
            digital = CkJsonObject::ckBoolOf(jResp,"items[i].items[j].digital")
            couponApplied = CkJsonObject::ckBoolOf(jResp,"items[i].items[j].couponApplied")
            dimensionsLength = CkJsonObject::ckIntOf(jResp,"items[i].items[j].dimensions.length")
            dimensionsWidth = CkJsonObject::ckIntOf(jResp,"items[i].items[j].dimensions.width")
            dimensionsHeight = CkJsonObject::ckIntOf(jResp,"items[i].items[j].dimensions.height")
            couponAmount = CkJsonObject::ckStringOf(jResp,"items[i].items[j].couponAmount")
            subscriptionId = CkJsonObject::ckIntOf(jResp,"items[i].items[j].subscriptionId")
            recurringChargeSettingsRecurringInterval = CkJsonObject::ckStringOf(jResp,"items[i].items[j].recurringChargeSettings.recurringInterval")
            recurringChargeSettingsRecurringIntervalCount = CkJsonObject::ckIntOf(jResp,"items[i].items[j].recurringChargeSettings.recurringIntervalCount")
            k = 0
            count_k = CkJsonObject::ckSizeOfArray(jResp,"items[i].items[j].selectedOptions")
            While k < count_k
                CkJsonObject::setCkK(jResp, k)
                name = CkJsonObject::ckStringOf(jResp,"items[i].items[j].selectedOptions[k].name")
                value_str = CkJsonObject::ckStringOf(jResp,"items[i].items[j].selectedOptions[k].value")
                v_type = CkJsonObject::ckStringOf(jResp,"items[i].items[j].selectedOptions[k].type")
                CkJsonObject::ckObjectOf2(jResp,"items[i].items[j].selectedOptions[k]",json1)

                i1 = 0
                count_i1 = CkJsonObject::ckSizeOfArray(json1,"valuesArray")
                While i1 < count_i1
                    CkJsonObject::setCkI(json1, i1)
                    strVal = CkJsonObject::ckStringOf(json1,"valuesArray[i]")
                    i1 = i1 + 1
                Wend

                CkJsonObject::ckObjectOf2(jResp,"items[i].items[j].selectedOptions[k]",json1)
                i1 = 0
                count_i1 = CkJsonObject::ckSizeOfArray(json1,"selections")
                While i1 < count_i1
                    CkJsonObject::setCkI(json1, i1)
                    selectionTitle = CkJsonObject::ckStringOf(json1,"selections[i].selectionTitle")
                    selectionModifier = CkJsonObject::ckIntOf(json1,"selections[i].selectionModifier")
                    selectionModifierType = CkJsonObject::ckStringOf(json1,"selections[i].selectionModifierType")
                    i1 = i1 + 1
                Wend
                k = k + 1
            Wend
            k = 0
            count_k = CkJsonObject::ckSizeOfArray(jResp,"items[i].items[j].taxes")
            While k < count_k
                CkJsonObject::setCkK(jResp, k)
                name = CkJsonObject::ckStringOf(jResp,"items[i].items[j].taxes[k].name")
                value = CkJsonObject::ckIntOf(jResp,"items[i].items[j].taxes[k].value")
                total_str = CkJsonObject::ckStringOf(jResp,"items[i].items[j].taxes[k].total")
                taxOnDiscountedSubtotal = CkJsonObject::ckStringOf(jResp,"items[i].items[j].taxes[k].taxOnDiscountedSubtotal")
                taxOnShipping = CkJsonObject::ckIntOf(jResp,"items[i].items[j].taxes[k].taxOnShipping")
                includeInPrice = CkJsonObject::ckBoolOf(jResp,"items[i].items[j].taxes[k].includeInPrice")
                k = k + 1
            Wend
            k = 0
            count_k = CkJsonObject::ckSizeOfArray(jResp,"items[i].items[j].discounts")
            While k < count_k
                CkJsonObject::setCkK(jResp, k)
                discountInfoValue = CkJsonObject::ckIntOf(jResp,"items[i].items[j].discounts[k].discountInfo.value")
                discountInfoType = CkJsonObject::ckStringOf(jResp,"items[i].items[j].discounts[k].discountInfo.type")
                discountInfoBase = CkJsonObject::ckStringOf(jResp,"items[i].items[j].discounts[k].discountInfo.base")
                discountInfoOrderTotal = CkJsonObject::ckIntOf(jResp,"items[i].items[j].discounts[k].discountInfo.orderTotal")
                total_str = CkJsonObject::ckStringOf(jResp,"items[i].items[j].discounts[k].total")
                k = k + 1
            Wend
            j = j + 1
        Wend
        j = 0
        count_j = CkJsonObject::ckSizeOfArray(jResp,"items[i].refunds")
        While j < count_j
            CkJsonObject::setCkJ(jResp, j)
            date = CkJsonObject::ckStringOf(jResp,"items[i].refunds[j].date")
            source = CkJsonObject::ckStringOf(jResp,"items[i].refunds[j].source")
            reason = CkJsonObject::ckStringOf(jResp,"items[i].refunds[j].reason")
            amount = CkJsonObject::ckStringOf(jResp,"items[i].refunds[j].amount")
            j = j + 1
        Wend
        j = 0
        count_j = CkJsonObject::ckSizeOfArray(jResp,"items[i].predictedPackage")
        While j < count_j
            CkJsonObject::setCkJ(jResp, j)
            length = CkJsonObject::ckIntOf(jResp,"items[i].predictedPackage[j].length")
            width = CkJsonObject::ckIntOf(jResp,"items[i].predictedPackage[j].width")
            height = CkJsonObject::ckIntOf(jResp,"items[i].predictedPackage[j].height")
            weight_str = CkJsonObject::ckStringOf(jResp,"items[i].predictedPackage[j].weight")
            declaredValue = CkJsonObject::ckStringOf(jResp,"items[i].predictedPackage[j].declaredValue")
            j = j + 1
        Wend
        j = 0
        count_j = CkJsonObject::ckSizeOfArray(jResp,"items[i].shipments")
        While j < count_j
            CkJsonObject::setCkJ(jResp, j)
            id = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].id")
            created = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].created")
            shipToName = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.name")
            shipToCompanyName = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.companyName")
            shipToStreet = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.street")
            shipToCity = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.city")
            shipToCountryCode = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.countryCode")
            shipToCountryName = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.countryName")
            shipToPostalCode = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.postalCode")
            shipToStateOrProvinceCode = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.stateOrProvinceCode")
            shipToStateOrProvinceName = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.stateOrProvinceName")
            shipToPhone = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.phone")
            shipFromCompanyName = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipFrom.companyName")
            shipFromStreet = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipFrom.street")
            shipFromCity = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipFrom.city")
            shipFromCountryCode = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipFrom.countryCode")
            shipFromCountryName = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipFrom.countryName")
            shipFromPostalCode = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipFrom.postalCode")
            shipFromStateOrProvinceCode = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipFrom.stateOrProvinceCode")
            shipFromStateOrProvinceName = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipFrom.stateOrProvinceName")
            shipFromPhone = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipFrom.phone")
            parcelWeight = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].parcel.weight")
            parcelWeightUnit = CkJsonObject::ckIntOf(jResp,"items[i].shipments[j].parcel.weightUnit")
            parcelWidth = CkJsonObject::ckIntOf(jResp,"items[i].shipments[j].parcel.width")
            parcelHeight = CkJsonObject::ckIntOf(jResp,"items[i].shipments[j].parcel.height")
            parcelLength = CkJsonObject::ckIntOf(jResp,"items[i].shipments[j].parcel.length")
            parcelDimensionUnit = CkJsonObject::ckIntOf(jResp,"items[i].shipments[j].parcel.dimensionUnit")
            shippingServiceCarrier = CkJsonObject::ckIntOf(jResp,"items[i].shipments[j].shippingService.carrier")
            shippingServiceCarrierName = CkJsonObject::ckIntOf(jResp,"items[i].shipments[j].shippingService.carrierName")
            shippingServiceCarrierServiceName = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shippingService.carrierServiceName")
            shippingServiceCarrierServiceCode = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shippingService.carrierServiceCode")
            trackingTracking_number = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].tracking.tracking_number")
            trackingTracking_url = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].tracking.tracking_url")
            trackingEstimatedDays = CkJsonObject::ckIntOf(jResp,"items[i].shipments[j].tracking.estimatedDays")
            shippingLabelLabel_url = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shippingLabel.label_url")
            shippingLabelCommercial_invoice_url = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shippingLabel.commercial_invoice_url")
            j = j + 1
        Wend
        j = 0
        count_j = CkJsonObject::ckSizeOfArray(jResp,"items[i].taxesOnShipping")
        While j < count_j
            CkJsonObject::setCkJ(jResp, j)
            name = CkJsonObject::ckStringOf(jResp,"items[i].taxesOnShipping[j].name")
            value = CkJsonObject::ckIntOf(jResp,"items[i].taxesOnShipping[j].value")
            total_str = CkJsonObject::ckStringOf(jResp,"items[i].taxesOnShipping[j].total")
            j = j + 1
        Wend
        j = 0
        count_j = CkJsonObject::ckSizeOfArray(jResp,"items[i].orderExtraFields")
        While j < count_j
            CkJsonObject::setCkJ(jResp, j)
            id = CkJsonObject::ckStringOf(jResp,"items[i].orderExtraFields[j].id")
            value_str = CkJsonObject::ckStringOf(jResp,"items[i].orderExtraFields[j].value")
            customerInputType = CkJsonObject::ckStringOf(jResp,"items[i].orderExtraFields[j].customerInputType")
            title = CkJsonObject::ckStringOf(jResp,"items[i].orderExtraFields[j].title")
            orderDetailsDisplaySection = CkJsonObject::ckStringOf(jResp,"items[i].orderExtraFields[j].orderDetailsDisplaySection")
            orderBy = CkJsonObject::ckStringOf(jResp,"items[i].orderExtraFields[j].orderBy")
            j = j + 1
        Wend
        i = i + 1
    Wend


    CkHttp::ckDispose(http)
    CkJsonObject::ckDispose(jsonToken)
    CkJsonObject::ckDispose(params)
    CkHttpResponse::ckDispose(resp)
    CkStringBuilder::ckDispose(sbResponseBody)
    CkJsonObject::ckDispose(jResp)
    CkJsonObject::ckDispose(json1)


    ProcedureReturn
EndProcedure