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

Chilkat2 Java
import com.chilkatsoft.chilkat2.ChilkatException;
import com.chilkatsoft.chilkat2.Http;
import com.chilkatsoft.chilkat2.HttpResponse;
import com.chilkatsoft.chilkat2.JsonObject;
import com.chilkatsoft.chilkat2.StringBuilder;

public class ChilkatExample {

    public static void main(String[] args) {
        // This example assumes the Chilkat API to have been previously unlocked.
        // See Global Unlock Sample for sample code.

        Http http = new Http();

        // Implements the following CURL command:

        // curl --request GET \
        //      --url 'https://app.ecwid.com/api/v3/storeId/orders?token=token' \
        //      --header 'Accept: application/json'

        // Use the following online tool to generate HTTP code from a CURL command
        // Convert a cURL Command to HTTP Source Code

        // Load the access token previously obtained in Ecwid Get Access Token
        JsonObject jsonToken = new JsonObject();
        jsonToken.loadFile("qa_data/tokens/ecwid.json");

        http.setRequestHeader("Accept", "application/json");

        JsonObject params = new JsonObject();
        params.updateInt("limit", 100);
        params.updateString("email", "joe@example.com");
        params.updateString("token", jsonToken.stringOf("access_token"));

        HttpResponse resp = new HttpResponse();
        try {
            http.httpParams("GET", "https://app.ecwid.com/api/v3/storeId/orders", params, resp);
        } catch (ChilkatException e) {
            System.out.println(e.getLastErrorText());
            return;
        }

        StringBuilder sbResponseBody = new StringBuilder();
        resp.getBodySb(sbResponseBody);
        JsonObject jResp = new JsonObject();
        jResp.loadSb(sbResponseBody);
        jResp.setEmitCompact(false);

        System.out.println("Response Body:");
        System.out.println(jResp.emit());

        int respStatusCode = resp.getStatusCode();

        System.out.println("Response Status Code = " + respStatusCode);
        if (respStatusCode != 200) {
            System.out.println("Failed.");
            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

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

        int total = jResp.intOf("total");
        int count = jResp.intOf("count");
        int offset = jResp.intOf("offset");
        int limit = jResp.intOf("limit");
        int i = 0;
        int count_i = jResp.sizeOfArray("items");
        while (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");
            while (j < count_j) {
                jResp.setJ(j);
                j = j + 1;
            }

            j = 0;
            count_j = jResp.sizeOfArray("items[i].discountInfo");
            while (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");
            while (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");
                while (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");
                    while (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");
                    while (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");
                while (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");
                while (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");
            while (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");
            while (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");
            while (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");
            while (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");
            while (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;
        }
    }
}