PureBasic
PureBasic
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 PureBasic Downloads
IncludeFile "CkHttpResponse.pb"
IncludeFile "CkHttp.pb"
IncludeFile "CkStringBuilder.pb"
IncludeFile "CkJsonObject.pb"
Procedure ChilkatExample()
success.i = 0
; This example assumes the Chilkat API to have been previously unlocked.
; See Global Unlock Sample for sample code.
http.i = CkHttp::ckCreate()
If http.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
; 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.i = CkJsonObject::ckCreate()
If jsonToken.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
CkJsonObject::ckLoadFile(jsonToken,"qa_data/tokens/ecwid.json")
CkHttp::ckSetRequestHeader(http,"Accept","application/json")
params.i = CkJsonObject::ckCreate()
If params.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
CkJsonObject::ckUpdateInt(params,"limit",100)
CkJsonObject::ckUpdateString(params,"email","joe@example.com")
CkJsonObject::ckUpdateString(params,"token",CkJsonObject::ckStringOf(jsonToken,"access_token"))
resp.i = CkHttpResponse::ckCreate()
If resp.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
success = CkHttp::ckHttpParams(http,"GET","https://app.ecwid.com/api/v3/storeId/orders",params,resp)
If success = 0
Debug CkHttp::ckLastErrorText(http)
CkHttp::ckDispose(http)
CkJsonObject::ckDispose(jsonToken)
CkJsonObject::ckDispose(params)
CkHttpResponse::ckDispose(resp)
ProcedureReturn
EndIf
sbResponseBody.i = CkStringBuilder::ckCreate()
If sbResponseBody.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
CkHttpResponse::ckGetBodySb(resp,sbResponseBody)
jResp.i = CkJsonObject::ckCreate()
If jResp.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
CkJsonObject::ckLoadSb(jResp,sbResponseBody)
CkJsonObject::setCkEmitCompact(jResp, 0)
Debug "Response Body:"
Debug CkJsonObject::ckEmit(jResp)
respStatusCode.i = CkHttpResponse::ckStatusCode(resp)
Debug "Response Status Code = " + Str(respStatusCode)
If respStatusCode <> 200
Debug "Failed."
CkHttp::ckDispose(http)
CkJsonObject::ckDispose(jsonToken)
CkJsonObject::ckDispose(params)
CkHttpResponse::ckDispose(resp)
CkStringBuilder::ckDispose(sbResponseBody)
CkJsonObject::ckDispose(jResp)
ProcedureReturn
EndIf
; 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
id.s
subtotal.s
total_str.s
giftCardRedemption.s
totalBeforeGiftCardRedemption.s
giftCardDoubleSpending.i
usdTotal.s
tax.s
paymentMethod.s
paymentStatus.s
fulfillmentStatus.s
vendorOrderNumber.s
orderNumber.i
refererUrl.s
globalReferer.s
createDate.s
updateDate.s
createTimestamp.i
updateTimestamp.i
hidden.i
orderComments.s
privateAdminNotes.s
email.s
ipAddress.s
customerId.i
customerGroupId.i
customerGroup.s
customerTaxExempt.i
customerTaxId.s
customerTaxIdValid.i
reversedTaxApplied.i
discount.i
couponDiscount.i
volumeDiscount.i
membershipBasedDiscount.i
totalAndMembershipBasedDiscount.i
discountCouponId.i
discountCouponName.s
discountCouponCode.s
discountCouponDiscountType.s
discountCouponStatus.s
discountCouponDiscount.i
discountCouponLaunchDate.s
discountCouponUsesLimit.s
discountCouponApplicationLimit.s
discountCouponCreationDate.s
discountCouponUpdateDate.s
discountCouponOrderCount.i
refundedAmount.s
billingPersonName.s
billingPersonCompanyName.s
billingPersonStreet.s
billingPersonCity.s
billingPersonCountryCode.s
billingPersonCountryName.s
billingPersonPostalCode.s
billingPersonStateOrProvinceCode.s
billingPersonStateOrProvinceName.s
billingPersonPhone.s
shippingPersonName.s
shippingPersonCompanyName.s
shippingPersonStreet.s
shippingPersonCity.s
shippingPersonCountryCode.s
shippingPersonCountryName.s
shippingPersonPostalCode.s
shippingPersonStateOrProvinceCode.s
shippingPersonStateOrProvinceName.s
shippingPersonPhone.s
shippingOptionShippingCarrierName.s
shippingOptionShippingMethodName.s
shippingOptionShippingRate.s
shippingOptionEstimatedTransitTime.s
shippingOptionIsPickup.i
handlingFeeName.s
handlingFeeValue.i
handlingFeeDescription.s
paymentModule.s
additionalInfoGoogle_customer_id.s
acceptMarketing.i
refererId.s
disableAllCustomerNotifications.i
externalFulfillment.i
pricesIncludeTax.i
j.i
count_j.i
value.i
v_type.s
base.s
orderTotal.i
id_int.i
productId.i
categoryId.i
price.i
productPrice.i
sku.s
quantity.i
shortDescription.s
shipping.i
quantityInStock.i
name.s
isShippingRequired.i
weight.i
trackQuantity.i
fixedShippingRateOnly.i
imageUrl.s
smallThumbnailUrl.s
hdThumbnailUrl.s
fixedShippingRate.i
digital.i
couponApplied.i
dimensionsLength.i
dimensionsWidth.i
dimensionsHeight.i
couponAmount.s
subscriptionId.i
recurringChargeSettingsRecurringInterval.s
recurringChargeSettingsRecurringIntervalCount.i
k.i
count_k.i
value_str.s
json1.i = CkJsonObject::ckCreate()
If json1.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
i1.i
count_i1.i
strVal.s
selectionTitle.s
selectionModifier.i
selectionModifierType.s
taxOnDiscountedSubtotal.s
taxOnShipping.i
includeInPrice.i
discountInfoValue.i
discountInfoType.s
discountInfoBase.s
discountInfoOrderTotal.i
date.s
source.s
reason.s
amount.s
length.i
width.i
height.i
weight_str.s
declaredValue.s
created.s
shipToName.s
shipToCompanyName.s
shipToStreet.s
shipToCity.s
shipToCountryCode.s
shipToCountryName.s
shipToPostalCode.s
shipToStateOrProvinceCode.s
shipToStateOrProvinceName.s
shipToPhone.s
shipFromCompanyName.s
shipFromStreet.s
shipFromCity.s
shipFromCountryCode.s
shipFromCountryName.s
shipFromPostalCode.s
shipFromStateOrProvinceCode.s
shipFromStateOrProvinceName.s
shipFromPhone.s
parcelWeight.s
parcelWeightUnit.i
parcelWidth.i
parcelHeight.i
parcelLength.i
parcelDimensionUnit.i
shippingServiceCarrier.i
shippingServiceCarrierName.i
shippingServiceCarrierServiceName.s
shippingServiceCarrierServiceCode.s
trackingTracking_number.s
trackingTracking_url.s
trackingEstimatedDays.i
shippingLabelLabel_url.s
shippingLabelCommercial_invoice_url.s
customerInputType.s
title.s
orderDetailsDisplaySection.s
orderBy.s
total.i = CkJsonObject::ckIntOf(jResp,"total")
count.i = CkJsonObject::ckIntOf(jResp,"count")
offset.i = CkJsonObject::ckIntOf(jResp,"offset")
limit.i = CkJsonObject::ckIntOf(jResp,"limit")
i.i = 0
count_i.i = CkJsonObject::ckSizeOfArray(jResp,"items")
While i < count_i
CkJsonObject::setCkI(jResp, i)
id = CkJsonObject::ckStringOf(jResp,"items[i].id")
subtotal = CkJsonObject::ckStringOf(jResp,"items[i].subtotal")
total_str = CkJsonObject::ckStringOf(jResp,"items[i].total")
giftCardRedemption = CkJsonObject::ckStringOf(jResp,"items[i].giftCardRedemption")
totalBeforeGiftCardRedemption = CkJsonObject::ckStringOf(jResp,"items[i].totalBeforeGiftCardRedemption")
giftCardDoubleSpending = CkJsonObject::ckBoolOf(jResp,"items[i].giftCardDoubleSpending")
usdTotal = CkJsonObject::ckStringOf(jResp,"items[i].usdTotal")
tax = CkJsonObject::ckStringOf(jResp,"items[i].tax")
paymentMethod = CkJsonObject::ckStringOf(jResp,"items[i].paymentMethod")
paymentStatus = CkJsonObject::ckStringOf(jResp,"items[i].paymentStatus")
fulfillmentStatus = CkJsonObject::ckStringOf(jResp,"items[i].fulfillmentStatus")
vendorOrderNumber = CkJsonObject::ckStringOf(jResp,"items[i].vendorOrderNumber")
orderNumber = CkJsonObject::ckIntOf(jResp,"items[i].orderNumber")
refererUrl = CkJsonObject::ckStringOf(jResp,"items[i].refererUrl")
globalReferer = CkJsonObject::ckStringOf(jResp,"items[i].globalReferer")
createDate = CkJsonObject::ckStringOf(jResp,"items[i].createDate")
updateDate = CkJsonObject::ckStringOf(jResp,"items[i].updateDate")
createTimestamp = CkJsonObject::ckIntOf(jResp,"items[i].createTimestamp")
updateTimestamp = CkJsonObject::ckIntOf(jResp,"items[i].updateTimestamp")
hidden = CkJsonObject::ckBoolOf(jResp,"items[i].hidden")
orderComments = CkJsonObject::ckStringOf(jResp,"items[i].orderComments")
privateAdminNotes = CkJsonObject::ckStringOf(jResp,"items[i].privateAdminNotes")
email = CkJsonObject::ckStringOf(jResp,"items[i].email")
ipAddress = CkJsonObject::ckStringOf(jResp,"items[i].ipAddress")
customerId = CkJsonObject::ckIntOf(jResp,"items[i].customerId")
customerGroupId = CkJsonObject::ckIntOf(jResp,"items[i].customerGroupId")
customerGroup = CkJsonObject::ckStringOf(jResp,"items[i].customerGroup")
customerTaxExempt = CkJsonObject::ckBoolOf(jResp,"items[i].customerTaxExempt")
customerTaxId = CkJsonObject::ckStringOf(jResp,"items[i].customerTaxId")
customerTaxIdValid = CkJsonObject::ckBoolOf(jResp,"items[i].customerTaxIdValid")
reversedTaxApplied = CkJsonObject::ckBoolOf(jResp,"items[i].reversedTaxApplied")
discount = CkJsonObject::ckIntOf(jResp,"items[i].discount")
couponDiscount = CkJsonObject::ckIntOf(jResp,"items[i].couponDiscount")
volumeDiscount = CkJsonObject::ckIntOf(jResp,"items[i].volumeDiscount")
membershipBasedDiscount = CkJsonObject::ckIntOf(jResp,"items[i].membershipBasedDiscount")
totalAndMembershipBasedDiscount = CkJsonObject::ckIntOf(jResp,"items[i].totalAndMembershipBasedDiscount")
discountCouponId = CkJsonObject::ckIntOf(jResp,"items[i].discountCoupon.id")
discountCouponName = CkJsonObject::ckStringOf(jResp,"items[i].discountCoupon.name")
discountCouponCode = CkJsonObject::ckStringOf(jResp,"items[i].discountCoupon.code")
discountCouponDiscountType = CkJsonObject::ckStringOf(jResp,"items[i].discountCoupon.discountType")
discountCouponStatus = CkJsonObject::ckStringOf(jResp,"items[i].discountCoupon.status")
discountCouponDiscount = CkJsonObject::ckIntOf(jResp,"items[i].discountCoupon.discount")
discountCouponLaunchDate = CkJsonObject::ckStringOf(jResp,"items[i].discountCoupon.launchDate")
discountCouponUsesLimit = CkJsonObject::ckStringOf(jResp,"items[i].discountCoupon.usesLimit")
discountCouponApplicationLimit = CkJsonObject::ckStringOf(jResp,"items[i].discountCoupon.applicationLimit")
discountCouponCreationDate = CkJsonObject::ckStringOf(jResp,"items[i].discountCoupon.creationDate")
discountCouponUpdateDate = CkJsonObject::ckStringOf(jResp,"items[i].discountCoupon.updateDate")
discountCouponOrderCount = CkJsonObject::ckIntOf(jResp,"items[i].discountCoupon.orderCount")
refundedAmount = CkJsonObject::ckStringOf(jResp,"items[i].refundedAmount")
billingPersonName = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.name")
billingPersonCompanyName = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.companyName")
billingPersonStreet = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.street")
billingPersonCity = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.city")
billingPersonCountryCode = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.countryCode")
billingPersonCountryName = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.countryName")
billingPersonPostalCode = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.postalCode")
billingPersonStateOrProvinceCode = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.stateOrProvinceCode")
billingPersonStateOrProvinceName = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.stateOrProvinceName")
billingPersonPhone = CkJsonObject::ckStringOf(jResp,"items[i].billingPerson.phone")
shippingPersonName = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.name")
shippingPersonCompanyName = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.companyName")
shippingPersonStreet = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.street")
shippingPersonCity = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.city")
shippingPersonCountryCode = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.countryCode")
shippingPersonCountryName = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.countryName")
shippingPersonPostalCode = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.postalCode")
shippingPersonStateOrProvinceCode = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.stateOrProvinceCode")
shippingPersonStateOrProvinceName = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.stateOrProvinceName")
shippingPersonPhone = CkJsonObject::ckStringOf(jResp,"items[i].shippingPerson.phone")
shippingOptionShippingCarrierName = CkJsonObject::ckStringOf(jResp,"items[i].shippingOption.shippingCarrierName")
shippingOptionShippingMethodName = CkJsonObject::ckStringOf(jResp,"items[i].shippingOption.shippingMethodName")
shippingOptionShippingRate = CkJsonObject::ckStringOf(jResp,"items[i].shippingOption.shippingRate")
shippingOptionEstimatedTransitTime = CkJsonObject::ckStringOf(jResp,"items[i].shippingOption.estimatedTransitTime")
shippingOptionIsPickup = CkJsonObject::ckBoolOf(jResp,"items[i].shippingOption.isPickup")
handlingFeeName = CkJsonObject::ckStringOf(jResp,"items[i].handlingFee.name")
handlingFeeValue = CkJsonObject::ckIntOf(jResp,"items[i].handlingFee.value")
handlingFeeDescription = CkJsonObject::ckStringOf(jResp,"items[i].handlingFee.description")
paymentModule = CkJsonObject::ckStringOf(jResp,"items[i].paymentModule")
additionalInfoGoogle_customer_id = CkJsonObject::ckStringOf(jResp,"items[i].additionalInfo.google_customer_id")
acceptMarketing = CkJsonObject::ckBoolOf(jResp,"items[i].acceptMarketing")
refererId = CkJsonObject::ckStringOf(jResp,"items[i].refererId")
disableAllCustomerNotifications = CkJsonObject::ckBoolOf(jResp,"items[i].disableAllCustomerNotifications")
externalFulfillment = CkJsonObject::ckBoolOf(jResp,"items[i].externalFulfillment")
pricesIncludeTax = CkJsonObject::ckBoolOf(jResp,"items[i].pricesIncludeTax")
j = 0
count_j = CkJsonObject::ckSizeOfArray(jResp,"items[i].customDiscount")
While j < count_j
CkJsonObject::setCkJ(jResp, j)
j = j + 1
Wend
j = 0
count_j = CkJsonObject::ckSizeOfArray(jResp,"items[i].discountInfo")
While j < count_j
CkJsonObject::setCkJ(jResp, j)
value = CkJsonObject::ckIntOf(jResp,"items[i].discountInfo[j].value")
v_type = CkJsonObject::ckStringOf(jResp,"items[i].discountInfo[j].type")
base = CkJsonObject::ckStringOf(jResp,"items[i].discountInfo[j].base")
orderTotal = CkJsonObject::ckIntOf(jResp,"items[i].discountInfo[j].orderTotal")
j = j + 1
Wend
j = 0
count_j = CkJsonObject::ckSizeOfArray(jResp,"items[i].items")
While j < count_j
CkJsonObject::setCkJ(jResp, j)
id_int = CkJsonObject::ckIntOf(jResp,"items[i].items[j].id")
productId = CkJsonObject::ckIntOf(jResp,"items[i].items[j].productId")
categoryId = CkJsonObject::ckIntOf(jResp,"items[i].items[j].categoryId")
price = CkJsonObject::ckIntOf(jResp,"items[i].items[j].price")
productPrice = CkJsonObject::ckIntOf(jResp,"items[i].items[j].productPrice")
sku = CkJsonObject::ckStringOf(jResp,"items[i].items[j].sku")
quantity = CkJsonObject::ckIntOf(jResp,"items[i].items[j].quantity")
shortDescription = CkJsonObject::ckStringOf(jResp,"items[i].items[j].shortDescription")
tax = CkJsonObject::ckStringOf(jResp,"items[i].items[j].tax")
shipping = CkJsonObject::ckIntOf(jResp,"items[i].items[j].shipping")
quantityInStock = CkJsonObject::ckIntOf(jResp,"items[i].items[j].quantityInStock")
name = CkJsonObject::ckStringOf(jResp,"items[i].items[j].name")
isShippingRequired = CkJsonObject::ckBoolOf(jResp,"items[i].items[j].isShippingRequired")
weight = CkJsonObject::ckIntOf(jResp,"items[i].items[j].weight")
trackQuantity = CkJsonObject::ckBoolOf(jResp,"items[i].items[j].trackQuantity")
fixedShippingRateOnly = CkJsonObject::ckBoolOf(jResp,"items[i].items[j].fixedShippingRateOnly")
imageUrl = CkJsonObject::ckStringOf(jResp,"items[i].items[j].imageUrl")
smallThumbnailUrl = CkJsonObject::ckStringOf(jResp,"items[i].items[j].smallThumbnailUrl")
hdThumbnailUrl = CkJsonObject::ckStringOf(jResp,"items[i].items[j].hdThumbnailUrl")
fixedShippingRate = CkJsonObject::ckIntOf(jResp,"items[i].items[j].fixedShippingRate")
digital = CkJsonObject::ckBoolOf(jResp,"items[i].items[j].digital")
couponApplied = CkJsonObject::ckBoolOf(jResp,"items[i].items[j].couponApplied")
dimensionsLength = CkJsonObject::ckIntOf(jResp,"items[i].items[j].dimensions.length")
dimensionsWidth = CkJsonObject::ckIntOf(jResp,"items[i].items[j].dimensions.width")
dimensionsHeight = CkJsonObject::ckIntOf(jResp,"items[i].items[j].dimensions.height")
couponAmount = CkJsonObject::ckStringOf(jResp,"items[i].items[j].couponAmount")
subscriptionId = CkJsonObject::ckIntOf(jResp,"items[i].items[j].subscriptionId")
recurringChargeSettingsRecurringInterval = CkJsonObject::ckStringOf(jResp,"items[i].items[j].recurringChargeSettings.recurringInterval")
recurringChargeSettingsRecurringIntervalCount = CkJsonObject::ckIntOf(jResp,"items[i].items[j].recurringChargeSettings.recurringIntervalCount")
k = 0
count_k = CkJsonObject::ckSizeOfArray(jResp,"items[i].items[j].selectedOptions")
While k < count_k
CkJsonObject::setCkK(jResp, k)
name = CkJsonObject::ckStringOf(jResp,"items[i].items[j].selectedOptions[k].name")
value_str = CkJsonObject::ckStringOf(jResp,"items[i].items[j].selectedOptions[k].value")
v_type = CkJsonObject::ckStringOf(jResp,"items[i].items[j].selectedOptions[k].type")
CkJsonObject::ckObjectOf2(jResp,"items[i].items[j].selectedOptions[k]",json1)
i1 = 0
count_i1 = CkJsonObject::ckSizeOfArray(json1,"valuesArray")
While i1 < count_i1
CkJsonObject::setCkI(json1, i1)
strVal = CkJsonObject::ckStringOf(json1,"valuesArray[i]")
i1 = i1 + 1
Wend
CkJsonObject::ckObjectOf2(jResp,"items[i].items[j].selectedOptions[k]",json1)
i1 = 0
count_i1 = CkJsonObject::ckSizeOfArray(json1,"selections")
While i1 < count_i1
CkJsonObject::setCkI(json1, i1)
selectionTitle = CkJsonObject::ckStringOf(json1,"selections[i].selectionTitle")
selectionModifier = CkJsonObject::ckIntOf(json1,"selections[i].selectionModifier")
selectionModifierType = CkJsonObject::ckStringOf(json1,"selections[i].selectionModifierType")
i1 = i1 + 1
Wend
k = k + 1
Wend
k = 0
count_k = CkJsonObject::ckSizeOfArray(jResp,"items[i].items[j].taxes")
While k < count_k
CkJsonObject::setCkK(jResp, k)
name = CkJsonObject::ckStringOf(jResp,"items[i].items[j].taxes[k].name")
value = CkJsonObject::ckIntOf(jResp,"items[i].items[j].taxes[k].value")
total_str = CkJsonObject::ckStringOf(jResp,"items[i].items[j].taxes[k].total")
taxOnDiscountedSubtotal = CkJsonObject::ckStringOf(jResp,"items[i].items[j].taxes[k].taxOnDiscountedSubtotal")
taxOnShipping = CkJsonObject::ckIntOf(jResp,"items[i].items[j].taxes[k].taxOnShipping")
includeInPrice = CkJsonObject::ckBoolOf(jResp,"items[i].items[j].taxes[k].includeInPrice")
k = k + 1
Wend
k = 0
count_k = CkJsonObject::ckSizeOfArray(jResp,"items[i].items[j].discounts")
While k < count_k
CkJsonObject::setCkK(jResp, k)
discountInfoValue = CkJsonObject::ckIntOf(jResp,"items[i].items[j].discounts[k].discountInfo.value")
discountInfoType = CkJsonObject::ckStringOf(jResp,"items[i].items[j].discounts[k].discountInfo.type")
discountInfoBase = CkJsonObject::ckStringOf(jResp,"items[i].items[j].discounts[k].discountInfo.base")
discountInfoOrderTotal = CkJsonObject::ckIntOf(jResp,"items[i].items[j].discounts[k].discountInfo.orderTotal")
total_str = CkJsonObject::ckStringOf(jResp,"items[i].items[j].discounts[k].total")
k = k + 1
Wend
j = j + 1
Wend
j = 0
count_j = CkJsonObject::ckSizeOfArray(jResp,"items[i].refunds")
While j < count_j
CkJsonObject::setCkJ(jResp, j)
date = CkJsonObject::ckStringOf(jResp,"items[i].refunds[j].date")
source = CkJsonObject::ckStringOf(jResp,"items[i].refunds[j].source")
reason = CkJsonObject::ckStringOf(jResp,"items[i].refunds[j].reason")
amount = CkJsonObject::ckStringOf(jResp,"items[i].refunds[j].amount")
j = j + 1
Wend
j = 0
count_j = CkJsonObject::ckSizeOfArray(jResp,"items[i].predictedPackage")
While j < count_j
CkJsonObject::setCkJ(jResp, j)
length = CkJsonObject::ckIntOf(jResp,"items[i].predictedPackage[j].length")
width = CkJsonObject::ckIntOf(jResp,"items[i].predictedPackage[j].width")
height = CkJsonObject::ckIntOf(jResp,"items[i].predictedPackage[j].height")
weight_str = CkJsonObject::ckStringOf(jResp,"items[i].predictedPackage[j].weight")
declaredValue = CkJsonObject::ckStringOf(jResp,"items[i].predictedPackage[j].declaredValue")
j = j + 1
Wend
j = 0
count_j = CkJsonObject::ckSizeOfArray(jResp,"items[i].shipments")
While j < count_j
CkJsonObject::setCkJ(jResp, j)
id = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].id")
created = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].created")
shipToName = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.name")
shipToCompanyName = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.companyName")
shipToStreet = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.street")
shipToCity = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.city")
shipToCountryCode = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.countryCode")
shipToCountryName = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.countryName")
shipToPostalCode = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.postalCode")
shipToStateOrProvinceCode = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.stateOrProvinceCode")
shipToStateOrProvinceName = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.stateOrProvinceName")
shipToPhone = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipTo.phone")
shipFromCompanyName = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipFrom.companyName")
shipFromStreet = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipFrom.street")
shipFromCity = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipFrom.city")
shipFromCountryCode = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipFrom.countryCode")
shipFromCountryName = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipFrom.countryName")
shipFromPostalCode = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipFrom.postalCode")
shipFromStateOrProvinceCode = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipFrom.stateOrProvinceCode")
shipFromStateOrProvinceName = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipFrom.stateOrProvinceName")
shipFromPhone = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shipFrom.phone")
parcelWeight = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].parcel.weight")
parcelWeightUnit = CkJsonObject::ckIntOf(jResp,"items[i].shipments[j].parcel.weightUnit")
parcelWidth = CkJsonObject::ckIntOf(jResp,"items[i].shipments[j].parcel.width")
parcelHeight = CkJsonObject::ckIntOf(jResp,"items[i].shipments[j].parcel.height")
parcelLength = CkJsonObject::ckIntOf(jResp,"items[i].shipments[j].parcel.length")
parcelDimensionUnit = CkJsonObject::ckIntOf(jResp,"items[i].shipments[j].parcel.dimensionUnit")
shippingServiceCarrier = CkJsonObject::ckIntOf(jResp,"items[i].shipments[j].shippingService.carrier")
shippingServiceCarrierName = CkJsonObject::ckIntOf(jResp,"items[i].shipments[j].shippingService.carrierName")
shippingServiceCarrierServiceName = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shippingService.carrierServiceName")
shippingServiceCarrierServiceCode = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shippingService.carrierServiceCode")
trackingTracking_number = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].tracking.tracking_number")
trackingTracking_url = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].tracking.tracking_url")
trackingEstimatedDays = CkJsonObject::ckIntOf(jResp,"items[i].shipments[j].tracking.estimatedDays")
shippingLabelLabel_url = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shippingLabel.label_url")
shippingLabelCommercial_invoice_url = CkJsonObject::ckStringOf(jResp,"items[i].shipments[j].shippingLabel.commercial_invoice_url")
j = j + 1
Wend
j = 0
count_j = CkJsonObject::ckSizeOfArray(jResp,"items[i].taxesOnShipping")
While j < count_j
CkJsonObject::setCkJ(jResp, j)
name = CkJsonObject::ckStringOf(jResp,"items[i].taxesOnShipping[j].name")
value = CkJsonObject::ckIntOf(jResp,"items[i].taxesOnShipping[j].value")
total_str = CkJsonObject::ckStringOf(jResp,"items[i].taxesOnShipping[j].total")
j = j + 1
Wend
j = 0
count_j = CkJsonObject::ckSizeOfArray(jResp,"items[i].orderExtraFields")
While j < count_j
CkJsonObject::setCkJ(jResp, j)
id = CkJsonObject::ckStringOf(jResp,"items[i].orderExtraFields[j].id")
value_str = CkJsonObject::ckStringOf(jResp,"items[i].orderExtraFields[j].value")
customerInputType = CkJsonObject::ckStringOf(jResp,"items[i].orderExtraFields[j].customerInputType")
title = CkJsonObject::ckStringOf(jResp,"items[i].orderExtraFields[j].title")
orderDetailsDisplaySection = CkJsonObject::ckStringOf(jResp,"items[i].orderExtraFields[j].orderDetailsDisplaySection")
orderBy = CkJsonObject::ckStringOf(jResp,"items[i].orderExtraFields[j].orderBy")
j = j + 1
Wend
i = i + 1
Wend
CkHttp::ckDispose(http)
CkJsonObject::ckDispose(jsonToken)
CkJsonObject::ckDispose(params)
CkHttpResponse::ckDispose(resp)
CkStringBuilder::ckDispose(sbResponseBody)
CkJsonObject::ckDispose(jResp)
CkJsonObject::ckDispose(json1)
ProcedureReturn
EndProcedure