(C#) 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 .NET Downloads Chilkat .NET Framework Chilkat for .NET Core

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

Chilkat.Http http = new Chilkat.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
Chilkat.JsonObject jsonToken = new Chilkat.JsonObject();
jsonToken.LoadFile("qa_data/tokens/ecwid.json");

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

Chilkat.JsonObject params = new Chilkat.JsonObject();
params.UpdateInt("limit",100);
params.UpdateString("email","joe@example.com");
params.UpdateString("token",jsonToken.StringOf("access_token"));

Chilkat.HttpResponse resp = http.QuickRequestParams("GET","https://app.ecwid.com/api/v3/storeId/orders",params);
if (http.LastMethodSuccess == false) {
    Debug.WriteLine(http.LastErrorText);
    return;
}

Chilkat.StringBuilder sbResponseBody = new Chilkat.StringBuilder();
resp.GetBodySb(sbResponseBody);
Chilkat.JsonObject jResp = new Chilkat.JsonObject();
jResp.LoadSb(sbResponseBody);
jResp.EmitCompact = false;

Debug.WriteLine("Response Body:");
Debug.WriteLine(jResp.Emit());

int respStatusCode = resp.StatusCode;

Debug.WriteLine("Response Status Code = " + Convert.ToString(respStatusCode));
if (respStatusCode != 200) {
    Debug.WriteLine("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;
bool giftCardDoubleSpending;
string usdTotal;
string tax;
string paymentMethod;
string paymentStatus;
string fulfillmentStatus;
string vendorOrderNumber;
int orderNumber;
string refererUrl;
string globalReferer;
string createDate;
string updateDate;
int createTimestamp;
int updateTimestamp;
bool hidden;
string orderComments;
string privateAdminNotes;
string email;
string ipAddress;
int customerId;
int customerGroupId;
string customerGroup;
bool customerTaxExempt;
string customerTaxId;
bool customerTaxIdValid;
bool reversedTaxApplied;
int discount;
int couponDiscount;
int volumeDiscount;
int membershipBasedDiscount;
int totalAndMembershipBasedDiscount;
int discountCouponId;
string discountCouponName;
string discountCouponCode;
string discountCouponDiscountType;
string discountCouponStatus;
int discountCouponDiscount;
string discountCouponLaunchDate;
string discountCouponUsesLimit;
string discountCouponApplicationLimit;
string discountCouponCreationDate;
string discountCouponUpdateDate;
int discountCouponOrderCount;
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;
bool shippingOptionIsPickup;
string handlingFeeName;
int handlingFeeValue;
string handlingFeeDescription;
string paymentModule;
string additionalInfoGoogle_customer_id;
bool acceptMarketing;
string refererId;
bool disableAllCustomerNotifications;
bool externalFulfillment;
bool pricesIncludeTax;
int j;
int count_j;
int value;
string v_type;
string base;
int orderTotal;
int id_int;
int productId;
int categoryId;
int price;
int productPrice;
string sku;
int quantity;
string shortDescription;
int shipping;
int quantityInStock;
string name;
bool isShippingRequired;
int weight;
bool trackQuantity;
bool fixedShippingRateOnly;
string imageUrl;
string smallThumbnailUrl;
string hdThumbnailUrl;
int fixedShippingRate;
bool digital;
bool couponApplied;
int dimensionsLength;
int dimensionsWidth;
int dimensionsHeight;
string couponAmount;
int subscriptionId;
string recurringChargeSettingsRecurringInterval;
int recurringChargeSettingsRecurringIntervalCount;
int k;
int count_k;
string value_str;
Chilkat.JsonObject json1 = null;
int i1;
int count_i1;
string strVal;
string selectionTitle;
int selectionModifier;
string selectionModifierType;
string taxOnDiscountedSubtotal;
int taxOnShipping;
bool includeInPrice;
int discountInfoValue;
string discountInfoType;
string discountInfoBase;
int discountInfoOrderTotal;
string date;
string source;
string reason;
string amount;
int length;
int width;
int height;
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;
int parcelWidth;
int parcelHeight;
int parcelLength;
int parcelDimensionUnit;
int shippingServiceCarrier;
int shippingServiceCarrierName;
string shippingServiceCarrierServiceName;
string shippingServiceCarrierServiceCode;
string trackingTracking_number;
string trackingTracking_url;
int trackingEstimatedDays;
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.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.J = j;
        j = j + 1;
    }

    j = 0;
    count_j = jResp.SizeOfArray("items[i].discountInfo");
    while (j < count_j) {
        jResp.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.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.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.I = i1;
                strVal = json1.StringOf("valuesArray[i]");
                i1 = i1 + 1;
            }

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

            k = k + 1;
        }

        k = 0;
        count_k = jResp.SizeOfArray("items[i].items[j].taxes");
        while (k < count_k) {
            jResp.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.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.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.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.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.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.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;
}