(Excel) ShopwareDelete Product

See more Shopware Examples

Deletes a product in Shopware.

For more information, see https://developers.shopware.com/developers-guide/rest-api/examples/article/#example-4-delete-a-product

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

http.Login = "api_username"
http.Password = "api_key"
http.BasicAuth = True

' The id of the product is appended to the path part of the URL.
Dim success As Boolean
success = http.SetUrlVar("id","8312")


url = "https://my-shopware-shop.com/api/articles/{$id}"

' Send a DELETE request with nothing in the request body.

Set resp = http.QuickRequest("DELETE",url)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = resp.GetBodySb(sbResponseBody)

Dim jResp As Chilkat.JsonObject
Set jResp = Chilkat.NewJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False

Debug.Print "Response Body:"
Debug.Print jResp.Emit()

' A 200 response code indicates success (i.e. the request was sent and a response was received).

respStatusCode = resp.StatusCode
Debug.Print "Response Status Code = "; respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print resp.Header
    Debug.Print "Failed."

    Exit Sub
End If

' Sample JSON response:

' {
'   "success": true
' }


bDeleted = jResp.BoolOf("success")
Debug.Print "Deleted: "; bDeleted

' A failed response would look like this:

' {
'   "success": false,
'   "message": "Product by \"id\" 8312 not found"
' }