(PHP ActiveX) Shopify Get all products that belong to a certain collection

Get all products that belong to a certain collection

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows Note: The php_com_dotnet.dll may need to be enabled inside of php.ini.

<?php

// For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.Rest')
$rest = new COM("Chilkat.Rest");

$rest->SetAuthBasic('SHOPIFY_PRIVATE_API_KEY','SHOPIFY_PRIVATE_API_KEY');

$success = $rest->Connect('chilkat.myshopify.com',443,1,1);
if ($success != 1) {
    print $rest->LastErrorText . "\n";
    exit;
}

// For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.StringBuilder')
$sbJson = new COM("Chilkat.StringBuilder");
$success = $rest->FullRequestNoBodySb('GET','/admin/products.json?collection_id=841564295',$sbJson);
if ($success != 1) {
    print $rest->LastErrorText . "\n";
    exit;
}

if ($rest->ResponseStatusCode != 200) {
    print 'Received error response code: ' . $rest->ResponseStatusCode . "\n";
    print 'Response body:' . "\n";
    print $sbJson->getAsString() . "\n";
    exit;
}

// For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.JsonObject')
$json = new COM("Chilkat.JsonObject");
$json->LoadSb($sbJson);

// The following code parses the JSON response.
// A sample JSON response is shown below the sample code.

$i = 0;
$count_i = $json->SizeOfArray('products');
while ($i < $count_i) {
    $json->I = $i;
    $id = $json->IntOf('products[i].id');
    $title = $json->stringOf('products[i].title');
    $body_html = $json->stringOf('products[i].body_html');
    $vendor = $json->stringOf('products[i].vendor');
    $product_type = $json->stringOf('products[i].product_type');
    $created_at = $json->stringOf('products[i].created_at');
    $handle = $json->stringOf('products[i].handle');
    $updated_at = $json->stringOf('products[i].updated_at');
    $published_at = $json->stringOf('products[i].published_at');
    $template_suffix = $json->IsNullOf('products[i].template_suffix');
    $published_scope = $json->stringOf('products[i].published_scope');
    $tags = $json->stringOf('products[i].tags');
    $imageId = $json->IntOf('products[i].image.id');
    $imageProduct_id = $json->IntOf('products[i].image.product_id');
    $imagePosition = $json->IntOf('products[i].image.position');
    $imageCreated_at = $json->stringOf('products[i].image.created_at');
    $imageUpdated_at = $json->stringOf('products[i].image.updated_at');
    $imageWidth = $json->IntOf('products[i].image.width');
    $imageHeight = $json->IntOf('products[i].image.height');
    $imageSrc = $json->stringOf('products[i].image.src');
    $j = 0;
    $count_j = $json->SizeOfArray('products[i].variants');
    while ($j < $count_j) {
        $json->J = $j;
        $id = $json->IntOf('products[i].variants[j].id');
        $product_id = $json->IntOf('products[i].variants[j].product_id');
        $title = $json->stringOf('products[i].variants[j].title');
        $price = $json->stringOf('products[i].variants[j].price');
        $sku = $json->stringOf('products[i].variants[j].sku');
        $position = $json->IntOf('products[i].variants[j].position');
        $grams = $json->IntOf('products[i].variants[j].grams');
        $inventory_policy = $json->stringOf('products[i].variants[j].inventory_policy');
        $compare_at_price = $json->IsNullOf('products[i].variants[j].compare_at_price');
        $fulfillment_service = $json->stringOf('products[i].variants[j].fulfillment_service');
        $inventory_management = $json->stringOf('products[i].variants[j].inventory_management');
        $option1 = $json->stringOf('products[i].variants[j].option1');
        $option2 = $json->IsNullOf('products[i].variants[j].option2');
        $option3 = $json->IsNullOf('products[i].variants[j].option3');
        $created_at = $json->stringOf('products[i].variants[j].created_at');
        $updated_at = $json->stringOf('products[i].variants[j].updated_at');
        $taxable = $json->BoolOf('products[i].variants[j].taxable');
        $barcode = $json->stringOf('products[i].variants[j].barcode');
        $image_id = $json->IntOf('products[i].variants[j].image_id');
        $inventory_quantity = $json->IntOf('products[i].variants[j].inventory_quantity');
        $weight = $json->IntOf('products[i].variants[j].weight');
        $weight_unit = $json->stringOf('products[i].variants[j].weight_unit');
        $old_inventory_quantity = $json->IntOf('products[i].variants[j].old_inventory_quantity');
        $requires_shipping = $json->BoolOf('products[i].variants[j].requires_shipping');
        $j = $j + 1;
    }

    $j = 0;
    $count_j = $json->SizeOfArray('products[i].options');
    while ($j < $count_j) {
        $json->J = $j;
        $id = $json->IntOf('products[i].options[j].id');
        $product_id = $json->IntOf('products[i].options[j].product_id');
        $name = $json->stringOf('products[i].options[j].name');
        $position = $json->IntOf('products[i].options[j].position');
        $k = 0;
        $count_k = $json->SizeOfArray('products[i].options[j].values');
        while ($k < $count_k) {
            $json->K = $k;
            $strVal = $json->stringOf('products[i].options[j].values[k]');
            $k = $k + 1;
        }

        $j = $j + 1;
    }

    $j = 0;
    $count_j = $json->SizeOfArray('products[i].images');
    while ($j < $count_j) {
        $json->J = $j;
        $id = $json->IntOf('products[i].images[j].id');
        $product_id = $json->IntOf('products[i].images[j].product_id');
        $position = $json->IntOf('products[i].images[j].position');
        $created_at = $json->stringOf('products[i].images[j].created_at');
        $updated_at = $json->stringOf('products[i].images[j].updated_at');
        $width = $json->IntOf('products[i].images[j].width');
        $height = $json->IntOf('products[i].images[j].height');
        $src = $json->stringOf('products[i].images[j].src');
        $k = 0;
        $count_k = $json->SizeOfArray('products[i].images[j].variant_ids');
        while ($k < $count_k) {
            $json->K = $k;
            $intVal = $json->IntOf('products[i].images[j].variant_ids[k]');
            $k = $k + 1;
        }

        $j = $j + 1;
    }

    $j = 0;
    $count_j = $json->SizeOfArray('products[i].image.variant_ids');
    while ($j < $count_j) {
        $json->J = $j;
        $j = $j + 1;
    }

    $i = $i + 1;
}

// A sample JSON response body that is parsed by the above code:

// {
//   "products": [
//     {
//       "id": 632910392,
//       "title": "IPod Nano - 8GB",
//       "body_html": "<p>It's the small iPod with one very big idea: Video. Now the world's most popular music player, available in 4GB and 8GB models, lets you enjoy TV shows, movies, video podcasts, and more. The larger, brighter display means amazing picture quality. In six eye-catching colors, iPod nano is stunning all around. And with models starting at just $149, little speaks volumes.<\/p>",
//       "vendor": "Apple",
//       "product_type": "Cult Products",
//       "created_at": "2017-09-22T14:08:02-04:00",
//       "handle": "ipod-nano",
//       "updated_at": "2017-09-22T14:08:02-04:00",
//       "published_at": "2007-12-31T19:00:00-05:00",
//       "template_suffix": null,
//       "published_scope": "web",
//       "tags": "Emotive, Flash Memory, MP3, Music",
//       "variants": [
//         {
//           "id": 808950810,
//           "product_id": 632910392,
//           "title": "Pink",
//           "price": "199.00",
//           "sku": "IPOD2008PINK",
//           "position": 1,
//           "grams": 567,
//           "inventory_policy": "continue",
//           "compare_at_price": null,
//           "fulfillment_service": "manual",
//           "inventory_management": "shopify",
//           "option1": "Pink",
//           "option2": null,
//           "option3": null,
//           "created_at": "2017-09-22T14:08:02-04:00",
//           "updated_at": "2017-09-22T14:08:02-04:00",
//           "taxable": true,
//           "barcode": "1234_pink",
//           "image_id": 562641783,
//           "inventory_quantity": 10,
//           "weight": 1.25,
//           "weight_unit": "lb",
//           "old_inventory_quantity": 10,
//           "requires_shipping": true
//         },
//         {
//           "id": 49148385,
//           "product_id": 632910392,
//           "title": "Red",
//           "price": "199.00",
//           "sku": "IPOD2008RED",
//           "position": 2,
//           "grams": 567,
//           "inventory_policy": "continue",
//           "compare_at_price": null,
//           "fulfillment_service": "manual",
//           "inventory_management": "shopify",
//           "option1": "Red",
//           "option2": null,
//           "option3": null,
//           "created_at": "2017-09-22T14:08:02-04:00",
//           "updated_at": "2017-09-22T14:08:02-04:00",
//           "taxable": true,
//           "barcode": "1234_red",
//           "image_id": null,
//           "inventory_quantity": 20,
//           "weight": 1.25,
//           "weight_unit": "lb",
//           "old_inventory_quantity": 20,
//           "requires_shipping": true
//         },
//         {
//           "id": 39072856,
//           "product_id": 632910392,
//           "title": "Green",
//           "price": "199.00",
//           "sku": "IPOD2008GREEN",
//           "position": 3,
//           "grams": 567,
//           "inventory_policy": "continue",
//           "compare_at_price": null,
//           "fulfillment_service": "manual",
//           "inventory_management": "shopify",
//           "option1": "Green",
//           "option2": null,
//           "option3": null,
//           "created_at": "2017-09-22T14:08:02-04:00",
//           "updated_at": "2017-09-22T14:08:02-04:00",
//           "taxable": true,
//           "barcode": "1234_green",
//           "image_id": null,
//           "inventory_quantity": 30,
//           "weight": 1.25,
//           "weight_unit": "lb",
//           "old_inventory_quantity": 30,
//           "requires_shipping": true
//         },
//         {
//           "id": 457924702,
//           "product_id": 632910392,
//           "title": "Black",
//           "price": "199.00",
//           "sku": "IPOD2008BLACK",
//           "position": 4,
//           "grams": 567,
//           "inventory_policy": "continue",
//           "compare_at_price": null,
//           "fulfillment_service": "manual",
//           "inventory_management": "shopify",
//           "option1": "Black",
//           "option2": null,
//           "option3": null,
//           "created_at": "2017-09-22T14:08:02-04:00",
//           "updated_at": "2017-09-22T14:08:02-04:00",
//           "taxable": true,
//           "barcode": "1234_black",
//           "image_id": null,
//           "inventory_quantity": 40,
//           "weight": 1.25,
//           "weight_unit": "lb",
//           "old_inventory_quantity": 40,
//           "requires_shipping": true
//         }
//       ],
//       "options": [
//         {
//           "id": 594680422,
//           "product_id": 632910392,
//           "name": "Color",
//           "position": 1,
//           "values": [
//             "Pink",
//             "Red",
//             "Green",
//             "Black"
//           ]
//         }
//       ],
//       "images": [
//         {
//           "id": 850703190,
//           "product_id": 632910392,
//           "position": 1,
//           "created_at": "2017-09-22T14:08:02-04:00",
//           "updated_at": "2017-09-22T14:08:02-04:00",
//           "width": 123,
//           "height": 456,
//           "src": "https:\/\/cdn.shopify.com\/s\/files\/1\/0006\/9093\/3842\/products\/ipod-nano.png?v=1506103682",
//           "variant_ids": [
//           ]
//         },
//         {
//           "id": 562641783,
//           "product_id": 632910392,
//           "position": 2,
//           "created_at": "2017-09-22T14:08:02-04:00",
//           "updated_at": "2017-09-22T14:08:02-04:00",
//           "width": 123,
//           "height": 456,
//           "src": "https:\/\/cdn.shopify.com\/s\/files\/1\/0006\/9093\/3842\/products\/ipod-nano-2.png?v=1506103682",
//           "variant_ids": [
//             808950810
//           ]
//         }
//       ],
//       "image": {
//         "id": 850703190,
//         "product_id": 632910392,
//         "position": 1,
//         "created_at": "2017-09-22T14:08:02-04:00",
//         "updated_at": "2017-09-22T14:08:02-04:00",
//         "width": 123,
//         "height": 456,
//         "src": "https:\/\/cdn.shopify.com\/s\/files\/1\/0006\/9093\/3842\/products\/ipod-nano.png?v=1506103682",
//         "variant_ids": [
//         ]
//       }
//     }
//   ]
// }

print 'Example Completed.' . "\n";

?>