Delphi ActiveX
Delphi ActiveX
Ecwid - Search Orders
See more Ecwid Examples
Search or filter orders in an Ecwid store. The response provides full details of the found orders.Chilkat Delphi ActiveX Downloads
uses
Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.StdCtrls, Chilkat_TLB;
...
procedure TForm1.Button1Click(Sender: TObject);
var
success: Integer;
http: TChilkatHttp;
jsonToken: TChilkatJsonObject;
params: TChilkatJsonObject;
resp: TChilkatHttpResponse;
sbResponseBody: TChilkatStringBuilder;
jResp: TChilkatJsonObject;
respStatusCode: Integer;
id: WideString;
subtotal: WideString;
total_str: WideString;
giftCardRedemption: WideString;
totalBeforeGiftCardRedemption: WideString;
giftCardDoubleSpending: Integer;
usdTotal: WideString;
tax: WideString;
paymentMethod: WideString;
paymentStatus: WideString;
fulfillmentStatus: WideString;
vendorOrderNumber: WideString;
orderNumber: Integer;
refererUrl: WideString;
globalReferer: WideString;
createDate: WideString;
updateDate: WideString;
createTimestamp: Integer;
updateTimestamp: Integer;
hidden: Integer;
orderComments: WideString;
privateAdminNotes: WideString;
email: WideString;
ipAddress: WideString;
customerId: Integer;
customerGroupId: Integer;
customerGroup: WideString;
customerTaxExempt: Integer;
customerTaxId: WideString;
customerTaxIdValid: Integer;
reversedTaxApplied: Integer;
discount: Integer;
couponDiscount: Integer;
volumeDiscount: Integer;
membershipBasedDiscount: Integer;
totalAndMembershipBasedDiscount: Integer;
discountCouponId: Integer;
discountCouponName: WideString;
discountCouponCode: WideString;
discountCouponDiscountType: WideString;
discountCouponStatus: WideString;
discountCouponDiscount: Integer;
discountCouponLaunchDate: WideString;
discountCouponUsesLimit: WideString;
discountCouponApplicationLimit: WideString;
discountCouponCreationDate: WideString;
discountCouponUpdateDate: WideString;
discountCouponOrderCount: Integer;
refundedAmount: WideString;
billingPersonName: WideString;
billingPersonCompanyName: WideString;
billingPersonStreet: WideString;
billingPersonCity: WideString;
billingPersonCountryCode: WideString;
billingPersonCountryName: WideString;
billingPersonPostalCode: WideString;
billingPersonStateOrProvinceCode: WideString;
billingPersonStateOrProvinceName: WideString;
billingPersonPhone: WideString;
shippingPersonName: WideString;
shippingPersonCompanyName: WideString;
shippingPersonStreet: WideString;
shippingPersonCity: WideString;
shippingPersonCountryCode: WideString;
shippingPersonCountryName: WideString;
shippingPersonPostalCode: WideString;
shippingPersonStateOrProvinceCode: WideString;
shippingPersonStateOrProvinceName: WideString;
shippingPersonPhone: WideString;
shippingOptionShippingCarrierName: WideString;
shippingOptionShippingMethodName: WideString;
shippingOptionShippingRate: WideString;
shippingOptionEstimatedTransitTime: WideString;
shippingOptionIsPickup: Integer;
handlingFeeName: WideString;
handlingFeeValue: Integer;
handlingFeeDescription: WideString;
paymentModule: WideString;
additionalInfoGoogle_customer_id: WideString;
acceptMarketing: Integer;
refererId: WideString;
disableAllCustomerNotifications: Integer;
externalFulfillment: Integer;
pricesIncludeTax: Integer;
j: Integer;
count_j: Integer;
value: Integer;
v_type: WideString;
base: WideString;
orderTotal: Integer;
id_int: Integer;
productId: Integer;
categoryId: Integer;
price: Integer;
productPrice: Integer;
sku: WideString;
quantity: Integer;
shortDescription: WideString;
shipping: Integer;
quantityInStock: Integer;
name: WideString;
isShippingRequired: Integer;
weight: Integer;
trackQuantity: Integer;
fixedShippingRateOnly: Integer;
imageUrl: WideString;
smallThumbnailUrl: WideString;
hdThumbnailUrl: WideString;
fixedShippingRate: Integer;
digital: Integer;
couponApplied: Integer;
dimensionsLength: Integer;
dimensionsWidth: Integer;
dimensionsHeight: Integer;
couponAmount: WideString;
subscriptionId: Integer;
recurringChargeSettingsRecurringInterval: WideString;
recurringChargeSettingsRecurringIntervalCount: Integer;
k: Integer;
count_k: Integer;
value_str: WideString;
json1: TChilkatJsonObject;
i1: Integer;
count_i1: Integer;
strVal: WideString;
selectionTitle: WideString;
selectionModifier: Integer;
selectionModifierType: WideString;
taxOnDiscountedSubtotal: WideString;
taxOnShipping: Integer;
includeInPrice: Integer;
discountInfoValue: Integer;
discountInfoType: WideString;
discountInfoBase: WideString;
discountInfoOrderTotal: Integer;
date: WideString;
source: WideString;
reason: WideString;
amount: WideString;
length: Integer;
width: Integer;
height: Integer;
weight_str: WideString;
declaredValue: WideString;
created: WideString;
shipToName: WideString;
shipToCompanyName: WideString;
shipToStreet: WideString;
shipToCity: WideString;
shipToCountryCode: WideString;
shipToCountryName: WideString;
shipToPostalCode: WideString;
shipToStateOrProvinceCode: WideString;
shipToStateOrProvinceName: WideString;
shipToPhone: WideString;
shipFromCompanyName: WideString;
shipFromStreet: WideString;
shipFromCity: WideString;
shipFromCountryCode: WideString;
shipFromCountryName: WideString;
shipFromPostalCode: WideString;
shipFromStateOrProvinceCode: WideString;
shipFromStateOrProvinceName: WideString;
shipFromPhone: WideString;
parcelWeight: WideString;
parcelWeightUnit: Integer;
parcelWidth: Integer;
parcelHeight: Integer;
parcelLength: Integer;
parcelDimensionUnit: Integer;
shippingServiceCarrier: Integer;
shippingServiceCarrierName: Integer;
shippingServiceCarrierServiceName: WideString;
shippingServiceCarrierServiceCode: WideString;
trackingTracking_number: WideString;
trackingTracking_url: WideString;
trackingEstimatedDays: Integer;
shippingLabelLabel_url: WideString;
shippingLabelCommercial_invoice_url: WideString;
customerInputType: WideString;
title: WideString;
orderDetailsDisplaySection: WideString;
orderBy: WideString;
total: Integer;
count: Integer;
offset: Integer;
limit: Integer;
i: Integer;
count_i: Integer;
begin
success := 0;
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
http := TChilkatHttp.Create(Self);
// 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
jsonToken := TChilkatJsonObject.Create(Self);
jsonToken.LoadFile('qa_data/tokens/ecwid.json');
http.SetRequestHeader('Accept','application/json');
params := TChilkatJsonObject.Create(Self);
params.UpdateInt('limit',100);
params.UpdateString('email','joe@example.com');
params.UpdateString('token',jsonToken.StringOf('access_token'));
resp := TChilkatHttpResponse.Create(Self);
success := http.HttpParams('GET','https://app.ecwid.com/api/v3/storeId/orders',params.ControlInterface,resp.ControlInterface);
if (success = 0) then
begin
Memo1.Lines.Add(http.LastErrorText);
Exit;
end;
sbResponseBody := TChilkatStringBuilder.Create(Self);
resp.GetBodySb(sbResponseBody.ControlInterface);
jResp := TChilkatJsonObject.Create(Self);
jResp.LoadSb(sbResponseBody.ControlInterface);
jResp.EmitCompact := 0;
Memo1.Lines.Add('Response Body:');
Memo1.Lines.Add(jResp.Emit());
respStatusCode := resp.StatusCode;
Memo1.Lines.Add('Response Status Code = ' + IntToStr(respStatusCode));
if (respStatusCode <> 200) then
begin
Memo1.Lines.Add('Failed.');
Exit;
end;
// 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
json1 := TChilkatJsonObject.Create(Self);
total := jResp.IntOf('total');
count := jResp.IntOf('count');
offset := jResp.IntOf('offset');
limit := jResp.IntOf('limit');
i := 0;
count_i := jResp.SizeOfArray('items');
while i < count_i do
begin
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 do
begin
jResp.J := j;
j := j + 1;
end;
j := 0;
count_j := jResp.SizeOfArray('items[i].discountInfo');
while j < count_j do
begin
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;
end;
j := 0;
count_j := jResp.SizeOfArray('items[i].items');
while j < count_j do
begin
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 do
begin
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.ControlInterface);
i1 := 0;
count_i1 := json1.SizeOfArray('valuesArray');
while i1 < count_i1 do
begin
json1.I := i1;
strVal := json1.StringOf('valuesArray[i]');
i1 := i1 + 1;
end;
jResp.ObjectOf2('items[i].items[j].selectedOptions[k]',json1.ControlInterface);
i1 := 0;
count_i1 := json1.SizeOfArray('selections');
while i1 < count_i1 do
begin
json1.I := i1;
selectionTitle := json1.StringOf('selections[i].selectionTitle');
selectionModifier := json1.IntOf('selections[i].selectionModifier');
selectionModifierType := json1.StringOf('selections[i].selectionModifierType');
i1 := i1 + 1;
end;
k := k + 1;
end;
k := 0;
count_k := jResp.SizeOfArray('items[i].items[j].taxes');
while k < count_k do
begin
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;
end;
k := 0;
count_k := jResp.SizeOfArray('items[i].items[j].discounts');
while k < count_k do
begin
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;
end;
j := j + 1;
end;
j := 0;
count_j := jResp.SizeOfArray('items[i].refunds');
while j < count_j do
begin
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;
end;
j := 0;
count_j := jResp.SizeOfArray('items[i].predictedPackage');
while j < count_j do
begin
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;
end;
j := 0;
count_j := jResp.SizeOfArray('items[i].shipments');
while j < count_j do
begin
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;
end;
j := 0;
count_j := jResp.SizeOfArray('items[i].taxesOnShipping');
while j < count_j do
begin
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;
end;
j := 0;
count_j := jResp.SizeOfArray('items[i].orderExtraFields');
while j < count_j do
begin
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;
end;
i := i + 1;
end;
end;