JavaScript
JavaScript
Ecwid - Search Orders
See more Ecwid Examples
Search or filter orders in an Ecwid store. The response provides full details of the found orders.
Note
This example is intended for running within a Chilkat.Js embedded JavaScript engine. All Chilkat JavaScript examples require Chilkat
v11.4.0 or greater.
var success = false;
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
var http = new CkHttp();
// 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
var jsonToken = new CkJsonObject();
jsonToken.LoadFile("qa_data/tokens/ecwid.json");
http.SetRequestHeader("Accept","application/json");
var params = new CkJsonObject();
params.UpdateInt("limit",100);
params.UpdateString("email","joe@example.com");
params.UpdateString("token",jsonToken.StringOf("access_token"));
var resp = new CkHttpResponse();
success = http.HttpParams("GET","https://app.ecwid.com/api/v3/storeId/orders",params,resp);
if (success == false) {
console.log(http.LastErrorText);
return;
}
var sbResponseBody = new CkStringBuilder();
resp.GetBodySb(sbResponseBody);
var jResp = new CkJsonObject();
jResp.LoadSb(sbResponseBody);
jResp.EmitCompact = false;
console.log("Response Body:");
console.log(jResp.Emit());
var respStatusCode = resp.StatusCode;
console.log("Response Status Code = " + respStatusCode);
if (respStatusCode !== 200) {
console.log("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
var id;
var subtotal;
var total_str;
var giftCardRedemption;
var totalBeforeGiftCardRedemption;
var giftCardDoubleSpending;
var usdTotal;
var tax;
var paymentMethod;
var paymentStatus;
var fulfillmentStatus;
var vendorOrderNumber;
var orderNumber;
var refererUrl;
var globalReferer;
var createDate;
var updateDate;
var createTimestamp;
var updateTimestamp;
var hidden;
var orderComments;
var privateAdminNotes;
var email;
var ipAddress;
var customerId;
var customerGroupId;
var customerGroup;
var customerTaxExempt;
var customerTaxId;
var customerTaxIdValid;
var reversedTaxApplied;
var discount;
var couponDiscount;
var volumeDiscount;
var membershipBasedDiscount;
var totalAndMembershipBasedDiscount;
var discountCouponId;
var discountCouponName;
var discountCouponCode;
var discountCouponDiscountType;
var discountCouponStatus;
var discountCouponDiscount;
var discountCouponLaunchDate;
var discountCouponUsesLimit;
var discountCouponApplicationLimit;
var discountCouponCreationDate;
var discountCouponUpdateDate;
var discountCouponOrderCount;
var refundedAmount;
var billingPersonName;
var billingPersonCompanyName;
var billingPersonStreet;
var billingPersonCity;
var billingPersonCountryCode;
var billingPersonCountryName;
var billingPersonPostalCode;
var billingPersonStateOrProvinceCode;
var billingPersonStateOrProvinceName;
var billingPersonPhone;
var shippingPersonName;
var shippingPersonCompanyName;
var shippingPersonStreet;
var shippingPersonCity;
var shippingPersonCountryCode;
var shippingPersonCountryName;
var shippingPersonPostalCode;
var shippingPersonStateOrProvinceCode;
var shippingPersonStateOrProvinceName;
var shippingPersonPhone;
var shippingOptionShippingCarrierName;
var shippingOptionShippingMethodName;
var shippingOptionShippingRate;
var shippingOptionEstimatedTransitTime;
var shippingOptionIsPickup;
var handlingFeeName;
var handlingFeeValue;
var handlingFeeDescription;
var paymentModule;
var additionalInfoGoogle_customer_id;
var acceptMarketing;
var refererId;
var disableAllCustomerNotifications;
var externalFulfillment;
var pricesIncludeTax;
var j;
var count_j;
var value;
var v_type;
var base;
var orderTotal;
var id_int;
var productId;
var categoryId;
var price;
var productPrice;
var sku;
var quantity;
var shortDescription;
var shipping;
var quantityInStock;
var name;
var isShippingRequired;
var weight;
var trackQuantity;
var fixedShippingRateOnly;
var imageUrl;
var smallThumbnailUrl;
var hdThumbnailUrl;
var fixedShippingRate;
var digital;
var couponApplied;
var dimensionsLength;
var dimensionsWidth;
var dimensionsHeight;
var couponAmount;
var subscriptionId;
var recurringChargeSettingsRecurringInterval;
var recurringChargeSettingsRecurringIntervalCount;
var k;
var count_k;
var value_str;
var json1 = new CkJsonObject();
var i1;
var count_i1;
var strVal;
var selectionTitle;
var selectionModifier;
var selectionModifierType;
var taxOnDiscountedSubtotal;
var taxOnShipping;
var includeInPrice;
var discountInfoValue;
var discountInfoType;
var discountInfoBase;
var discountInfoOrderTotal;
var date;
var source;
var reason;
var amount;
var length;
var width;
var height;
var weight_str;
var declaredValue;
var created;
var shipToName;
var shipToCompanyName;
var shipToStreet;
var shipToCity;
var shipToCountryCode;
var shipToCountryName;
var shipToPostalCode;
var shipToStateOrProvinceCode;
var shipToStateOrProvinceName;
var shipToPhone;
var shipFromCompanyName;
var shipFromStreet;
var shipFromCity;
var shipFromCountryCode;
var shipFromCountryName;
var shipFromPostalCode;
var shipFromStateOrProvinceCode;
var shipFromStateOrProvinceName;
var shipFromPhone;
var parcelWeight;
var parcelWeightUnit;
var parcelWidth;
var parcelHeight;
var parcelLength;
var parcelDimensionUnit;
var shippingServiceCarrier;
var shippingServiceCarrierName;
var shippingServiceCarrierServiceName;
var shippingServiceCarrierServiceCode;
var trackingTracking_number;
var trackingTracking_url;
var trackingEstimatedDays;
var shippingLabelLabel_url;
var shippingLabelCommercial_invoice_url;
var customerInputType;
var title;
var orderDetailsDisplaySection;
var orderBy;
var total = jResp.IntOf("total");
var count = jResp.IntOf("count");
var offset = jResp.IntOf("offset");
var limit = jResp.IntOf("limit");
var i = 0;
var 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");
jResp.ObjectOf2("items[i].items[j].selectedOptions[k]",json1);
i1 = 0;
count_i1 = json1.SizeOfArray("valuesArray");
while (i1 < count_i1) {
json1.I = 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.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;
}