(Excel) Shopware List Categories

See more Shopware Examples

List categories in your Shopware database.

For more information, see https://developers.shopware.com/developers-guide/rest-api/api-resource-categories/

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

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder

success = http.QuickGetSb("https://my-shopware-shop.com/api/categories?limit=2",sbResponseBody)
If (success = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

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

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

' Sample JSON response:
' (Sample code for parsing the JSON response is shown below)

' {
'   "data": [
'     {
'       "id": 1,
'       "active": true,
'       "name": "Root",
'       "position": 0,
'       "parentId": null,
'       "mediaId": null,
'       "childrenCount": "3",
'       "articleCount": "0"
'     },
'     {
'       "id": 384,
'       "active": true,
'       "name": "Deutsch",
'       "position": 0,
'       "parentId": 1,
'       "mediaId": null,
'       "childrenCount": "9",
'       "articleCount": "32"
'     }
'   ],
'   "total": 118,
'   "success": true
' }

' Sample code for parsing the JSON response...
' Use the following online tool to generate parsing code from sample JSON:
' Generate Parsing Code from JSON


total = jResp.IntOf("total")

success = jResp.BoolOf("success")

i = 0

count_i = jResp.SizeOfArray("data")
Do While i < count_i
    jResp.I = i
    id = jResp.IntOf("data[i].id")
    active = jResp.BoolOf("data[i].active")
    name = jResp.StringOf("data[i].name")
    position = jResp.IntOf("data[i].position")
    parentId = jResp.StringOf("data[i].parentId")
    mediaId = jResp.StringOf("data[i].mediaId")
    childrenCount = jResp.StringOf("data[i].childrenCount")
    articleCount = jResp.StringOf("data[i].articleCount")
    i = i + 1
Loop