(Visual FoxPro) Shopify Update Inventory Level for a Product (Adjust available quantity)

Use the adjust endpoint with the location ID and inventory item ID to increase or decrease the available quantity for an inventory level:

For more information, see https://shopify.dev/tutorials/manage-product-inventory-with-admin-api#update-inventory-levels-for-a-product-variant

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

LOCAL loHttp
LOCAL loJsonRequestBody
LOCAL lcUrl
LOCAL loResp
LOCAL loJsonResponse
LOCAL lnInventory_levelInventory_item_id
LOCAL lnInventory_levelLocation_id
LOCAL lnInventory_levelAvailable
LOCAL lcInventory_levelUpdated_at
LOCAL lcInventory_levelAdmin_graphql_api_id

* 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')
loHttp = CreateObject('Chilkat.Http')

loHttp.Login = "SHOPIFY_PRIVATE_API_KEY"
loHttp.Password = "SHOPIFY_PRIVATE_API_KEY"

* Also see: How to retrieve inventory levels

loHttp.Accept = "application/json"

* The following JSON is sent in the request body:

* {
*   "location_id": 6884556842,
*   "inventory_item_id": 12250274365496,
*   "available_adjustment": 1
* }

* Use this online tool to generate the code from sample JSON: 
* Generate Code to Create JSON

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJsonRequestBody = CreateObject('Chilkat.JsonObject')
loJsonRequestBody.UpdateInt("location_id",6884556842)
loJsonRequestBody.UpdateInt("inventory_item_id",12250274365496)
loJsonRequestBody.UpdateInt("available_adjustment",1)

lcUrl = "https://{shop}.myshopify.com/admin/api/2020-04/inventory_levels/adjust.json"

loResp = loHttp.PText("POST",lcUrl,loJsonRequestBody.Emit(),"utf-8","application/json",0,0)
IF (loHttp.LastMethodSuccess <> 1) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loJsonRequestBody
    CANCEL
ENDIF

? "Response Status Code: " + STR(loResp.StatusCode)

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJsonResponse = CreateObject('Chilkat.JsonObject')
loJsonResponse.Load(loResp.BodyStr)
loJsonResponse.EmitCompact = 0
? loJsonResponse.Emit()

IF (loResp.StatusCode >= 300) THEN
    ? "Failed."
    RELEASE loResp
    RELEASE loHttp
    RELEASE loJsonRequestBody
    RELEASE loJsonResponse
    CANCEL
ENDIF

RELEASE loResp

* 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_level": {
*     "inventory_item_id": 12250274365496,
*     "location_id": 6884556842,
*     "available": 9,
*     "updated_at": "2018-06-26T15:04:49-04:00",
* ...
*     "admin_graphql_api_id": "gid://shopify/InventoryLevel/6485147690?inventory_item_id=12250274365496"
* ...
*   }
* }
* 

lnInventory_levelInventory_item_id = loJsonResponse.IntOf("inventory_level.inventory_item_id")
lnInventory_levelLocation_id = loJsonResponse.IntOf("inventory_level.location_id")
lnInventory_levelAvailable = loJsonResponse.IntOf("inventory_level.available")
lcInventory_levelUpdated_at = loJsonResponse.StringOf("inventory_level.updated_at")
lcInventory_levelAdmin_graphql_api_id = loJsonResponse.StringOf("inventory_level.admin_graphql_api_id")

RELEASE loHttp
RELEASE loJsonRequestBody
RELEASE loJsonResponse