|
|
(JavaScript) Ecwid - Search Orders
Search or filter orders in an Ecwid store. The response provides full details of the found orders.Note: This example requires Chilkat v11.0.0 or greater. For more information, see https://api-docs.ecwid.com/reference/orders#search-orders
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;
}
|
