(Visual FoxPro) Shopify Query a variant for its inventory item ID

Query a product variant to find the ID of its inventory item.

For more information, see https://shopify.dev/tutorials/manage-product-inventory-with-admin-api#retrieve-the-inventory-levels-for-a-product-variant

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

LOCAL loHttp
LOCAL loResp
LOCAL loJsonResponse
LOCAL lnId
LOCAL lnProduct_id
LOCAL lcTitle
LOCAL lnInventory_item_id
LOCAL lcAdmin_graphql_api_id

* This example requires 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')
loHttp = CreateObject('Chilkat.Http')

loHttp.Login = "SHOPIFY_PRIVATE_API_KEY"
loHttp.Password = "SHOPIFY_PRIVATE_API_KEY"

loHttp.Accept = "application/json"

loResp = loHttp.QuickRequest("GET","https://{shop}.myshopify.com/admin/api/2020-04/products/{product_id}/variants/{variant_id}.json")
IF (loHttp.LastMethodSuccess <> 1) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    CANCEL
ENDIF

? "Response Status Code: " + STR(loResp.StatusCode)

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJsonResponse = CreateObject('Chilkat.JsonObject')
loJsonResponse.Load(loResp.BodyStr)
loJsonResponse.EmitCompact = 0
? loJsonResponse.Emit()

IF (loResp.StatusCode <> 200) THEN
    ? "Failed."
    RELEASE loResp
    RELEASE loHttp
    RELEASE loJsonResponse
    CANCEL
ENDIF

RELEASE loResp

* Sample output...
* (See the parsing code below..)
* 
* Use the this online tool to generate parsing code from sample JSON: 
* Generate Parsing Code from JSON

* {
*   "id": 12195009364024,
*   "product_id": 1321541042232,
*   "title": "xs",
* ...
*   "inventory_item_id": 12250274365496,
* ...
*   "admin_graphql_api_id": "gid://shopify/ProductVariant/12195009364024"
* }
* 

lnId = loJsonResponse.IntOf("id")
lnProduct_id = loJsonResponse.IntOf("product_id")
lcTitle = loJsonResponse.StringOf("title")
lnInventory_item_id = loJsonResponse.IntOf("inventory_item_id")
lcAdmin_graphql_api_id = loJsonResponse.StringOf("admin_graphql_api_id")

RELEASE loHttp
RELEASE loJsonResponse