(Lianja) 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/

Chilkat Lianja Extension Download Chilkat Lianja Extension

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

loHttp = createobject("CkHttp")

loHttp.Login = "api_username"
loHttp.Password = "api_key"
loHttp.BasicAuth = .T.

loSbResponseBody = createobject("CkStringBuilder")
llSuccess = loHttp.QuickGetSb("https://my-shopware-shop.com/api/categories?limit=2",loSbResponseBody)
if (llSuccess = .F.) then
    ? loHttp.LastErrorText
    release loHttp
    release loSbResponseBody
    return
endif

loJResp = createobject("CkJsonObject")
loJResp.LoadSb(loSbResponseBody)
loJResp.EmitCompact = .F.

? "Response Body:"
? loJResp.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

lnTotal = loJResp.IntOf("total")
llSuccess = loJResp.BoolOf("success")
i = 0
lnCount_i = loJResp.SizeOfArray("data")
do while i < lnCount_i
    loJResp.I = i
    lnId = loJResp.IntOf("data[i].id")
    llActive = loJResp.BoolOf("data[i].active")
    lcName = loJResp.StringOf("data[i].name")
    lnPosition = loJResp.IntOf("data[i].position")
    lcParentId = loJResp.StringOf("data[i].parentId")
    lcMediaId = loJResp.StringOf("data[i].mediaId")
    lcChildrenCount = loJResp.StringOf("data[i].childrenCount")
    lcArticleCount = loJResp.StringOf("data[i].articleCount")
    i = i + 1
enddo


release loHttp
release loSbResponseBody
release loJResp