(MFC) Ecwid - Search Orders

See more Ecwid Examples

Search or filter orders in an Ecwid store. The response provides full details of the found orders.

For more information, see https://api-docs.ecwid.com/reference/orders#search-orders

Chilkat C/C++ Library Downloads MS Visual C/C++ Libs

See Also: Using MFC CString in Chilkat

#include <CkHttp.h>
#include <CkJsonObject.h>
#include <CkHttpResponse.h>
#include <CkStringBuilder.h>

void ChilkatSample(void)
    {
    CkString strOut;

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

    CkHttp http;
    bool success;

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

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

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

    CkHttpResponse *resp = http.QuickRequestParams("GET","https://app.ecwid.com/api/v3/storeId/orders",params);
    if (http.get_LastMethodSuccess() == false) {
        strOut.append(http.lastErrorText());
        strOut.append("\r\n");
        SetDlgItemText(IDC_EDIT1,strOut.getUnicode());
        return;
    }

    CkStringBuilder sbResponseBody;
    resp->GetBodySb(sbResponseBody);
    CkJsonObject jResp;
    jResp.LoadSb(sbResponseBody);
    jResp.put_EmitCompact(false);

    strOut.append("Response Body:");
    strOut.append("\r\n");
    strOut.append(jResp.emit());
    strOut.append("\r\n");

    int respStatusCode = resp->get_StatusCode();
    delete resp;

    strOut.append("Response Status Code = ");
    strOut.appendInt(respStatusCode);
    strOut.append("\r\n");
    if (respStatusCode != 200) {
        strOut.append("Failed.");
        strOut.append("\r\n");
        SetDlgItemText(IDC_EDIT1,strOut.getUnicode());
        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

    // Chilkat functions returning "const char *" return a pointer to temporary internal memory owned and managed by Chilkat.
    // See this example explaining how this memory should be used: const char * functions.

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

    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.put_I(i);
        id = jResp.stringOf("items[i].id");
        subtotal = jResp.stringOf("items[i].subtotal");
        total_str = jResp.stringOf("items[i].total");
        giftCardRedemption = jResp.stringOf("items[i].giftCardRedemption");
        totalBeforeGiftCardRedemption = jResp.stringOf("items[i].totalBeforeGiftCardRedemption");
        giftCardDoubleSpending = jResp.BoolOf("items[i].giftCardDoubleSpending");
        usdTotal = jResp.stringOf("items[i].usdTotal");
        tax = jResp.stringOf("items[i].tax");
        paymentMethod = jResp.stringOf("items[i].paymentMethod");
        paymentStatus = jResp.stringOf("items[i].paymentStatus");
        fulfillmentStatus = jResp.stringOf("items[i].fulfillmentStatus");
        vendorOrderNumber = jResp.stringOf("items[i].vendorOrderNumber");
        orderNumber = jResp.IntOf("items[i].orderNumber");
        refererUrl = jResp.stringOf("items[i].refererUrl");
        globalReferer = jResp.stringOf("items[i].globalReferer");
        createDate = jResp.stringOf("items[i].createDate");
        updateDate = jResp.stringOf("items[i].updateDate");
        createTimestamp = jResp.IntOf("items[i].createTimestamp");
        updateTimestamp = jResp.IntOf("items[i].updateTimestamp");
        hidden = jResp.BoolOf("items[i].hidden");
        orderComments = jResp.stringOf("items[i].orderComments");
        privateAdminNotes = jResp.stringOf("items[i].privateAdminNotes");
        email = jResp.stringOf("items[i].email");
        ipAddress = jResp.stringOf("items[i].ipAddress");
        customerId = jResp.IntOf("items[i].customerId");
        customerGroupId = jResp.IntOf("items[i].customerGroupId");
        customerGroup = jResp.stringOf("items[i].customerGroup");
        customerTaxExempt = jResp.BoolOf("items[i].customerTaxExempt");
        customerTaxId = jResp.stringOf("items[i].customerTaxId");
        customerTaxIdValid = jResp.BoolOf("items[i].customerTaxIdValid");
        reversedTaxApplied = jResp.BoolOf("items[i].reversedTaxApplied");
        discount = jResp.IntOf("items[i].discount");
        couponDiscount = jResp.IntOf("items[i].couponDiscount");
        volumeDiscount = jResp.IntOf("items[i].volumeDiscount");
        membershipBasedDiscount = jResp.IntOf("items[i].membershipBasedDiscount");
        totalAndMembershipBasedDiscount = jResp.IntOf("items[i].totalAndMembershipBasedDiscount");
        discountCouponId = jResp.IntOf("items[i].discountCoupon.id");
        discountCouponName = jResp.stringOf("items[i].discountCoupon.name");
        discountCouponCode = jResp.stringOf("items[i].discountCoupon.code");
        discountCouponDiscountType = jResp.stringOf("items[i].discountCoupon.discountType");
        discountCouponStatus = jResp.stringOf("items[i].discountCoupon.status");
        discountCouponDiscount = jResp.IntOf("items[i].discountCoupon.discount");
        discountCouponLaunchDate = jResp.stringOf("items[i].discountCoupon.launchDate");
        discountCouponUsesLimit = jResp.stringOf("items[i].discountCoupon.usesLimit");
        discountCouponApplicationLimit = jResp.stringOf("items[i].discountCoupon.applicationLimit");
        discountCouponCreationDate = jResp.stringOf("items[i].discountCoupon.creationDate");
        discountCouponUpdateDate = jResp.stringOf("items[i].discountCoupon.updateDate");
        discountCouponOrderCount = jResp.IntOf("items[i].discountCoupon.orderCount");
        refundedAmount = jResp.stringOf("items[i].refundedAmount");
        billingPersonName = jResp.stringOf("items[i].billingPerson.name");
        billingPersonCompanyName = jResp.stringOf("items[i].billingPerson.companyName");
        billingPersonStreet = jResp.stringOf("items[i].billingPerson.street");
        billingPersonCity = jResp.stringOf("items[i].billingPerson.city");
        billingPersonCountryCode = jResp.stringOf("items[i].billingPerson.countryCode");
        billingPersonCountryName = jResp.stringOf("items[i].billingPerson.countryName");
        billingPersonPostalCode = jResp.stringOf("items[i].billingPerson.postalCode");
        billingPersonStateOrProvinceCode = jResp.stringOf("items[i].billingPerson.stateOrProvinceCode");
        billingPersonStateOrProvinceName = jResp.stringOf("items[i].billingPerson.stateOrProvinceName");
        billingPersonPhone = jResp.stringOf("items[i].billingPerson.phone");
        shippingPersonName = jResp.stringOf("items[i].shippingPerson.name");
        shippingPersonCompanyName = jResp.stringOf("items[i].shippingPerson.companyName");
        shippingPersonStreet = jResp.stringOf("items[i].shippingPerson.street");
        shippingPersonCity = jResp.stringOf("items[i].shippingPerson.city");
        shippingPersonCountryCode = jResp.stringOf("items[i].shippingPerson.countryCode");
        shippingPersonCountryName = jResp.stringOf("items[i].shippingPerson.countryName");
        shippingPersonPostalCode = jResp.stringOf("items[i].shippingPerson.postalCode");
        shippingPersonStateOrProvinceCode = jResp.stringOf("items[i].shippingPerson.stateOrProvinceCode");
        shippingPersonStateOrProvinceName = jResp.stringOf("items[i].shippingPerson.stateOrProvinceName");
        shippingPersonPhone = jResp.stringOf("items[i].shippingPerson.phone");
        shippingOptionShippingCarrierName = jResp.stringOf("items[i].shippingOption.shippingCarrierName");
        shippingOptionShippingMethodName = jResp.stringOf("items[i].shippingOption.shippingMethodName");
        shippingOptionShippingRate = jResp.stringOf("items[i].shippingOption.shippingRate");
        shippingOptionEstimatedTransitTime = jResp.stringOf("items[i].shippingOption.estimatedTransitTime");
        shippingOptionIsPickup = jResp.BoolOf("items[i].shippingOption.isPickup");
        handlingFeeName = jResp.stringOf("items[i].handlingFee.name");
        handlingFeeValue = jResp.IntOf("items[i].handlingFee.value");
        handlingFeeDescription = jResp.stringOf("items[i].handlingFee.description");
        paymentModule = jResp.stringOf("items[i].paymentModule");
        additionalInfoGoogle_customer_id = jResp.stringOf("items[i].additionalInfo.google_customer_id");
        acceptMarketing = jResp.BoolOf("items[i].acceptMarketing");
        refererId = jResp.stringOf("items[i].refererId");
        disableAllCustomerNotifications = jResp.BoolOf("items[i].disableAllCustomerNotifications");
        externalFulfillment = jResp.BoolOf("items[i].externalFulfillment");
        pricesIncludeTax = jResp.BoolOf("items[i].pricesIncludeTax");
        j = 0;
        count_j = jResp.SizeOfArray("items[i].customDiscount");
        while (j < count_j) {
            jResp.put_J(j);
            j = j + 1;
        }

        j = 0;
        count_j = jResp.SizeOfArray("items[i].discountInfo");
        while (j < count_j) {
            jResp.put_J(j);
            value = jResp.IntOf("items[i].discountInfo[j].value");
            v_type = jResp.stringOf("items[i].discountInfo[j].type");
            base = jResp.stringOf("items[i].discountInfo[j].base");
            orderTotal = jResp.IntOf("items[i].discountInfo[j].orderTotal");
            j = j + 1;
        }

        j = 0;
        count_j = jResp.SizeOfArray("items[i].items");
        while (j < count_j) {
            jResp.put_J(j);
            id_int = jResp.IntOf("items[i].items[j].id");
            productId = jResp.IntOf("items[i].items[j].productId");
            categoryId = jResp.IntOf("items[i].items[j].categoryId");
            price = jResp.IntOf("items[i].items[j].price");
            productPrice = jResp.IntOf("items[i].items[j].productPrice");
            sku = jResp.stringOf("items[i].items[j].sku");
            quantity = jResp.IntOf("items[i].items[j].quantity");
            shortDescription = jResp.stringOf("items[i].items[j].shortDescription");
            tax = jResp.stringOf("items[i].items[j].tax");
            shipping = jResp.IntOf("items[i].items[j].shipping");
            quantityInStock = jResp.IntOf("items[i].items[j].quantityInStock");
            name = jResp.stringOf("items[i].items[j].name");
            isShippingRequired = jResp.BoolOf("items[i].items[j].isShippingRequired");
            weight = jResp.IntOf("items[i].items[j].weight");
            trackQuantity = jResp.BoolOf("items[i].items[j].trackQuantity");
            fixedShippingRateOnly = jResp.BoolOf("items[i].items[j].fixedShippingRateOnly");
            imageUrl = jResp.stringOf("items[i].items[j].imageUrl");
            smallThumbnailUrl = jResp.stringOf("items[i].items[j].smallThumbnailUrl");
            hdThumbnailUrl = jResp.stringOf("items[i].items[j].hdThumbnailUrl");
            fixedShippingRate = jResp.IntOf("items[i].items[j].fixedShippingRate");
            digital = jResp.BoolOf("items[i].items[j].digital");
            couponApplied = jResp.BoolOf("items[i].items[j].couponApplied");
            dimensionsLength = jResp.IntOf("items[i].items[j].dimensions.length");
            dimensionsWidth = jResp.IntOf("items[i].items[j].dimensions.width");
            dimensionsHeight = jResp.IntOf("items[i].items[j].dimensions.height");
            couponAmount = jResp.stringOf("items[i].items[j].couponAmount");
            subscriptionId = jResp.IntOf("items[i].items[j].subscriptionId");
            recurringChargeSettingsRecurringInterval = jResp.stringOf("items[i].items[j].recurringChargeSettings.recurringInterval");
            recurringChargeSettingsRecurringIntervalCount = jResp.IntOf("items[i].items[j].recurringChargeSettings.recurringIntervalCount");
            k = 0;
            count_k = jResp.SizeOfArray("items[i].items[j].selectedOptions");
            while (k < count_k) {
                jResp.put_K(k);
                name = jResp.stringOf("items[i].items[j].selectedOptions[k].name");
                value_str = jResp.stringOf("items[i].items[j].selectedOptions[k].value");
                v_type = jResp.stringOf("items[i].items[j].selectedOptions[k].type");

                json1 = jResp.ObjectOf("items[i].items[j].selectedOptions[k]");
                i1 = 0;
                count_i1 = json1->SizeOfArray("valuesArray");
                while (i1 < count_i1) {
                    json1->put_I(i1);
                    strVal = json1->stringOf("valuesArray[i]");
                    i1 = i1 + 1;
                }

                delete json1;

                json1 = jResp.ObjectOf("items[i].items[j].selectedOptions[k]");
                i1 = 0;
                count_i1 = json1->SizeOfArray("selections");
                while (i1 < count_i1) {
                    json1->put_I(i1);
                    selectionTitle = json1->stringOf("selections[i].selectionTitle");
                    selectionModifier = json1->IntOf("selections[i].selectionModifier");
                    selectionModifierType = json1->stringOf("selections[i].selectionModifierType");
                    i1 = i1 + 1;
                }

                delete json1;
                k = k + 1;
            }

            k = 0;
            count_k = jResp.SizeOfArray("items[i].items[j].taxes");
            while (k < count_k) {
                jResp.put_K(k);
                name = jResp.stringOf("items[i].items[j].taxes[k].name");
                value = jResp.IntOf("items[i].items[j].taxes[k].value");
                total_str = jResp.stringOf("items[i].items[j].taxes[k].total");
                taxOnDiscountedSubtotal = jResp.stringOf("items[i].items[j].taxes[k].taxOnDiscountedSubtotal");
                taxOnShipping = jResp.IntOf("items[i].items[j].taxes[k].taxOnShipping");
                includeInPrice = jResp.BoolOf("items[i].items[j].taxes[k].includeInPrice");
                k = k + 1;
            }

            k = 0;
            count_k = jResp.SizeOfArray("items[i].items[j].discounts");
            while (k < count_k) {
                jResp.put_K(k);
                discountInfoValue = jResp.IntOf("items[i].items[j].discounts[k].discountInfo.value");
                discountInfoType = jResp.stringOf("items[i].items[j].discounts[k].discountInfo.type");
                discountInfoBase = jResp.stringOf("items[i].items[j].discounts[k].discountInfo.base");
                discountInfoOrderTotal = jResp.IntOf("items[i].items[j].discounts[k].discountInfo.orderTotal");
                total_str = jResp.stringOf("items[i].items[j].discounts[k].total");
                k = k + 1;
            }

            j = j + 1;
        }

        j = 0;
        count_j = jResp.SizeOfArray("items[i].refunds");
        while (j < count_j) {
            jResp.put_J(j);
            date = jResp.stringOf("items[i].refunds[j].date");
            source = jResp.stringOf("items[i].refunds[j].source");
            reason = jResp.stringOf("items[i].refunds[j].reason");
            amount = jResp.stringOf("items[i].refunds[j].amount");
            j = j + 1;
        }

        j = 0;
        count_j = jResp.SizeOfArray("items[i].predictedPackage");
        while (j < count_j) {
            jResp.put_J(j);
            length = jResp.IntOf("items[i].predictedPackage[j].length");
            width = jResp.IntOf("items[i].predictedPackage[j].width");
            height = jResp.IntOf("items[i].predictedPackage[j].height");
            weight_str = jResp.stringOf("items[i].predictedPackage[j].weight");
            declaredValue = jResp.stringOf("items[i].predictedPackage[j].declaredValue");
            j = j + 1;
        }

        j = 0;
        count_j = jResp.SizeOfArray("items[i].shipments");
        while (j < count_j) {
            jResp.put_J(j);
            id = jResp.stringOf("items[i].shipments[j].id");
            created = jResp.stringOf("items[i].shipments[j].created");
            shipToName = jResp.stringOf("items[i].shipments[j].shipTo.name");
            shipToCompanyName = jResp.stringOf("items[i].shipments[j].shipTo.companyName");
            shipToStreet = jResp.stringOf("items[i].shipments[j].shipTo.street");
            shipToCity = jResp.stringOf("items[i].shipments[j].shipTo.city");
            shipToCountryCode = jResp.stringOf("items[i].shipments[j].shipTo.countryCode");
            shipToCountryName = jResp.stringOf("items[i].shipments[j].shipTo.countryName");
            shipToPostalCode = jResp.stringOf("items[i].shipments[j].shipTo.postalCode");
            shipToStateOrProvinceCode = jResp.stringOf("items[i].shipments[j].shipTo.stateOrProvinceCode");
            shipToStateOrProvinceName = jResp.stringOf("items[i].shipments[j].shipTo.stateOrProvinceName");
            shipToPhone = jResp.stringOf("items[i].shipments[j].shipTo.phone");
            shipFromCompanyName = jResp.stringOf("items[i].shipments[j].shipFrom.companyName");
            shipFromStreet = jResp.stringOf("items[i].shipments[j].shipFrom.street");
            shipFromCity = jResp.stringOf("items[i].shipments[j].shipFrom.city");
            shipFromCountryCode = jResp.stringOf("items[i].shipments[j].shipFrom.countryCode");
            shipFromCountryName = jResp.stringOf("items[i].shipments[j].shipFrom.countryName");
            shipFromPostalCode = jResp.stringOf("items[i].shipments[j].shipFrom.postalCode");
            shipFromStateOrProvinceCode = jResp.stringOf("items[i].shipments[j].shipFrom.stateOrProvinceCode");
            shipFromStateOrProvinceName = jResp.stringOf("items[i].shipments[j].shipFrom.stateOrProvinceName");
            shipFromPhone = jResp.stringOf("items[i].shipments[j].shipFrom.phone");
            parcelWeight = jResp.stringOf("items[i].shipments[j].parcel.weight");
            parcelWeightUnit = jResp.IntOf("items[i].shipments[j].parcel.weightUnit");
            parcelWidth = jResp.IntOf("items[i].shipments[j].parcel.width");
            parcelHeight = jResp.IntOf("items[i].shipments[j].parcel.height");
            parcelLength = jResp.IntOf("items[i].shipments[j].parcel.length");
            parcelDimensionUnit = jResp.IntOf("items[i].shipments[j].parcel.dimensionUnit");
            shippingServiceCarrier = jResp.IntOf("items[i].shipments[j].shippingService.carrier");
            shippingServiceCarrierName = jResp.IntOf("items[i].shipments[j].shippingService.carrierName");
            shippingServiceCarrierServiceName = jResp.stringOf("items[i].shipments[j].shippingService.carrierServiceName");
            shippingServiceCarrierServiceCode = jResp.stringOf("items[i].shipments[j].shippingService.carrierServiceCode");
            trackingTracking_number = jResp.stringOf("items[i].shipments[j].tracking.tracking_number");
            trackingTracking_url = jResp.stringOf("items[i].shipments[j].tracking.tracking_url");
            trackingEstimatedDays = jResp.IntOf("items[i].shipments[j].tracking.estimatedDays");
            shippingLabelLabel_url = jResp.stringOf("items[i].shipments[j].shippingLabel.label_url");
            shippingLabelCommercial_invoice_url = jResp.stringOf("items[i].shipments[j].shippingLabel.commercial_invoice_url");
            j = j + 1;
        }

        j = 0;
        count_j = jResp.SizeOfArray("items[i].taxesOnShipping");
        while (j < count_j) {
            jResp.put_J(j);
            name = jResp.stringOf("items[i].taxesOnShipping[j].name");
            value = jResp.IntOf("items[i].taxesOnShipping[j].value");
            total_str = jResp.stringOf("items[i].taxesOnShipping[j].total");
            j = j + 1;
        }

        j = 0;
        count_j = jResp.SizeOfArray("items[i].orderExtraFields");
        while (j < count_j) {
            jResp.put_J(j);
            id = jResp.stringOf("items[i].orderExtraFields[j].id");
            value_str = jResp.stringOf("items[i].orderExtraFields[j].value");
            customerInputType = jResp.stringOf("items[i].orderExtraFields[j].customerInputType");
            title = jResp.stringOf("items[i].orderExtraFields[j].title");
            orderDetailsDisplaySection = jResp.stringOf("items[i].orderExtraFields[j].orderDetailsDisplaySection");
            orderBy = jResp.stringOf("items[i].orderExtraFields[j].orderBy");
            j = j + 1;
        }

        i = i + 1;
    }



    SetDlgItemText(IDC_EDIT1,strOut.getUnicode());

    }