Sample code for 30+ languages & platforms
Go 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 Go Downloads

Go
    success := false

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

    http := chilkat.NewHttp()

    //  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.NewJsonObject()
    jsonToken.LoadFile("qa_data/tokens/ecwid.json")

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

    params := chilkat.NewJsonObject()
    params.UpdateInt("limit",100)
    params.UpdateString("email","joe@example.com")
    params.UpdateString("token",*jsonToken.StringOf("access_token"))

    resp := chilkat.NewHttpResponse()
    success = http.HttpParams("GET","https://app.ecwid.com/api/v3/storeId/orders",params,resp)
    if success == false {
        fmt.Println(http.LastErrorText())
        http.DisposeHttp()
        jsonToken.DisposeJsonObject()
        params.DisposeJsonObject()
        resp.DisposeHttpResponse()
        return
    }

    sbResponseBody := chilkat.NewStringBuilder()
    resp.GetBodySb(sbResponseBody)
    jResp := chilkat.NewJsonObject()
    jResp.LoadSb(sbResponseBody)
    jResp.SetEmitCompact(false)

    fmt.Println("Response Body:")
    fmt.Println(*jResp.Emit())

    respStatusCode := resp.StatusCode()

    fmt.Println("Response Status Code = ", respStatusCode)
    if respStatusCode != 200 {
        fmt.Println("Failed.")
        http.DisposeHttp()
        jsonToken.DisposeJsonObject()
        params.DisposeJsonObject()
        resp.DisposeHttpResponse()
        sbResponseBody.DisposeStringBuilder()
        jResp.DisposeJsonObject()
        return
    }

    //  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

    var id *string = new(string)
    var subtotal *string = new(string)
    var total_str *string = new(string)
    var giftCardRedemption *string = new(string)
    var totalBeforeGiftCardRedemption *string = new(string)
    var giftCardDoubleSpending bool
    var usdTotal *string = new(string)
    var tax *string = new(string)
    var paymentMethod *string = new(string)
    var paymentStatus *string = new(string)
    var fulfillmentStatus *string = new(string)
    var vendorOrderNumber *string = new(string)
    var orderNumber int
    var refererUrl *string = new(string)
    var globalReferer *string = new(string)
    var createDate *string = new(string)
    var updateDate *string = new(string)
    var createTimestamp int
    var updateTimestamp int
    var hidden bool
    var orderComments *string = new(string)
    var privateAdminNotes *string = new(string)
    var email *string = new(string)
    var ipAddress *string = new(string)
    var customerId int
    var customerGroupId int
    var customerGroup *string = new(string)
    var customerTaxExempt bool
    var customerTaxId *string = new(string)
    var customerTaxIdValid bool
    var reversedTaxApplied bool
    var discount int
    var couponDiscount int
    var volumeDiscount int
    var membershipBasedDiscount int
    var totalAndMembershipBasedDiscount int
    var discountCouponId int
    var discountCouponName *string = new(string)
    var discountCouponCode *string = new(string)
    var discountCouponDiscountType *string = new(string)
    var discountCouponStatus *string = new(string)
    var discountCouponDiscount int
    var discountCouponLaunchDate *string = new(string)
    var discountCouponUsesLimit *string = new(string)
    var discountCouponApplicationLimit *string = new(string)
    var discountCouponCreationDate *string = new(string)
    var discountCouponUpdateDate *string = new(string)
    var discountCouponOrderCount int
    var refundedAmount *string = new(string)
    var billingPersonName *string = new(string)
    var billingPersonCompanyName *string = new(string)
    var billingPersonStreet *string = new(string)
    var billingPersonCity *string = new(string)
    var billingPersonCountryCode *string = new(string)
    var billingPersonCountryName *string = new(string)
    var billingPersonPostalCode *string = new(string)
    var billingPersonStateOrProvinceCode *string = new(string)
    var billingPersonStateOrProvinceName *string = new(string)
    var billingPersonPhone *string = new(string)
    var shippingPersonName *string = new(string)
    var shippingPersonCompanyName *string = new(string)
    var shippingPersonStreet *string = new(string)
    var shippingPersonCity *string = new(string)
    var shippingPersonCountryCode *string = new(string)
    var shippingPersonCountryName *string = new(string)
    var shippingPersonPostalCode *string = new(string)
    var shippingPersonStateOrProvinceCode *string = new(string)
    var shippingPersonStateOrProvinceName *string = new(string)
    var shippingPersonPhone *string = new(string)
    var shippingOptionShippingCarrierName *string = new(string)
    var shippingOptionShippingMethodName *string = new(string)
    var shippingOptionShippingRate *string = new(string)
    var shippingOptionEstimatedTransitTime *string = new(string)
    var shippingOptionIsPickup bool
    var handlingFeeName *string = new(string)
    var handlingFeeValue int
    var handlingFeeDescription *string = new(string)
    var paymentModule *string = new(string)
additionalInfoGoogle_customer_    var id *string = new(string)
    var acceptMarketing bool
    var refererId *string = new(string)
    var disableAllCustomerNotifications bool
    var externalFulfillment bool
    var pricesIncludeTax bool
    var j int
    var count_j int
    var value int
    var v_type *string = new(string)
    var base *string = new(string)
    var orderTotal int
    var id_int int
    var productId int
    var categoryId int
    var price int
    var productPrice int
    var sku *string = new(string)
    var quantity int
    var shortDescription *string = new(string)
    var shipping int
    var quantityInStock int
    var name *string = new(string)
    var isShippingRequired bool
    var weight int
    var trackQuantity bool
    var fixedShippingRateOnly bool
    var imageUrl *string = new(string)
    var smallThumbnailUrl *string = new(string)
    var hdThumbnailUrl *string = new(string)
    var fixedShippingRate int
    var digital bool
    var couponApplied bool
    var dimensionsLength int
    var dimensionsWidth int
    var dimensionsHeight int
    var couponAmount *string = new(string)
    var subscriptionId int
    var recurringChargeSettingsRecurringInterval *string = new(string)
    var recurringChargeSettingsRecurringIntervalCount int
    var k int
    var count_k int
    var value_str *string = new(string)
    json1 := chilkat.NewJsonObject()
    var i1 int
    var count_i1 int
    var strVal *string = new(string)
    var selectionTitle *string = new(string)
    var selectionModifier int
    var selectionModifierType *string = new(string)
    var taxOnDiscountedSubtotal *string = new(string)
    var taxOnShipping int
    var includeInPrice bool
    var discountInfoValue int
    var discountInfoType *string = new(string)
    var discountInfoBase *string = new(string)
    var discountInfoOrderTotal int
    var date *string = new(string)
    var source *string = new(string)
    var reason *string = new(string)
    var amount *string = new(string)
    var length int
    var width int
    var height int
    var weight_str *string = new(string)
    var declaredValue *string = new(string)
    var created *string = new(string)
    var shipToName *string = new(string)
    var shipToCompanyName *string = new(string)
    var shipToStreet *string = new(string)
    var shipToCity *string = new(string)
    var shipToCountryCode *string = new(string)
    var shipToCountryName *string = new(string)
    var shipToPostalCode *string = new(string)
    var shipToStateOrProvinceCode *string = new(string)
    var shipToStateOrProvinceName *string = new(string)
    var shipToPhone *string = new(string)
    var shipFromCompanyName *string = new(string)
    var shipFromStreet *string = new(string)
    var shipFromCity *string = new(string)
    var shipFromCountryCode *string = new(string)
    var shipFromCountryName *string = new(string)
    var shipFromPostalCode *string = new(string)
    var shipFromStateOrProvinceCode *string = new(string)
    var shipFromStateOrProvinceName *string = new(string)
    var shipFromPhone *string = new(string)
    var parcelWeight *string = new(string)
    var parcelWeightUnit int
    var parcelWidth int
    var parcelHeight int
    var parcelLength int
    var parcelDimensionUnit int
    var shippingServiceCarrier int
    var shippingServiceCarrierName int
    var shippingServiceCarrierServiceName *string = new(string)
    var shippingServiceCarrierServiceCode *string = new(string)
    var trackingTracking_number *string = new(string)
    var trackingTracking_url *string = new(string)
    var trackingEstimatedDays int
    var shippingLabelLabel_url *string = new(string)
    var shippingLabelCommercial_invoice_url *string = new(string)
    var customerInputType *string = new(string)
    var title *string = new(string)
    var orderDetailsDisplaySection *string = new(string)
    var orderBy *string = new(string)

    total := jResp.IntOf("total")
    count := jResp.IntOf("count")
    offset := jResp.IntOf("offset")
    limit := jResp.IntOf("limit")
    i := 0
    count_i := jResp.SizeOfArray("items")
    for i < count_i {
        jResp.SetI(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")
        for j < count_j {
            jResp.SetJ(j)
            j = j + 1
        }

        j = 0
        count_j = jResp.SizeOfArray("items[i].discountInfo")
        for j < count_j {
            jResp.SetJ(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")
        for j < count_j {
            jResp.SetJ(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")
            for k < count_k {
                jResp.SetK(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")
                jResp.ObjectOf2("items[i].items[j].selectedOptions[k]",json1)

                i1 = 0
                count_i1 = json1.SizeOfArray("valuesArray")
                for i1 < count_i1 {
                    json1.SetI(i1)
                    strVal = json1.StringOf("valuesArray[i]")
                    i1 = i1 + 1
                }

                jResp.ObjectOf2("items[i].items[j].selectedOptions[k]",json1)
                i1 = 0
                count_i1 = json1.SizeOfArray("selections")
                for i1 < count_i1 {
                    json1.SetI(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")
            for k < count_k {
                jResp.SetK(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")
            for k < count_k {
                jResp.SetK(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")
        for j < count_j {
            jResp.SetJ(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")
        for j < count_j {
            jResp.SetJ(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")
        for j < count_j {
            jResp.SetJ(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")
        for j < count_j {
            jResp.SetJ(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")
        for j < count_j {
            jResp.SetJ(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
    }


    http.DisposeHttp()
    jsonToken.DisposeJsonObject()
    params.DisposeJsonObject()
    resp.DisposeHttpResponse()
    sbResponseBody.DisposeStringBuilder()
    jResp.DisposeJsonObject()
    json1.DisposeJsonObject()