Visual FoxPro

Shopify Receive Count of All Products in a Collection

See more Shopify Examples

Get a count of all products of a given collection Visual FoxPro

LOCAL lnSuccess
LOCAL loRest
LOCAL loSbJson
LOCAL loJson
LOCAL lnCount

lnSuccess = 0

loRest = CreateObject('Chilkat.Rest')

loRest.SetAuthBasic("SHOPIFY_PRIVATE_API_KEY","SHOPIFY_PRIVATE_API_KEY")

lnSuccess = loRest.Connect("chilkat.myshopify.com",443,1,1)
IF (lnSuccess <> 1) THEN
    ? loRest.LastErrorText
    RELEASE loRest
    CANCEL
ENDIF

loSbJson = CreateObject('Chilkat.StringBuilder')
lnSuccess = loRest.FullRequestNoBodySb("GET","/admin/products/count.json?collection_id=841564295 ",loSbJson)
IF (lnSuccess <> 1) THEN
    ? loRest.LastErrorText
    RELEASE loRest
    RELEASE loSbJson
    CANCEL
ENDIF

IF (loRest.ResponseStatusCode <> 200) THEN
    ? "Received error response code: " + STR(loRest.ResponseStatusCode)
    ? "Response body:"
    ? loSbJson.GetAsString()
    RELEASE loRest
    RELEASE loSbJson
    CANCEL
ENDIF

loJson = CreateObject('Chilkat.JsonObject')
loJson.LoadSb(loSbJson)

*  The following code parses the JSON response.
*  A sample JSON response is shown below the sample code.

lnCount = loJson.IntOf("count")

*  A sample JSON response body that is parsed by the above code:

*  {
*    "count": 1
*  }

? "Example Completed."

RELEASE loRest
RELEASE loSbJson
RELEASE loJson