Visual FoxPro

Shopware 6 - List Products

See more Shopware 6 Examples

Get a list of products. Visual FoxPro

LOCAL lnSuccess
LOCAL loHttp
LOCAL loJson
LOCAL loResp
LOCAL loSbResponseBody
LOCAL loJResp
LOCAL lnRespStatusCode
LOCAL lcId
LOCAL lcName
LOCAL lnTotal
LOCAL lcApiAlias
LOCAL i
LOCAL lnCount_i

lnSuccess = 0

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

loHttp = CreateObject('Chilkat.Http')

* Sends the following POST

* POST /store-api/v3/product
* {
*     "includes": {
*         "product": ["id", "name"]
*     }
* }

* Use this online tool to generate code from sample JSON:
* Generate Code to Create JSON

loJson = CreateObject('Chilkat.JsonObject')
loJson.UpdateString("includes.product[0]","id")
loJson.UpdateString("includes.product[1]","name")

* This request simply authenticates with the sw-access-key you can interactively copy from your 
* sales channel in the Shopware 6 administration web portal.
* We do NOT use OAuth2 for Store API requests.
loHttp.SetRequestHeader("sw-access-key","<sales-channel-api-access-key>")

loResp = CreateObject('Chilkat.HttpResponse')
lnSuccess = loHttp.HttpJson("POST","https://my-shopware-6-shop.de/store-api/v3/product",loJson,"application/json",loResp)
IF (lnSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loJson
    RELEASE loResp
    CANCEL
ENDIF

loSbResponseBody = CreateObject('Chilkat.StringBuilder')
loResp.GetBodySb(loSbResponseBody)
loJResp = CreateObject('Chilkat.JsonObject')
loJResp.LoadSb(loSbResponseBody)
loJResp.EmitCompact = 0

? "Response Body:"
? loJResp.Emit()

* If we get a 401 response, it may be that our access token expired and we need to fetch a new one.
lnRespStatusCode = loResp.StatusCode
? "Response Status Code = " + STR(lnRespStatusCode)
IF (lnRespStatusCode >= 400) THEN
    ? "Response Header:"
    ? loResp.Header
    ? "Failed."
    RELEASE loHttp
    RELEASE loJson
    RELEASE loResp
    RELEASE loSbResponseBody
    RELEASE loJResp
    CANCEL
ENDIF

* Sample JSON response:
* (Sample code for parsing the JSON response is shown below)

* {
*   "total": 2,
*   "aggregations": [],
*   "elements": [
*     {
*       "id": "00a284072bcb42ed8fee31e26ea53b60",
*       "name": "Synergistic Wooden Coffee Patch",
*       "apiAlias": "product"
*     },
*     {
*       "id": "bd835e75afa14b09b7da156d095a9a30",
*       "name": "Intelligent Cotton Presto Pesto",
*       "apiAlias": "product"
*     }
*   ],
*   "apiAlias": "dal_entity_search_result"
* }

* 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")
lcApiAlias = loJResp.StringOf("apiAlias")
i = 0
lnCount_i = loJResp.SizeOfArray("elements")
DO WHILE i < lnCount_i
    loJResp.I = i
    lcId = loJResp.StringOf("elements[i].id")
    lcName = loJResp.StringOf("elements[i].name")
    lcApiAlias = loJResp.StringOf("elements[i].apiAlias")
    i = i + 1
ENDDO

RELEASE loHttp
RELEASE loJson
RELEASE loResp
RELEASE loSbResponseBody
RELEASE loJResp