(VBScript) WooCommerce List Products having SKU

See more WooCommerce Examples

Gets information for a product by SKU.

For more information, see https://woocommerce.github.io/woocommerce-rest-api-docs/#list-all-products

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

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

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http")
set http = CreateObject("Chilkat.Http")

' Implements the following CURL command:

' curl https://example.com/wp-json/wc/v3/products?sku=3386460107914 \
'     -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"

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder")
set sbResponseBody = CreateObject("Chilkat.StringBuilder")
success = http.SetUrlVar("sku","3386460107914")
' Use "https" or "http" depending on what your site needs.
success = http.QuickGetSb("http://example.com/wp-json/wc/v3/products?sku={$sku}",sbResponseBody)
If (success = 0) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonArray")
set jarrResp = CreateObject("Chilkat.JsonArray")
success = jarrResp.LoadSb(sbResponseBody)
jarrResp.EmitCompact = 0

outFile.WriteLine("Response Body:")
outFile.WriteLine(jarrResp.Emit())

respStatusCode = http.LastStatus
outFile.WriteLine("Response Status Code = " & respStatusCode)
If (respStatusCode >= 400) Then
    outFile.WriteLine("Response Header:")
    outFile.WriteLine(http.LastHeader)
    outFile.WriteLine("Failed.")
    WScript.Quit
End If


outFile.Close