|
Chilkat • HOME • .NET Core C# • Android™ • AutoIt • C • C# • C++ • Chilkat2-Python • CkPython • Classic ASP • DataFlex • Delphi ActiveX • Delphi DLL • Go • Java • Lianja • Mono C# • Node.js • Objective-C • PHP ActiveX • PHP Extension • Perl • PowerBuilder • PowerShell • PureBasic • Ruby • SQL Server • Swift 2 • Swift 3,4,5... • Tcl • Unicode C • Unicode C++ • VB.NET • VBScript • Visual Basic 6.0 • Visual FoxPro • Xojo Plugin
(Visual Basic 6.0) WooCommerce List All ProductsSee more WooCommerce ExamplesGets WooCommerce product information in JSON format. For more information, see https://woocommerce.github.io/woocommerce-rest-api-docs/#list-all-products
' This example assumes the Chilkat API to have been previously unlocked. ' See Global Unlock Sample for sample code. Dim http As New ChilkatHttp Dim success As Long ' 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 http.BasicAuth = 1 http.Login = "consumer_key" http.Password = "consumer_secret" Dim sbResponseBody As New ChilkatStringBuilder success = http.QuickGetSb("https://example.com/wp-json/wc/v3/products",sbResponseBody) If (success = 0) Then Debug.Print http.LastErrorText Exit Sub End If Dim jarrResp As New ChilkatJsonArray success = jarrResp.LoadSb(sbResponseBody) jarrResp.EmitCompact = 0 Debug.Print "Response Body:" Debug.Print jarrResp.Emit() Dim respStatusCode As Long respStatusCode = http.LastStatus Debug.Print "Response Status Code = " & respStatusCode If (respStatusCode >= 400) Then Debug.Print "Response Header:" Debug.Print http.LastHeader Debug.Print "Failed." Exit Sub End If ' 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 Dim date_created As New DtObj Dim date_created_gmt As New DtObj Dim date_modified As New DtObj Dim date_modified_gmt As New DtObj Dim date_on_sale_from As New DtObj Dim date_on_sale_from_gmt As New DtObj Dim date_on_sale_to As New DtObj Dim date_on_sale_to_gmt As New DtObj Dim json As ChilkatJsonObject Dim id As Long Dim name As String Dim slug As String Dim permalink As String Dim v_type As String Dim status As String Dim featured As Long Dim catalog_visibility As String Dim description As String Dim short_description As String Dim sku As String Dim price As String Dim regular_price As String Dim sale_price As String Dim price_html As String Dim on_sale As Long Dim purchasable As Long Dim total_sales As Long Dim v_virtual As Long Dim downloadable As Long Dim download_limit As Long Dim download_expiry As Long Dim external_url As String Dim button_text As String Dim tax_status As String Dim tax_class As String Dim manage_stock As Long Dim stock_quantity As String Dim stock_status As String Dim backorders As String Dim backorders_allowed As Long Dim backordered As Long Dim sold_individually As Long Dim weight As String Dim dimensionsLength As String Dim dimensionsWidth As String Dim dimensionsHeight As String Dim shipping_required As Long Dim shipping_taxable As Long Dim shipping_class As String Dim shipping_class_id As Long Dim reviews_allowed As Long Dim average_rating As String Dim rating_count As Long Dim parent_id As Long Dim purchase_note As String Dim menu_order As Long Dim j As Long Dim count_j As Long Dim intVal As Long Dim src As String Dim alt As String Dim position As Long Dim visible As Long Dim variation As Long Dim k As Long Dim count_k As Long Dim strVal As String Dim v_option As String Dim href As String Dim i As Long i = 0 Dim count_i As Long count_i = jarrResp.Size Do While i < count_i Set json = jarrResp.ObjectAt(i) id = json.IntOf("id") name = json.StringOf("name") slug = json.StringOf("slug") permalink = json.StringOf("permalink") success = json.DtOf("date_created",0,date_created) success = json.DtOf("date_created_gmt",0,date_created_gmt) success = json.DtOf("date_modified",0,date_modified) success = json.DtOf("date_modified_gmt",0,date_modified_gmt) v_type = json.StringOf("type") status = json.StringOf("status") featured = json.BoolOf("featured") catalog_visibility = json.StringOf("catalog_visibility") description = json.StringOf("description") short_description = json.StringOf("short_description") sku = json.StringOf("sku") price = json.StringOf("price") regular_price = json.StringOf("regular_price") sale_price = json.StringOf("sale_price") success = json.DtOf("date_on_sale_from",0,date_on_sale_from) success = json.DtOf("date_on_sale_from_gmt",0,date_on_sale_from_gmt) success = json.DtOf("date_on_sale_to",0,date_on_sale_to) success = json.DtOf("date_on_sale_to_gmt",0,date_on_sale_to_gmt) price_html = json.StringOf("price_html") on_sale = json.BoolOf("on_sale") purchasable = json.BoolOf("purchasable") total_sales = json.IntOf("total_sales") v_virtual = json.BoolOf("virtual") downloadable = json.BoolOf("downloadable") download_limit = json.IntOf("download_limit") download_expiry = json.IntOf("download_expiry") external_url = json.StringOf("external_url") button_text = json.StringOf("button_text") tax_status = json.StringOf("tax_status") tax_class = json.StringOf("tax_class") manage_stock = json.BoolOf("manage_stock") stock_quantity = json.StringOf("stock_quantity") stock_status = json.StringOf("stock_status") backorders = json.StringOf("backorders") backorders_allowed = json.BoolOf("backorders_allowed") backordered = json.BoolOf("backordered") sold_individually = json.BoolOf("sold_individually") weight = json.StringOf("weight") dimensionsLength = json.StringOf("dimensions.length") dimensionsWidth = json.StringOf("dimensions.width") dimensionsHeight = json.StringOf("dimensions.height") shipping_required = json.BoolOf("shipping_required") shipping_taxable = json.BoolOf("shipping_taxable") shipping_class = json.StringOf("shipping_class") shipping_class_id = json.IntOf("shipping_class_id") reviews_allowed = json.BoolOf("reviews_allowed") average_rating = json.StringOf("average_rating") rating_count = json.IntOf("rating_count") parent_id = json.IntOf("parent_id") purchase_note = json.StringOf("purchase_note") menu_order = json.IntOf("menu_order") j = 0 count_j = json.SizeOfArray("downloads") Do While j < count_j json.J = j j = j + 1 Loop j = 0 count_j = json.SizeOfArray("related_ids") Do While j < count_j json.J = j intVal = json.IntOf("related_ids[j]") j = j + 1 Loop j = 0 count_j = json.SizeOfArray("upsell_ids") Do While j < count_j json.J = j j = j + 1 Loop j = 0 count_j = json.SizeOfArray("cross_sell_ids") Do While j < count_j json.J = j j = j + 1 Loop j = 0 count_j = json.SizeOfArray("categories") Do While j < count_j json.J = j id = json.IntOf("categories[j].id") name = json.StringOf("categories[j].name") slug = json.StringOf("categories[j].slug") j = j + 1 Loop j = 0 count_j = json.SizeOfArray("tags") Do While j < count_j json.J = j j = j + 1 Loop j = 0 count_j = json.SizeOfArray("images") Do While j < count_j json.J = j id = json.IntOf("images[j].id") success = json.DtOf("images[j].date_created",0,date_created) success = json.DtOf("images[j].date_created_gmt",0,date_created_gmt) success = json.DtOf("images[j].date_modified",0,date_modified) success = json.DtOf("images[j].date_modified_gmt",0,date_modified_gmt) src = json.StringOf("images[j].src") name = json.StringOf("images[j].name") alt = json.StringOf("images[j].alt") j = j + 1 Loop j = 0 count_j = json.SizeOfArray("attributes") Do While j < count_j json.J = j id = json.IntOf("attributes[j].id") name = json.StringOf("attributes[j].name") position = json.IntOf("attributes[j].position") visible = json.BoolOf("attributes[j].visible") variation = json.BoolOf("attributes[j].variation") k = 0 count_k = json.SizeOfArray("attributes[j].options") Do While k < count_k json.K = k strVal = json.StringOf("attributes[j].options[k]") k = k + 1 Loop j = j + 1 Loop j = 0 count_j = json.SizeOfArray("default_attributes") Do While j < count_j json.J = j id = json.IntOf("default_attributes[j].id") name = json.StringOf("default_attributes[j].name") v_option = json.StringOf("default_attributes[j].option") j = j + 1 Loop j = 0 count_j = json.SizeOfArray("variations") Do While j < count_j json.J = j j = j + 1 Loop j = 0 count_j = json.SizeOfArray("grouped_products") Do While j < count_j json.J = j j = j + 1 Loop j = 0 count_j = json.SizeOfArray("meta_data") Do While j < count_j json.J = j j = j + 1 Loop j = 0 count_j = json.SizeOfArray("_links.self") Do While j < count_j json.J = j href = json.StringOf("_links.self[j].href") j = j + 1 Loop j = 0 count_j = json.SizeOfArray("_links.collection") Do While j < count_j json.J = j href = json.StringOf("_links.collection[j].href") j = j + 1 Loop i = i + 1 Loop |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.