Visual FoxPro

Shopware 6 - Find Product by Name

See more Shopware 6 Examples

Find a product with a given name and get the id. Visual FoxPro

LOCAL lnSuccess
LOCAL loHttp
LOCAL loJson
LOCAL loJsonToken
LOCAL loResp
LOCAL loSbResponseBody
LOCAL loJResp
LOCAL lnRespStatusCode
LOCAL lnNumSearchResults
LOCAL lcProductId

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 to find the product named "Test123"

* POST /api/v3/search/product
* {
*     "filter": [
*         { "type": "equals", "field": "name", "value": "Test123" }
*     ],
*     "includes": {
*         "product": ["id", "name"]
*     }
* }

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

loJson = CreateObject('Chilkat.JsonObject')
loJson.UpdateString("filter[0].type","equals")
loJson.UpdateString("filter[0].field","name")
loJson.UpdateString("filter[0].value","Test123")
loJson.UpdateString("includes.product[0]","id")
loJson.UpdateString("includes.product[1]","name")
* 

* Load the access token previously obtained in Shopware 6 OAuth2 Client Credentials
loJsonToken = CreateObject('Chilkat.JsonObject')
loJsonToken.LoadFile("qa_data/tokens/shopware6.json")

* This causes the "Authorization: Bearer <access_token>" header to be added.
loHttp.AuthToken = loJsonToken.StringOf("access_token")

* Note: If you get a 401 response status code, then fetch a new access token and retry.
loResp = CreateObject('Chilkat.HttpResponse')
lnSuccess = loHttp.HttpJson("POST","https://my-shopware-6-shop.de/api/v3/search/product",loJson,"application/json",loResp)
IF (lnSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loJson
    RELEASE loJsonToken
    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 loJsonToken
    RELEASE loResp
    RELEASE loSbResponseBody
    RELEASE loJResp
    CANCEL
ENDIF

* The response looks like this:
* Use the following online tool to generate parsing code from sample JSON:
* Generate Parsing Code from JSON

* {
*   "data": [
*     {
*       "id": "d195dabb53cf46d096bd9a8726d82558",
*       "type": "product",
*       "attributes": {
*         "name": "Test123",
*         "apiAlias": null
*       },
*       "links": {
*         "self": "https:\/\/***.de\/api\/v3\/product\/d195dabb53cf46d096bd9a8726d82558"
*       },
*       "relationships": [
*       ],
*       "meta": null
*     }
*   ],
*   "included": [
*   ],
*   "links": {
*     "self": "https:\/\/***.de\/api\/v3\/search\/product"
*   },
*   "meta": {
*     "totalCountMode": 0,
*     "total": 1
*   },
*   "aggregations": [
*   ]
* }

lnNumSearchResults = loJResp.SizeOfArray("data")
IF (lnNumSearchResults <> 1) THEN
    ? "numSearchResults = " + STR(lnNumSearchResults)
    ? "Did not find the product, or unexpectedly found more than one with the same name."
    RELEASE loHttp
    RELEASE loJson
    RELEASE loJsonToken
    RELEASE loResp
    RELEASE loSbResponseBody
    RELEASE loJResp
    CANCEL
ENDIF

lcProductId = loJResp.StringOf("data[0].id")

? "Product ID = " + lcProductId

RELEASE loHttp
RELEASE loJson
RELEASE loJsonToken
RELEASE loResp
RELEASE loSbResponseBody
RELEASE loJResp