(VBScript) 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

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

' 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")
set http = CreateObject("Chilkat.Http")

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

http.Accept = "application/json"

' resp is a Chilkat.HttpResponse
Set resp = http.QuickRequest("GET","https://{shop}.myshopify.com/admin/api/2020-04/products/{product_id}/variants/{variant_id}.json")
If (http.LastMethodSuccess <> 1) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

outFile.WriteLine("Response Status Code: " & resp.StatusCode)

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set jsonResponse = CreateObject("Chilkat.JsonObject")
success = jsonResponse.Load(resp.BodyStr)
jsonResponse.EmitCompact = 0
outFile.WriteLine(jsonResponse.Emit())

If (resp.StatusCode <> 200) Then
    outFile.WriteLine("Failed.")

    WScript.Quit
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"
' }
' 

id = jsonResponse.IntOf("id")
product_id = jsonResponse.IntOf("product_id")
title = jsonResponse.StringOf("title")
inventory_item_id = jsonResponse.IntOf("inventory_item_id")
admin_graphql_api_id = jsonResponse.StringOf("admin_graphql_api_id")

outFile.Close