Visual FoxPro

Shopware 6 -List Currencies

See more Shopware 6 Examples

With store-api.currency you can fetch all currencies that are available in this Sales Channel. Visual FoxPro

LOCAL lnSuccess
LOCAL loHttp
LOCAL loJson
LOCAL loResp
LOCAL loSbResponseBody
LOCAL lnRespStatusCode
LOCAL lcFactor
LOCAL lcShortName
LOCAL lcName
LOCAL lcId
LOCAL lcApiAlias
LOCAL loJRespArr
LOCAL loJCurrency
LOCAL i
LOCAL lnCount_i
LOCAL loJResp

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/currency
* {
*     "includes": {
*         "currency": [
*             "id",
*             "factor",
*             "shortName",
*             "name"
*         ]
*     }
* }

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

loJson = CreateObject('Chilkat.JsonObject')
loJson.UpdateString("includes.currency[0]","id")
loJson.UpdateString("includes.currency[1]","factor")
loJson.UpdateString("includes.currency[2]","shortName")
loJson.UpdateString("includes.currency[3]","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/currency",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)

? loSbResponseBody.GetAsString()

* 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
    CANCEL
ENDIF

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

* A single object can be returned.

* {
*   "factor": 1,
*   "shortName": "EUR",
*   "name": "Euro",
*   "id": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
*   "apiAlias": "currency"
* }

* or an array of currency objects can be returned:

* [
*     {
*         "factor": 0.89157,
*         "shortName": "GBP",
*         "name": "Pound",
*         "id": "01913e4cbe604f45be84cbabd5966239",
*         "apiAlias": "currency"
*     },
*     {
*         "factor": 10.51,
*         "shortName": "SEK",
*         "name": "Swedish krone",
*         "id": "3dfbaa78994b4f1cac491f1a992646fd",
*         "apiAlias": "currency"
*     }
* ]

* Sample code for parsing the JSON response...
* Use the following online tool to generate parsing code from sample JSON:
* Generate Parsing Code from JSON

loSbResponseBody.Trim()
IF (loSbResponseBody.StartsWith("[",0) = 1) THEN
    * This is an array.
    loJRespArr = CreateObject('Chilkat.JsonArray')

    loJRespArr.LoadSb(loSbResponseBody)

    i = 0
    lnCount_i = loJRespArr.Size
    DO WHILE i < lnCount_i
        loJCurrency = loJRespArr.ObjectAt(i)
        lcFactor = loJCurrency.StringOf("factor")
        lcShortName = loJCurrency.StringOf("shortName")
        lcName = loJCurrency.StringOf("name")
        lcId = loJCurrency.StringOf("id")
        lcApiAlias = loJCurrency.StringOf("apiAlias")
        RELEASE loJCurrency
        i = i + 1
    ENDDO

ELSE
    * This is a single currency.
    loJResp = CreateObject('Chilkat.JsonObject')

    loJResp.LoadSb(loSbResponseBody)
    loJResp.EmitCompact = 0

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

    lcFactor = loJResp.StringOf("factor")
    lcShortName = loJResp.StringOf("shortName")
    lcName = loJResp.StringOf("name")
    lcId = loJResp.StringOf("id")
    lcApiAlias = loJResp.StringOf("apiAlias")
ENDIF

RELEASE loHttp
RELEASE loJson
RELEASE loResp
RELEASE loSbResponseBody
RELEASE loJRespArr
RELEASE loJResp