VBScript

WooCommerce List Products having SKU

See more WooCommerce Examples

Gets information for a product by SKU. VBScript

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

success = 0

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

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"

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

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