Tcl
Tcl
WooCommerce List All Products
See more WooCommerce Examples
Gets WooCommerce product information in JSON format.Chilkat Tcl Downloads
load ./chilkat.dll
set success 0
# This example assumes the Chilkat API to have been previously unlocked.
# See Global Unlock Sample for sample code.
set http [new_CkHttp]
# Implements the following CURL command:
# curl https://example.com/wp-json/wc/v3/products \
# -u consumer_key:consumer_secret
# Use the following online tool to generate HTTP code from a CURL command
# Convert a cURL Command to HTTP Source Code
CkHttp_put_BasicAuth $http 1
CkHttp_put_Login $http "consumer_key"
CkHttp_put_Password $http "consumer_secret"
set sbResponseBody [new_CkStringBuilder]
set success [CkHttp_QuickGetSb $http "https://example.com/wp-json/wc/v3/products" $sbResponseBody]
if {$success == 0} then {
puts [CkHttp_lastErrorText $http]
delete_CkHttp $http
delete_CkStringBuilder $sbResponseBody
exit
}
set jarrResp [new_CkJsonArray]
CkJsonArray_LoadSb $jarrResp $sbResponseBody
CkJsonArray_put_EmitCompact $jarrResp 0
puts "Response Body:"
puts [CkJsonArray_emit $jarrResp]
set respStatusCode [CkHttp_get_LastStatus $http]
puts "Response Status Code = $respStatusCode"
if {$respStatusCode >= 400} then {
puts "Response Header:"
puts [CkHttp_lastHeader $http]
puts "Failed."
delete_CkHttp $http
delete_CkStringBuilder $sbResponseBody
delete_CkJsonArray $jarrResp
exit
}
# Sample JSON response:
# (Sample code for parsing the JSON response is shown below)
# [
# {
# "id": 799,
# "name": "Ship Your Idea",
# "slug": "ship-your-idea-22",
# "permalink": "https://example.com/product/ship-your-idea-22/",
# "date_created": "2017-03-23T17:03:12",
# "date_created_gmt": "2017-03-23T20:03:12",
# "date_modified": "2017-03-23T17:03:12",
# "date_modified_gmt": "2017-03-23T20:03:12",
# "type": "variable",
# "status": "publish",
# "featured": false,
# "catalog_visibility": "visible",
# "description": "<p>Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum tortor quam, feugiat vitae, ultricies eget, tempor sit amet, ante. Donec eu libero sit amet quam egestas semper. Aenean ultricies mi vitae est. Mauris placerat eleifend leo.</p>\n",
# "short_description": "<p>Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.</p>\n",
# "sku": "",
# "price": "",
# "regular_price": "",
# "sale_price": "",
# "date_on_sale_from": null,
# "date_on_sale_from_gmt": null,
# "date_on_sale_to": null,
# "date_on_sale_to_gmt": null,
# "price_html": "",
# "on_sale": false,
# "purchasable": false,
# "total_sales": 0,
# "virtual": false,
# "downloadable": false,
# "downloads": [
# ],
# "download_limit": -1,
# "download_expiry": -1,
# "external_url": "",
# "button_text": "",
# "tax_status": "taxable",
# "tax_class": "",
# "manage_stock": false,
# "stock_quantity": null,
# "stock_status": "instock",
# "backorders": "no",
# "backorders_allowed": false,
# "backordered": false,
# "sold_individually": false,
# "weight": "",
# "dimensions": {
# "length": "",
# "width": "",
# "height": ""
# },
# "shipping_required": true,
# "shipping_taxable": true,
# "shipping_class": "",
# "shipping_class_id": 0,
# "reviews_allowed": true,
# "average_rating": "0.00",
# "rating_count": 0,
# "related_ids": [
# 31,
# 22,
# 369,
# 414,
# 56
# ],
# "upsell_ids": [
# ],
# "cross_sell_ids": [
# ],
# "parent_id": 0,
# "purchase_note": "",
# "categories": [
# {
# "id": 9,
# "name": "Clothing",
# "slug": "clothing"
# },
# {
# "id": 14,
# "name": "T-shirts",
# "slug": "t-shirts"
# }
# ],
# "tags": [
# ],
# "images": [
# {
# "id": 795,
# "date_created": "2017-03-23T14:03:08",
# "date_created_gmt": "2017-03-23T20:03:08",
# "date_modified": "2017-03-23T14:03:08",
# "date_modified_gmt": "2017-03-23T20:03:08",
# "src": "https://example.com/wp-content/uploads/2017/03/T_4_front-11.jpg",
# "name": "",
# "alt": ""
# },
# {
# "id": 796,
# "date_created": "2017-03-23T14:03:09",
# "date_created_gmt": "2017-03-23T20:03:09",
# "date_modified": "2017-03-23T14:03:09",
# "date_modified_gmt": "2017-03-23T20:03:09",
# "src": "https://example.com/wp-content/uploads/2017/03/T_4_back-10.jpg",
# "name": "",
# "alt": ""
# },
# {
# "id": 797,
# "date_created": "2017-03-23T14:03:10",
# "date_created_gmt": "2017-03-23T20:03:10",
# "date_modified": "2017-03-23T14:03:10",
# "date_modified_gmt": "2017-03-23T20:03:10",
# "src": "https://example.com/wp-content/uploads/2017/03/T_3_front-10.jpg",
# "name": "",
# "alt": ""
# },
# {
# "id": 798,
# "date_created": "2017-03-23T14:03:11",
# "date_created_gmt": "2017-03-23T20:03:11",
# "date_modified": "2017-03-23T14:03:11",
# "date_modified_gmt": "2017-03-23T20:03:11",
# "src": "https://example.com/wp-content/uploads/2017/03/T_3_back-10.jpg",
# "name": "",
# "alt": ""
# }
# ],
# "attributes": [
# {
# "id": 6,
# "name": "Color",
# "position": 0,
# "visible": false,
# "variation": true,
# "options": [
# "Black",
# "Green"
# ]
# },
# {
# "id": 0,
# "name": "Size",
# "position": 0,
# "visible": true,
# "variation": true,
# "options": [
# "S",
# "M"
# ]
# }
# ],
# "default_attributes": [
# ],
# "variations": [
# ],
# "grouped_products": [
# ],
# "menu_order": 0,
# "meta_data": [
# ],
# "_links": {
# "self": [
# {
# "href": "https://example.com/wp-json/wc/v3/products/799"
# }
# ],
# "collection": [
# {
# "href": "https://example.com/wp-json/wc/v3/products"
# }
# ]
# }
# },
# {
# "id": 794,
# "name": "Premium Quality",
# "slug": "premium-quality-19",
# "permalink": "https://example.com/product/premium-quality-19/",
# "date_created": "2017-03-23T17:01:14",
# "date_created_gmt": "2017-03-23T20:01:14",
# "date_modified": "2017-03-23T17:01:14",
# "date_modified_gmt": "2017-03-23T20:01:14",
# "type": "simple",
# "status": "publish",
# "featured": false,
# "catalog_visibility": "visible",
# "description": "<p>Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum tortor quam, feugiat vitae, ultricies eget, tempor sit amet, ante. Donec eu libero sit amet quam egestas semper. Aenean ultricies mi vitae est. Mauris placerat eleifend leo.</p>\n",
# "short_description": "<p>Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.</p>\n",
# "sku": "",
# "price": "21.99",
# "regular_price": "21.99",
# "sale_price": "",
# "date_on_sale_from": null,
# "date_on_sale_from_gmt": null,
# "date_on_sale_to": null,
# "date_on_sale_to_gmt": null,
# "price_html": "<span class=\"woocommerce-Price-amount amount\"><span class=\"woocommerce-Price-currencySymbol\">$</span>21.99</span>",
# "on_sale": false,
# "purchasable": true,
# "total_sales": 0,
# "virtual": false,
# "downloadable": false,
# "downloads": [
# ],
# "download_limit": -1,
# "download_expiry": -1,
# "external_url": "",
# "button_text": "",
# "tax_status": "taxable",
# "tax_class": "",
# "manage_stock": false,
# "stock_quantity": null,
# "stock_status": "instock",
# "backorders": "no",
# "backorders_allowed": false,
# "backordered": false,
# "sold_individually": false,
# "weight": "",
# "dimensions": {
# "length": "",
# "width": "",
# "height": ""
# },
# "shipping_required": true,
# "shipping_taxable": true,
# "shipping_class": "",
# "shipping_class_id": 0,
# "reviews_allowed": true,
# "average_rating": "0.00",
# "rating_count": 0,
# "related_ids": [
# 463,
# 47,
# 31,
# 387,
# 458
# ],
# "upsell_ids": [
# ],
# "cross_sell_ids": [
# ],
# "parent_id": 0,
# "purchase_note": "",
# "categories": [
# {
# "id": 9,
# "name": "Clothing",
# "slug": "clothing"
# },
# {
# "id": 14,
# "name": "T-shirts",
# "slug": "t-shirts"
# }
# ],
# "tags": [
# ],
# "images": [
# {
# "id": 792,
# "date_created": "2017-03-23T14:01:13",
# "date_created_gmt": "2017-03-23T20:01:13",
# "date_modified": "2017-03-23T14:01:13",
# "date_modified_gmt": "2017-03-23T20:01:13",
# "src": "https://example.com/wp-content/uploads/2017/03/T_2_front-4.jpg",
# "name": "",
# "alt": ""
# },
# {
# "id": 793,
# "date_created": "2017-03-23T14:01:14",
# "date_created_gmt": "2017-03-23T20:01:14",
# "date_modified": "2017-03-23T14:01:14",
# "date_modified_gmt": "2017-03-23T20:01:14",
# "src": "https://example.com/wp-content/uploads/2017/03/T_2_back-2.jpg",
# "name": "",
# "alt": ""
# }
# ],
# "attributes": [
# ],
# "default_attributes": [
# {
# "id": 6,
# "name": "Color",
# "option": "black"
# },
# {
# "id": 0,
# "name": "Size",
# "option": "S"
# }
# ],
# "variations": [
# ],
# "grouped_products": [
# ],
# "menu_order": 0,
# "meta_data": [
# ],
# "_links": {
# "self": [
# {
# "href": "https://example.com/wp-json/wc/v3/products/794"
# }
# ],
# "collection": [
# {
# "href": "https://example.com/wp-json/wc/v3/products"
# }
# ]
# }
# }
# ]
# Sample code for parsing the JSON response...
# Use the following online tool to generate parsing code from sample JSON:
# Generate Parsing Code from JSON
set date_created [new_CkDtObj]
set date_created_gmt [new_CkDtObj]
set date_modified [new_CkDtObj]
set date_modified_gmt [new_CkDtObj]
set date_on_sale_from [new_CkDtObj]
set date_on_sale_from_gmt [new_CkDtObj]
set date_on_sale_to [new_CkDtObj]
set date_on_sale_to_gmt [new_CkDtObj]
# json is a CkJsonObject
set i 0
set count_i [CkJsonArray_get_Size $jarrResp]
while {$i < $count_i} {
set json [CkJsonArray_ObjectAt $jarrResp $i]
set id [CkJsonObject_IntOf $json "id"]
set name [CkJsonObject_stringOf $json "name"]
set slug [CkJsonObject_stringOf $json "slug"]
set permalink [CkJsonObject_stringOf $json "permalink"]
CkJsonObject_DtOf $json "date_created" 0 $date_created
CkJsonObject_DtOf $json "date_created_gmt" 0 $date_created_gmt
CkJsonObject_DtOf $json "date_modified" 0 $date_modified
CkJsonObject_DtOf $json "date_modified_gmt" 0 $date_modified_gmt
set v_type [CkJsonObject_stringOf $json "type"]
set status [CkJsonObject_stringOf $json "status"]
set featured [CkJsonObject_BoolOf $json "featured"]
set catalog_visibility [CkJsonObject_stringOf $json "catalog_visibility"]
set description [CkJsonObject_stringOf $json "description"]
set short_description [CkJsonObject_stringOf $json "short_description"]
set sku [CkJsonObject_stringOf $json "sku"]
set price [CkJsonObject_stringOf $json "price"]
set regular_price [CkJsonObject_stringOf $json "regular_price"]
set sale_price [CkJsonObject_stringOf $json "sale_price"]
CkJsonObject_DtOf $json "date_on_sale_from" 0 $date_on_sale_from
CkJsonObject_DtOf $json "date_on_sale_from_gmt" 0 $date_on_sale_from_gmt
CkJsonObject_DtOf $json "date_on_sale_to" 0 $date_on_sale_to
CkJsonObject_DtOf $json "date_on_sale_to_gmt" 0 $date_on_sale_to_gmt
set price_html [CkJsonObject_stringOf $json "price_html"]
set on_sale [CkJsonObject_BoolOf $json "on_sale"]
set purchasable [CkJsonObject_BoolOf $json "purchasable"]
set total_sales [CkJsonObject_IntOf $json "total_sales"]
set v_virtual [CkJsonObject_BoolOf $json "virtual"]
set downloadable [CkJsonObject_BoolOf $json "downloadable"]
set download_limit [CkJsonObject_IntOf $json "download_limit"]
set download_expiry [CkJsonObject_IntOf $json "download_expiry"]
set external_url [CkJsonObject_stringOf $json "external_url"]
set button_text [CkJsonObject_stringOf $json "button_text"]
set tax_status [CkJsonObject_stringOf $json "tax_status"]
set tax_class [CkJsonObject_stringOf $json "tax_class"]
set manage_stock [CkJsonObject_BoolOf $json "manage_stock"]
set stock_quantity [CkJsonObject_stringOf $json "stock_quantity"]
set stock_status [CkJsonObject_stringOf $json "stock_status"]
set backorders [CkJsonObject_stringOf $json "backorders"]
set backorders_allowed [CkJsonObject_BoolOf $json "backorders_allowed"]
set backordered [CkJsonObject_BoolOf $json "backordered"]
set sold_individually [CkJsonObject_BoolOf $json "sold_individually"]
set weight [CkJsonObject_stringOf $json "weight"]
set dimensionsLength [CkJsonObject_stringOf $json "dimensions.length"]
set dimensionsWidth [CkJsonObject_stringOf $json "dimensions.width"]
set dimensionsHeight [CkJsonObject_stringOf $json "dimensions.height"]
set shipping_required [CkJsonObject_BoolOf $json "shipping_required"]
set shipping_taxable [CkJsonObject_BoolOf $json "shipping_taxable"]
set shipping_class [CkJsonObject_stringOf $json "shipping_class"]
set shipping_class_id [CkJsonObject_IntOf $json "shipping_class_id"]
set reviews_allowed [CkJsonObject_BoolOf $json "reviews_allowed"]
set average_rating [CkJsonObject_stringOf $json "average_rating"]
set rating_count [CkJsonObject_IntOf $json "rating_count"]
set parent_id [CkJsonObject_IntOf $json "parent_id"]
set purchase_note [CkJsonObject_stringOf $json "purchase_note"]
set menu_order [CkJsonObject_IntOf $json "menu_order"]
set j 0
set count_j [CkJsonObject_SizeOfArray $json "downloads"]
while {$j < $count_j} {
CkJsonObject_put_J $json $j
set j [expr $j + 1]
}
set j 0
set count_j [CkJsonObject_SizeOfArray $json "related_ids"]
while {$j < $count_j} {
CkJsonObject_put_J $json $j
set intVal [CkJsonObject_IntOf $json "related_ids[j]"]
set j [expr $j + 1]
}
set j 0
set count_j [CkJsonObject_SizeOfArray $json "upsell_ids"]
while {$j < $count_j} {
CkJsonObject_put_J $json $j
set j [expr $j + 1]
}
set j 0
set count_j [CkJsonObject_SizeOfArray $json "cross_sell_ids"]
while {$j < $count_j} {
CkJsonObject_put_J $json $j
set j [expr $j + 1]
}
set j 0
set count_j [CkJsonObject_SizeOfArray $json "categories"]
while {$j < $count_j} {
CkJsonObject_put_J $json $j
set id [CkJsonObject_IntOf $json "categories[j].id"]
set name [CkJsonObject_stringOf $json "categories[j].name"]
set slug [CkJsonObject_stringOf $json "categories[j].slug"]
set j [expr $j + 1]
}
set j 0
set count_j [CkJsonObject_SizeOfArray $json "tags"]
while {$j < $count_j} {
CkJsonObject_put_J $json $j
set j [expr $j + 1]
}
set j 0
set count_j [CkJsonObject_SizeOfArray $json "images"]
while {$j < $count_j} {
CkJsonObject_put_J $json $j
set id [CkJsonObject_IntOf $json "images[j].id"]
CkJsonObject_DtOf $json "images[j].date_created" 0 $date_created
CkJsonObject_DtOf $json "images[j].date_created_gmt" 0 $date_created_gmt
CkJsonObject_DtOf $json "images[j].date_modified" 0 $date_modified
CkJsonObject_DtOf $json "images[j].date_modified_gmt" 0 $date_modified_gmt
set src [CkJsonObject_stringOf $json "images[j].src"]
set name [CkJsonObject_stringOf $json "images[j].name"]
set alt [CkJsonObject_stringOf $json "images[j].alt"]
set j [expr $j + 1]
}
set j 0
set count_j [CkJsonObject_SizeOfArray $json "attributes"]
while {$j < $count_j} {
CkJsonObject_put_J $json $j
set id [CkJsonObject_IntOf $json "attributes[j].id"]
set name [CkJsonObject_stringOf $json "attributes[j].name"]
set position [CkJsonObject_IntOf $json "attributes[j].position"]
set visible [CkJsonObject_BoolOf $json "attributes[j].visible"]
set variation [CkJsonObject_BoolOf $json "attributes[j].variation"]
set k 0
set count_k [CkJsonObject_SizeOfArray $json "attributes[j].options"]
while {$k < $count_k} {
CkJsonObject_put_K $json $k
set strVal [CkJsonObject_stringOf $json "attributes[j].options[k]"]
set k [expr $k + 1]
}
set j [expr $j + 1]
}
set j 0
set count_j [CkJsonObject_SizeOfArray $json "default_attributes"]
while {$j < $count_j} {
CkJsonObject_put_J $json $j
set id [CkJsonObject_IntOf $json "default_attributes[j].id"]
set name [CkJsonObject_stringOf $json "default_attributes[j].name"]
set v_option [CkJsonObject_stringOf $json "default_attributes[j].option"]
set j [expr $j + 1]
}
set j 0
set count_j [CkJsonObject_SizeOfArray $json "variations"]
while {$j < $count_j} {
CkJsonObject_put_J $json $j
set j [expr $j + 1]
}
set j 0
set count_j [CkJsonObject_SizeOfArray $json "grouped_products"]
while {$j < $count_j} {
CkJsonObject_put_J $json $j
set j [expr $j + 1]
}
set j 0
set count_j [CkJsonObject_SizeOfArray $json "meta_data"]
while {$j < $count_j} {
CkJsonObject_put_J $json $j
set j [expr $j + 1]
}
set j 0
set count_j [CkJsonObject_SizeOfArray $json "_links.self"]
while {$j < $count_j} {
CkJsonObject_put_J $json $j
set href [CkJsonObject_stringOf $json "_links.self[j].href"]
set j [expr $j + 1]
}
set j 0
set count_j [CkJsonObject_SizeOfArray $json "_links.collection"]
while {$j < $count_j} {
CkJsonObject_put_J $json $j
set href [CkJsonObject_stringOf $json "_links.collection[j].href"]
set j [expr $j + 1]
}
delete_CkJsonObject $json
set i [expr $i + 1]
}
delete_CkHttp $http
delete_CkStringBuilder $sbResponseBody
delete_CkJsonArray $jarrResp
delete_CkDtObj $date_created
delete_CkDtObj $date_created_gmt
delete_CkDtObj $date_modified
delete_CkDtObj $date_modified_gmt
delete_CkDtObj $date_on_sale_from
delete_CkDtObj $date_on_sale_from_gmt
delete_CkDtObj $date_on_sale_to
delete_CkDtObj $date_on_sale_to_gmt