Sample code for 30+ languages & platforms
Perl Requires Chilkat v11.0.0+

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 Perl Downloads

Perl
use chilkat();

$success = 0;

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

$http = chilkat::CkHttp->new();

#  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 = chilkat::CkJsonObject->new();
$jsonToken->LoadFile("qa_data/tokens/ecwid.json");

$http->SetRequestHeader("Accept","application/json");

$params = chilkat::CkJsonObject->new();
$params->UpdateInt("limit",100);
$params->UpdateString("email",'joe@example.com');
$params->UpdateString("token",$jsonToken->stringOf("access_token"));

$resp = chilkat::CkHttpResponse->new();
$success = $http->HttpParams("GET","https://app.ecwid.com/api/v3/storeId/orders",$params,$resp);
if ($success == 0) {
    print $http->lastErrorText() . "\r\n";
    exit;
}

$sbResponseBody = chilkat::CkStringBuilder->new();
$resp->GetBodySb($sbResponseBody);
$jResp = chilkat::CkJsonObject->new();
$jResp->LoadSb($sbResponseBody);
$jResp->put_EmitCompact(0);

print "Response Body:" . "\r\n";
print $jResp->emit() . "\r\n";

$respStatusCode = $resp->get_StatusCode();

print "Response Status Code = " . $respStatusCode . "\r\n";
if ($respStatusCode != 200) {
    print "Failed." . "\r\n";
    exit;
}

#  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 = chilkat::CkJsonObject->new();

$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) {
    $jResp->put_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->put_J($j);
        $j = $j + 1;
    }

    $j = 0;
    $count_j = $jResp->SizeOfArray("items[i].discountInfo");
    while ($j < $count_j) {
        $jResp->put_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->put_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->put_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->put_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->put_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->put_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->put_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->put_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->put_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->put_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->put_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->put_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;
}