Visual FoxPro

WooCommerce List Products having SKU

See more WooCommerce Examples

Gets information for a product by SKU. Visual FoxPro

LOCAL lnSuccess
LOCAL loHttp
LOCAL loSbResponseBody
LOCAL loJarrResp
LOCAL lnRespStatusCode

lnSuccess = 0

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

loHttp = 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

loHttp.BasicAuth = 1
loHttp.Login = "consumer_key"
loHttp.Password = "consumer_secret"

loSbResponseBody = CreateObject('Chilkat.StringBuilder')
loHttp.SetUrlVar("sku","3386460107914")
* Use "https" or "http" depending on what your site needs.
lnSuccess = loHttp.QuickGetSb("http://example.com/wp-json/wc/v3/products?sku={$sku}",loSbResponseBody)
IF (lnSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loSbResponseBody
    CANCEL
ENDIF

loJarrResp = CreateObject('Chilkat.JsonArray')
loJarrResp.LoadSb(loSbResponseBody)
loJarrResp.EmitCompact = 0

? "Response Body:"
? loJarrResp.Emit()

lnRespStatusCode = loHttp.LastStatus
? "Response Status Code = " + STR(lnRespStatusCode)
IF (lnRespStatusCode >= 400) THEN
    ? "Response Header:"
    ? loHttp.LastHeader
    ? "Failed."
    RELEASE loHttp
    RELEASE loSbResponseBody
    RELEASE loJarrResp
    CANCEL
ENDIF

RELEASE loHttp
RELEASE loSbResponseBody
RELEASE loJarrResp