(PureBasic) Shopware 6 - Find Product by Name

See more Shopware 6 Examples

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

Chilkat PureBasic Module Download Chilkat PureBasic Module

IncludeFile "CkHttpResponse.pb"
IncludeFile "CkHttp.pb"
IncludeFile "CkStringBuilder.pb"
IncludeFile "CkJsonObject.pb"

Procedure ChilkatExample()

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

    http.i = CkHttp::ckCreate()
    If http.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    success.i

    ; 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

    json.i = CkJsonObject::ckCreate()
    If json.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    CkJsonObject::ckUpdateString(json,"filter[0].type","equals")
    CkJsonObject::ckUpdateString(json,"filter[0].field","name")
    CkJsonObject::ckUpdateString(json,"filter[0].value","Test123")
    CkJsonObject::ckUpdateString(json,"includes.product[0]","id")
    CkJsonObject::ckUpdateString(json,"includes.product[1]","name")
    ; 

    ; Load the access token previously obtained in Shopware 6 OAuth2 Client Credentials
    jsonToken.i = CkJsonObject::ckCreate()
    If jsonToken.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    CkJsonObject::ckLoadFile(jsonToken,"qa_data/tokens/shopware6.json")

    ; This causes the "Authorization: Bearer <access_token>" header to be added.
    CkHttp::setCkAuthToken(http, CkJsonObject::ckStringOf(jsonToken,"access_token"))

    ; Note: If you get a 401 response status code, then fetch a new access token and retry.
    resp.i = CkHttp::ckPostJson3(http,"https://my-shopware-6-shop.de/api/v3/search/product","application/json",json)
    If CkHttp::ckLastMethodSuccess(http) = 0
        Debug CkHttp::ckLastErrorText(http)
        CkHttp::ckDispose(http)
        CkJsonObject::ckDispose(json)
        CkJsonObject::ckDispose(jsonToken)
        ProcedureReturn
    EndIf

    sbResponseBody.i = CkStringBuilder::ckCreate()
    If sbResponseBody.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    CkHttpResponse::ckGetBodySb(resp,sbResponseBody)
    jResp.i = CkJsonObject::ckCreate()
    If jResp.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    CkJsonObject::ckLoadSb(jResp,sbResponseBody)
    CkJsonObject::setCkEmitCompact(jResp, 0)

    Debug "Response Body:"
    Debug CkJsonObject::ckEmit(jResp)

    ; If we get a 401 response, it may be that our access token expired and we need to fetch a new one.
    respStatusCode.i = CkHttpResponse::ckStatusCode(resp)
    Debug "Response Status Code = " + Str(respStatusCode)
    If respStatusCode >= 400
        Debug "Response Header:"
        Debug CkHttpResponse::ckHeader(resp)
        Debug "Failed."
        CkHttpResponse::ckDispose(resp)

        CkHttp::ckDispose(http)
        CkJsonObject::ckDispose(json)
        CkJsonObject::ckDispose(jsonToken)
        CkStringBuilder::ckDispose(sbResponseBody)
        CkJsonObject::ckDispose(jResp)
        ProcedureReturn
    EndIf

    CkHttpResponse::ckDispose(resp)

    ; 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": [
    ;   ]
    ; }

    numSearchResults.i = CkJsonObject::ckSizeOfArray(jResp,"data")
    If numSearchResults <> 1
        Debug "numSearchResults = " + Str(numSearchResults)
        Debug "Did not find the product, or unexpectedly found more than one with the same name."
        CkHttp::ckDispose(http)
        CkJsonObject::ckDispose(json)
        CkJsonObject::ckDispose(jsonToken)
        CkStringBuilder::ckDispose(sbResponseBody)
        CkJsonObject::ckDispose(jResp)
        ProcedureReturn
    EndIf

    productId.s = CkJsonObject::ckStringOf(jResp,"data[0].id")

    Debug "Product ID = " + productId


    CkHttp::ckDispose(http)
    CkJsonObject::ckDispose(json)
    CkJsonObject::ckDispose(jsonToken)
    CkStringBuilder::ckDispose(sbResponseBody)
    CkJsonObject::ckDispose(jResp)


    ProcedureReturn
EndProcedure