Xbase++ Requires Chilkat v11.0.0+

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: Xbase++

LOCAL nSuccess
LOCAL oHttp
LOCAL oResp
LOCAL oJsonResponse
LOCAL nInventory_item_id
LOCAL nLocation_id
LOCAL nAvailable
LOCAL cUpdated_at
LOCAL cAdmin_graphql_api_id
LOCAL i
LOCAL nCount_i

nSuccess := 0

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

oHttp := CreateObject("Chilkat.Http")

oHttp:Login := "SHOPIFY_PRIVATE_API_KEY"
oHttp:Password := "SHOPIFY_PRIVATE_API_KEY"

oHttp:Accept := "application/json"

//  How to get the inventory item ID

oResp := CreateObject("Chilkat.HttpResponse")
nSuccess := oHttp:HttpNoBody("GET", "https://{shop}.myshopify.com/admin/api/2020-04/inventory_levels.json?inventory_item_ids={inventory_item_id}", oResp)
IF (nSuccess == 0)
    ? oHttp:LastErrorText
    oHttp:destroy()
    oResp:destroy()
    RETURN
ENDIF

? "Response Status Code: " + Str(oResp:StatusCode)

oJsonResponse := CreateObject("Chilkat.JsonObject")
oJsonResponse:Load(oResp:BodyStr)
oJsonResponse:EmitCompact := 0
? oJsonResponse:Emit()

IF (oResp:StatusCode != 200)
    ? "Failed."
    oHttp:destroy()
    oResp:destroy()
    oJsonResponse:destroy()
    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

//  {
//    "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
nCount_i := oJsonResponse:SizeOfArray("inventory_levels")
DO WHILE i < nCount_i
    oJsonResponse:I := i
    nInventory_item_id := oJsonResponse:IntOf("inventory_levels[i].inventory_item_id")
    nLocation_id := oJsonResponse:IntOf("inventory_levels[i].location_id")
    nAvailable := oJsonResponse:IntOf("inventory_levels[i].available")
    cUpdated_at := oJsonResponse:StringOf("inventory_levels[i].updated_at")
    cAdmin_graphql_api_id := oJsonResponse:StringOf("inventory_levels[i].admin_graphql_api_id")
    i := i + 1
ENDDO

oHttp:destroy()
oResp:destroy()
oJsonResponse:destroy()