VBScript

Shopware List Categories

See more Shopware Examples

List categories in your Shopware database. VBScript

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

success = 0

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

set http = CreateObject("Chilkat.Http")

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

set sbResponseBody = CreateObject("Chilkat.StringBuilder")
success = http.QuickGetSb("https://my-shopware-shop.com/api/categories?limit=2",sbResponseBody)
If (success = 0) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

set jResp = CreateObject("Chilkat.JsonObject")
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = 0

outFile.WriteLine("Response Body:")
outFile.WriteLine(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

outFile.Close