PowerBuilder

Shopify Retrieve the item's inventory levels

See more Shopify Examples

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: PowerBuilder

integer li_rc
integer li_Success
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

li_Success = 0

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

loo_Http = create oleobject
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 = create oleobject
li_rc = loo_Resp.ConnectToNewObject("Chilkat.HttpResponse")

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

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

loo_JsonResponse = create oleobject
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_Http
    destroy loo_Resp
    destroy loo_JsonResponse
    return
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

// {
//   "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_Resp
destroy loo_JsonResponse