(CkPython) 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 Python Downloads install with pip pip3 install chilkat or download... Python Module for Windows, MacOS, Linux, Alpine Linux, Solaris

import sys
import chilkat

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

http = chilkat.CkHttp()

# 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()
json.UpdateBool("includeVariants",True)

http.put_AuthToken("ACCESS_TOKEN")
http.SetRequestHeader("Content-Type","application/json")

# resp is a CkHttpResponse
resp = http.PostJson3("https://www.wixapis.com/stores/v1/products/query","application/json",json)
if (http.get_LastMethodSuccess() == False):
    print(http.lastErrorText())
    sys.exit()

sbResponseBody = chilkat.CkStringBuilder()
resp.GetBodySb(sbResponseBody)
jResp = chilkat.CkJsonObject()
jResp.LoadSb(sbResponseBody)
jResp.put_EmitCompact(False)

print("Response Body:")
print(jResp.emit())

respStatusCode = resp.get_StatusCode()
print("Response Status Code = " + str(respStatusCode))
if (respStatusCode >= 400):
    print("Response Header:")
    print(resp.header())
    print("Failed.")

    sys.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