Visual Basic 6.0

Shopware List Categories

See more Shopware Examples

List categories in your Shopware database. Visual Basic 6.0

Dim success As Long
success = 0

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

Dim http As New ChilkatHttp

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

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

Dim jResp As New ChilkatJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = 0

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

Dim id As Long
Dim active As Long
Dim name As String
Dim position As Long
Dim parentId As String
Dim mediaId As String
Dim childrenCount As String
Dim articleCount As String

Dim total As Long
total = jResp.IntOf("total")
success = jResp.BoolOf("success")
Dim i As Long
i = 0
Dim count_i As Long
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