Xojo Plugin

Shopware List Media

See more Shopware Examples

Demonstrates how to get a list of media in Shopware. Xojo Plugin

Dim success As Boolean
success = False

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

Dim http As New Chilkat.Http

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

Dim sbResponseBody As New Chilkat.StringBuilder
success = http.QuickGetSb("https://my-shopware-shop.com/api/media?limit=10",sbResponseBody)
If (success = False) Then
    System.DebugLog(http.LastErrorText)
    Return
End If

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

System.DebugLog("Response Body:")
System.DebugLog(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 Int32
Dim albumId As Int32
Dim name As String
Dim description As String
Dim path As String
Dim v_type As String
Dim extension As String
Dim userId As Int32
Dim created As String
Dim fileSize As Int32
Dim width As String
Dim height As String
Dim attribute As String

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