(C#) 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 .NET Downloads Chilkat .NET Framework Chilkat for .NET Core

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

Chilkat.Http http = new Chilkat.Http();
bool success;

// Implements the following CURL command:

// curl -X POST -H "Content-Type: application/json" \
//    -d '{
//   "includeVariants": true
//   }' https://www.wixapis.com/stores/v1/products/query

Chilkat.JsonObject json = new Chilkat.JsonObject();
json.UpdateBool("includeVariants",true);

http.AuthToken = "ACCESS_TOKEN";
http.SetRequestHeader("Content-Type","application/json");

Chilkat.HttpResponse resp = http.PostJson3("https://www.wixapis.com/stores/v1/products/query","application/json",json);
if (http.LastMethodSuccess == false) {
    Debug.WriteLine(http.LastErrorText);
    return;
}

Chilkat.StringBuilder sbResponseBody = new Chilkat.StringBuilder();
resp.GetBodySb(sbResponseBody);
Chilkat.JsonObject jResp = new Chilkat.JsonObject();
jResp.LoadSb(sbResponseBody);
jResp.EmitCompact = false;

Debug.WriteLine("Response Body:");
Debug.WriteLine(jResp.Emit());

int respStatusCode = resp.StatusCode;
Debug.WriteLine("Response Status Code = " + Convert.ToString(respStatusCode));
if (respStatusCode >= 400) {
    Debug.WriteLine("Response Header:");
    Debug.WriteLine(resp.Header);
    Debug.WriteLine("Failed.");

    return;
}

// 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

string id;
string name;
string slug;
bool visible;
string productType;
string description;
bool stockTrackInventory;
int stockQuantity;
bool stockInStock;
string priceCurrency;
int pricePrice;
int priceDiscountedPrice;
string priceFormattedPrice;
string priceFormattedDiscountedPrice;
string priceDataCurrency;
int priceDataPrice;
int priceDataDiscountedPrice;
string priceDataFormattedPrice;
string priceDataFormattedDiscountedPrice;
bool manageVariants;
string productPageUrlBase;
string productPageUrlPath;
string numericId;
string inventoryItemId;
string discountType;
int discountValue;
string sku;
int weight;
int j;
int count_j;
string text;
string strVal;

int metadataItems = jResp.IntOf("metadata.items");
int metadataOffset = jResp.IntOf("metadata.offset");
int totalResults = jResp.IntOf("totalResults");
int i = 0;
int count_i = jResp.SizeOfArray("products");
while (i < count_i) {
    jResp.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.J = j;
        j = j + 1;
    }

    j = 0;
    count_j = jResp.SizeOfArray("products[i].ribbons");
    while (j < count_j) {
        jResp.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.J = j;
        j = j + 1;
    }

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

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

    j = 0;
    count_j = jResp.SizeOfArray("products[i].collectionIds");
    while (j < count_j) {
        jResp.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.J = j;
        j = j + 1;
    }

    i = i + 1;
}