(PowerBuilder) Shopify Retrieve the item's inventory levels

After you have the inventory item ID, you can use it with the InventoryLevel resource to find the levels and locations for the 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

integer li_rc
oleobject loo_Http
oleobject loo_Resp
oleobject loo_JsonResponse
integer li_Inventory_item_id
integer li_Location_id
integer li_Available
string ls_Updated_at
string ls_Admin_graphql_api_id
integer i
integer li_Count_i

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

loo_Http = create oleobject
// Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
if li_rc < 0 then
    destroy loo_Http
    MessageBox("Error","Connecting to COM object failed")
    return
end if

loo_Http.Login = "SHOPIFY_PRIVATE_API_KEY"
loo_Http.Password = "SHOPIFY_PRIVATE_API_KEY"

loo_Http.Accept = "application/json"

// How to get the inventory item ID

loo_Resp = loo_Http.QuickRequest("GET","https://{shop}.myshopify.com/admin/api/2020-04/inventory_levels.json?inventory_item_ids={inventory_item_id}")
if loo_Http.LastMethodSuccess <> 1 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    return
end if

Write-Debug "Response Status Code: " + string(loo_Resp.StatusCode)

loo_JsonResponse = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_JsonResponse.ConnectToNewObject("Chilkat.JsonObject")

loo_JsonResponse.Load(loo_Resp.BodyStr)
loo_JsonResponse.EmitCompact = 0
Write-Debug loo_JsonResponse.Emit()

if loo_Resp.StatusCode <> 200 then
    Write-Debug "Failed."
    destroy loo_Resp
    destroy loo_Http
    destroy loo_JsonResponse
    return
end if

destroy loo_Resp

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

// {
//   "inventory_levels": [
//     {
//       "inventory_item_id": 12250274365496,
//       "location_id": 6884556842,
//       "available": 8,
//       "updated_at": "2018-06-18T11:49:50-04:00",
//       "admin_graphql_api_id": "gid://shopify/InventoryLevel/6485147690?inventory_item_id=12250274365496"
//     },
//     {
//       "inventory_item_id": 12250274365496,
//       "location_id": 13968834616,
//       "available": 50,
//       "updated_at": "2018-06-26T14:44:30-04:00",
//       "admin_graphql_api_id": "gid://shopify/InventoryLevel/13570506808?inventory_item_id=12250274365496"
//     },
//     {
//       "inventory_item_id": 12250274365496,
//       "location_id": 13968867384,
//       "available": 100,
//       "updated_at": "2018-06-26T14:44:30-04:00",
//       "admin_graphql_api_id": "gid://shopify/InventoryLevel/13570539576?inventory_item_id=12250274365496"
//     }
//   ]
// }
// 

i = 0
li_Count_i = loo_JsonResponse.SizeOfArray("inventory_levels")
do while i < li_Count_i
    loo_JsonResponse.I = i
    li_Inventory_item_id = loo_JsonResponse.IntOf("inventory_levels[i].inventory_item_id")
    li_Location_id = loo_JsonResponse.IntOf("inventory_levels[i].location_id")
    li_Available = loo_JsonResponse.IntOf("inventory_levels[i].available")
    ls_Updated_at = loo_JsonResponse.StringOf("inventory_levels[i].updated_at")
    ls_Admin_graphql_api_id = loo_JsonResponse.StringOf("inventory_levels[i].admin_graphql_api_id")
    i = i + 1
loop


destroy loo_Http
destroy loo_JsonResponse