Visual Basic 6.0

Shopware List Media

See more Shopware Examples

Demonstrates how to get a list of media in Shopware. 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/media?limit=10",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": 6708,
'       "albumId": -9,
'       "name": "sonnenblume",
'       "description": "",
'       "path": "https:\/\/my-shopware-shop.com\/media\/pdf\/2f\/26\/52\/sonnenblume.zip",
'       "type": "ARCHIVE",
'       "extension": "zip",
'       "userId": 5,
'       "created": "2021-03-01T00:00:00+0100",
'       "fileSize": 216905,
'       "width": null,
'       "height": null,
'       "attribute": null
'     },
'     {
'       "id": 6709,
'       "albumId": -9,
'       "name": "csinventur_anleitung",
'       "description": "",
'       "path": "https:\/\/my-shopware-shop.com\/media\/pdf\/19\/21\/86\/csinventur_anleitung.pdf",
'       "type": "PDF",
'       "extension": "pdf",
'       "userId": 5,
'       "created": "2021-03-01T00:00:00+0100",
'       "fileSize": 837131,
'       "width": null,
'       "height": null,
'       "attribute": null
'     },
'     {
'       "id": 6710,
'       "albumId": -9,
'       "name": "photos_fre_carousel_elevatorpitch_620x252",
'       "description": "",
'       "path": "https:\/\/my-shopware-shop.com\/media\/pdf\/d8\/d7\/b4\/photos_fre_carousel_elevatorpitch_620x252.mp4",
'       "type": "VIDEO",
'       "extension": "mp4",
'       "userId": 5,
'       "created": "2021-03-01T00:00:00+0100",
'       "fileSize": 2499157,
'       "width": null,
'       "height": null,
'       "attribute": null
'     },
' 
' 	...
'   ],
'   "total": 31,
'   "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 albumId As Long
Dim name As String
Dim description As String
Dim path As String
Dim v_type As String
Dim extension As String
Dim userId As Long
Dim created As String
Dim fileSize As Long
Dim width As String
Dim height As String
Dim attribute 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")
    albumId = jResp.IntOf("data[i].albumId")
    name = jResp.StringOf("data[i].name")
    description = jResp.StringOf("data[i].description")
    path = jResp.StringOf("data[i].path")
    v_type = jResp.StringOf("data[i].type")
    extension = jResp.StringOf("data[i].extension")
    userId = jResp.IntOf("data[i].userId")
    created = jResp.StringOf("data[i].created")
    fileSize = jResp.IntOf("data[i].fileSize")
    width = jResp.StringOf("data[i].width")
    height = jResp.StringOf("data[i].height")
    attribute = jResp.StringOf("data[i].attribute")
    i = i + 1
Loop