(C#) Shopify Get all products that belong to a certain collection

Get all products that belong to a certain collection

Chilkat .NET Downloads Chilkat .NET Framework Chilkat for .NET Core

Chilkat.Rest rest = new Chilkat.Rest();
bool success;

rest.SetAuthBasic("SHOPIFY_PRIVATE_API_KEY","SHOPIFY_PRIVATE_API_KEY");

success = rest.Connect("chilkat.myshopify.com",443,true,true);
if (success != true) {
    Debug.WriteLine(rest.LastErrorText);
    return;
}

Chilkat.StringBuilder sbJson = new Chilkat.StringBuilder();
success = rest.FullRequestNoBodySb("GET","/admin/products.json?collection_id=841564295",sbJson);
if (success != true) {
    Debug.WriteLine(rest.LastErrorText);
    return;
}

if (rest.ResponseStatusCode != 200) {
    Debug.WriteLine("Received error response code: " + Convert.ToString(rest.ResponseStatusCode));
    Debug.WriteLine("Response body:");
    Debug.WriteLine(sbJson.GetAsString());
    return;
}

Chilkat.JsonObject json = new Chilkat.JsonObject();
json.LoadSb(sbJson);

// The following code parses the JSON response.
// A sample JSON response is shown below the sample code.
int i;
int count_i;
int id;
string title;
string body_html;
string vendor;
string product_type;
string created_at;
string handle;
string updated_at;
string published_at;
bool template_suffix;
string published_scope;
string tags;
int imageId;
int imageProduct_id;
int imagePosition;
string imageCreated_at;
string imageUpdated_at;
int imageWidth;
int imageHeight;
string imageSrc;
int j;
int count_j;
int product_id;
string price;
string sku;
int position;
int grams;
string inventory_policy;
bool compare_at_price;
string fulfillment_service;
string inventory_management;
string option1;
bool option2;
bool option3;
bool taxable;
string barcode;
int image_id;
int inventory_quantity;
int weight;
string weight_unit;
int old_inventory_quantity;
bool requires_shipping;
string name;
int k;
int count_k;
string strVal;
int width;
int height;
string src;
int intVal;

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": [
//         ]
//       }
//     }
//   ]
// }

Debug.WriteLine("Example Completed.");