(Perl) WiX - Get all Products in a Store

Gets the first page of products in a store.

For more information, see https://dev.wix.com/api/rest/wix-stores/catalog/filter-and-sort

Chilkat Perl Downloads Perl Module for Windows, MacOS, Linux, Alpine Linux, Solaris

use chilkat();

# 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 -X POST -H "Content-Type: application/json" \
#    -d '{
#   "includeVariants": true
#   }' https://www.wixapis.com/stores/v1/products/query

$json = chilkat::CkJsonObject->new();
$json->UpdateBool("includeVariants",1);

$http->put_AuthToken("ACCESS_TOKEN");
$http->SetRequestHeader("Content-Type","application/json");

# resp is a HttpResponse
$resp = $http->PostJson3("https://www.wixapis.com/stores/v1/products/query","application/json",$json);
if ($http->get_LastMethodSuccess() == 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 >= 400) {
    print "Response Header:" . "\r\n";
    print $resp->header() . "\r\n";
    print "Failed." . "\r\n";

    exit;
}

# Sample JSON response:
# (Sample code for parsing the JSON response is shown below)

# {
#   "products": [
#     {
#       "id": "58fcbb51-ff87-08ff-d97b-646726676e4a",
#       "name": "webhook test",
#       "slug": "webhook-test",
#       "visible": true,
#       "productType": "physical",
#       "description": "<p>fasdf<\/p>",
#       "stock": {
#         "trackInventory": true,
#         "quantity": 0,
#         "inStock": false
#       },
#       "price": {
#         "currency": "ILS",
#         "price": 234,
#         "discountedPrice": 234,
#         "formatted": {
#           "price": "234.00 ",
#           "discountedPrice": "234.00 "
#         }
#       },
#       "priceData": {
#         "currency": "ILS",
#         "price": 234,
#         "discountedPrice": 234,
#         "formatted": {
#           "price": "234.00 ",
#           "discountedPrice": "234.00 "
#         }
#       },
#       "additionalInfoSections": [
#       ],
#       "ribbons": [
#         {
#           "text": "ribby"
#         }
#       ],
#       "media": {
#         "items": [
#         ]
#       },
#       "customTextFields": [
#       ],
#       "manageVariants": true,
#       "productOptions": [
#       ],
#       "productPageUrl": {
#         "base": "https://www.my-website.com/",
#         "path": "/product-page/webhook-test"
#       },
#       "numericId": "1567078000586000",
#       "inventoryItemId": "a70344ae-0078-f700-2684-9b98d99891b5",
#       "discount": {
#         "type": "NONE",
#         "value": 0
#       },
#       "collectionIds": [
#       ],
#       "variants": [
#       ]
#     },
#     {
#       "id": "6507fd67-94e5-10af-73e4-d2167852d5bc",
#       "name": "digital product",
#       "slug": "digital-product",
#       "visible": true,
#       "productType": "digital",
#       "description": "",
#       "sku": "",
#       "weight": 0,
#       "stock": {
#         "trackInventory": false,
#         "inStock": true
#       },
#       "price": {
#         "currency": "ILS",
#         "price": 123,
#         "discountedPrice": 123,
#         "formatted": {
#           "price": "123.00 ",
#           "discountedPrice": "123.00 "
#         }
#       },
#       "priceData": {
#         "currency": "ILS",
#         "price": 123,
#         "discountedPrice": 123,
#         "formatted": {
#           "price": "123.00 ",
#           "discountedPrice": "123.00 "
#         }
#       },
#       "additionalInfoSections": [
#       ],
#       "ribbons": [
#       ],
#       "media": {
#         "items": [
#         ]
#       },
#       "customTextFields": [
#       ],
#       "manageVariants": false,
#       "productOptions": [
#       ],
#       "productPageUrl": {
#         "base": "https://www.my-website.com/",
#         "path": "/product-page/digital-product"
#       },
#       "numericId": "1544009414325000",
#       "inventoryItemId": "9af80298-6b1a-ef50-8c1b-2de987ad2a43",
#       "discount": {
#         "type": "NONE",
#         "value": 0
#       },
#       "collectionIds": [
#         "ae886d55-2572-eee8-b2c4-13219844b5e4"
#       ],
#       "variants": [
#       ]
#     }
#   ],
#   "metadata": {
#     "items": 100,
#     "offset": 0
#   },
#   "totalResults": 2
# }

# Sample code for parsing the JSON response...
# Use the following online tool to generate parsing code from sample JSON:
# Generate Parsing Code from JSON

$metadataItems = $jResp->IntOf("metadata.items");
$metadataOffset = $jResp->IntOf("metadata.offset");
$totalResults = $jResp->IntOf("totalResults");
$i = 0;
$count_i = $jResp->SizeOfArray("products");
while ($i < $count_i) {
    $jResp->put_I($i);
    $id = $jResp->stringOf("products[i].id");
    $name = $jResp->stringOf("products[i].name");
    $slug = $jResp->stringOf("products[i].slug");
    $visible = $jResp->BoolOf("products[i].visible");
    $productType = $jResp->stringOf("products[i].productType");
    $description = $jResp->stringOf("products[i].description");
    $stockTrackInventory = $jResp->BoolOf("products[i].stock.trackInventory");
    $stockQuantity = $jResp->IntOf("products[i].stock.quantity");
    $stockInStock = $jResp->BoolOf("products[i].stock.inStock");
    $priceCurrency = $jResp->stringOf("products[i].price.currency");
    $pricePrice = $jResp->IntOf("products[i].price.price");
    $priceDiscountedPrice = $jResp->IntOf("products[i].price.discountedPrice");
    $priceFormattedPrice = $jResp->stringOf("products[i].price.formatted.price");
    $priceFormattedDiscountedPrice = $jResp->stringOf("products[i].price.formatted.discountedPrice");
    $priceDataCurrency = $jResp->stringOf("products[i].priceData.currency");
    $priceDataPrice = $jResp->IntOf("products[i].priceData.price");
    $priceDataDiscountedPrice = $jResp->IntOf("products[i].priceData.discountedPrice");
    $priceDataFormattedPrice = $jResp->stringOf("products[i].priceData.formatted.price");
    $priceDataFormattedDiscountedPrice = $jResp->stringOf("products[i].priceData.formatted.discountedPrice");
    $manageVariants = $jResp->BoolOf("products[i].manageVariants");
    $productPageUrlBase = $jResp->stringOf("products[i].productPageUrl.base");
    $productPageUrlPath = $jResp->stringOf("products[i].productPageUrl.path");
    $numericId = $jResp->stringOf("products[i].numericId");
    $inventoryItemId = $jResp->stringOf("products[i].inventoryItemId");
    $discountType = $jResp->stringOf("products[i].discount.type");
    $discountValue = $jResp->IntOf("products[i].discount.value");
    $sku = $jResp->stringOf("products[i].sku");
    $weight = $jResp->IntOf("products[i].weight");
    $j = 0;
    $count_j = $jResp->SizeOfArray("products[i].additionalInfoSections");
    while ($j < $count_j) {
        $jResp->put_J($j);
        $j = $j + 1;
    }

    $j = 0;
    $count_j = $jResp->SizeOfArray("products[i].ribbons");
    while ($j < $count_j) {
        $jResp->put_J($j);
        $text = $jResp->stringOf("products[i].ribbons[j].text");
        $j = $j + 1;
    }

    $j = 0;
    $count_j = $jResp->SizeOfArray("products[i].media.items");
    while ($j < $count_j) {
        $jResp->put_J($j);
        $j = $j + 1;
    }

    $j = 0;
    $count_j = $jResp->SizeOfArray("products[i].customTextFields");
    while ($j < $count_j) {
        $jResp->put_J($j);
        $j = $j + 1;
    }

    $j = 0;
    $count_j = $jResp->SizeOfArray("products[i].productOptions");
    while ($j < $count_j) {
        $jResp->put_J($j);
        $j = $j + 1;
    }

    $j = 0;
    $count_j = $jResp->SizeOfArray("products[i].collectionIds");
    while ($j < $count_j) {
        $jResp->put_J($j);
        $strVal = $jResp->stringOf("products[i].collectionIds[j]");
        $j = $j + 1;
    }

    $j = 0;
    $count_j = $jResp->SizeOfArray("products[i].variants");
    while ($j < $count_j) {
        $jResp->put_J($j);
        $j = $j + 1;
    }

    $i = $i + 1;
}