Lianja

Shopify Query a variant for its inventory item ID

See more Shopify Examples

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

llSuccess = .F.

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

loHttp = createobject("CkHttp")

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

loHttp.Accept = "application/json"

loResp = createobject("CkHttpResponse")
llSuccess = loHttp.HttpNoBody("GET","https://{shop}.myshopify.com/admin/api/2020-04/products/{product_id}/variants/{variant_id}.json",loResp)
if (llSuccess = .F.) then
    ? loHttp.LastErrorText
    release loHttp
    release loResp
    return
endif

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

loJsonResponse = createobject("CkJsonObject")
loJsonResponse.Load(loResp.BodyStr)
loJsonResponse.EmitCompact = .F.
? loJsonResponse.Emit()

if (loResp.StatusCode <> 200) then
    ? "Failed."
    release loHttp
    release loResp
    release loJsonResponse
    return
endif

// 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 loResp
release loJsonResponse