Visual Basic 6.0

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. Visual Basic 6.0

Dim success As Long
success = 0

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

Dim http As New ChilkatHttp

http.Login = "SHOPIFY_PRIVATE_API_KEY"
http.Password = "SHOPIFY_PRIVATE_API_KEY"

http.Accept = "application/json"

Dim resp As New ChilkatHttpResponse
success = http.HttpNoBody("GET","https://{shop}.myshopify.com/admin/api/2020-04/products/{product_id}/variants/{variant_id}.json",resp)
If (success = 0) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "Response Status Code: " & resp.StatusCode

Dim jsonResponse As New ChilkatJsonObject
success = jsonResponse.Load(resp.BodyStr)
jsonResponse.EmitCompact = 0
Debug.Print jsonResponse.Emit()

If (resp.StatusCode <> 200) Then
    Debug.Print "Failed."
    Exit Sub
End If

' 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"
' }
' 

Dim id As Long
id = jsonResponse.IntOf("id")
Dim product_id As Long
product_id = jsonResponse.IntOf("product_id")
Dim title As String
title = jsonResponse.StringOf("title")
Dim inventory_item_id As Long
inventory_item_id = jsonResponse.IntOf("inventory_item_id")
Dim admin_graphql_api_id As String
admin_graphql_api_id = jsonResponse.StringOf("admin_graphql_api_id")