(PowerBuilder) 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.

For more information, see https://docs.shopware.com/en/shopware-platform-dev-en/store-api-guide/sales-channel?category=shopware-platform-dev-en/store-api-guide#available-currencies

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

integer li_rc
oleobject loo_Http
integer li_Success
oleobject loo_Json
oleobject loo_Resp
oleobject loo_SbResponseBody
integer li_RespStatusCode
string ls_Factor
string ls_ShortName
string ls_Name
string ls_Id
string ls_ApiAlias
oleobject loo_JRespArr
oleobject loo_JCurrency
integer i
integer li_Count_i
oleobject loo_JResp

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

loo_Http = create oleobject
// Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
if li_rc < 0 then
    destroy loo_Http
    MessageBox("Error","Connecting to COM object failed")
    return
end if

// 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

loo_Json = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")

loo_Json.UpdateString("includes.currency[0]","id")
loo_Json.UpdateString("includes.currency[1]","factor")
loo_Json.UpdateString("includes.currency[2]","shortName")
loo_Json.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.
loo_Http.SetRequestHeader("sw-access-key","<sales-channel-api-access-key>")

loo_Resp = loo_Http.PostJson3("https://my-shopware-6-shop.de/store-api/v3/currency","application/json",loo_Json)
if loo_Http.LastMethodSuccess = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_Json
    return
end if

loo_SbResponseBody = create oleobject
// Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
li_rc = loo_SbResponseBody.ConnectToNewObject("Chilkat.StringBuilder")

loo_Resp.GetBodySb(loo_SbResponseBody)

Write-Debug loo_SbResponseBody.GetAsString()

// If we get a 401 response, it may be that our access token expired and we need to fetch a new one.
li_RespStatusCode = loo_Resp.StatusCode
Write-Debug "Response Status Code = " + string(li_RespStatusCode)
if li_RespStatusCode >= 400 then
    Write-Debug "Response Header:"
    Write-Debug loo_Resp.Header
    Write-Debug "Failed."
    destroy loo_Resp
    destroy loo_Http
    destroy loo_Json
    destroy loo_SbResponseBody
    return
end if

destroy loo_Resp

// 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

loo_SbResponseBody.Trim()
if loo_SbResponseBody.StartsWith("[",0) = 1 then
    // This is an array.
    loo_JRespArr = create oleobject
    // Use "Chilkat_9_5_0.JsonArray" for versions of Chilkat < 10.0.0
    li_rc = loo_JRespArr.ConnectToNewObject("Chilkat.JsonArray")

    loo_JRespArr.LoadSb(loo_SbResponseBody)

    i = 0
    li_Count_i = loo_JRespArr.Size
    do while i < li_Count_i
        loo_JCurrency = loo_JRespArr.ObjectAt(i)
        ls_Factor = loo_JCurrency.StringOf("factor")
        ls_ShortName = loo_JCurrency.StringOf("shortName")
        ls_Name = loo_JCurrency.StringOf("name")
        ls_Id = loo_JCurrency.StringOf("id")
        ls_ApiAlias = loo_JCurrency.StringOf("apiAlias")
        destroy loo_JCurrency
        i = i + 1
    loop

else
    // This is a single currency.
    loo_JResp = create oleobject
    // Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
    li_rc = loo_JResp.ConnectToNewObject("Chilkat.JsonObject")

    loo_JResp.LoadSb(loo_SbResponseBody)
    loo_JResp.EmitCompact = 0

    Write-Debug "Response Body:"
    Write-Debug loo_JResp.Emit()

    ls_Factor = loo_JResp.StringOf("factor")
    ls_ShortName = loo_JResp.StringOf("shortName")
    ls_Name = loo_JResp.StringOf("name")
    ls_Id = loo_JResp.StringOf("id")
    ls_ApiAlias = loo_JResp.StringOf("apiAlias")
end if



destroy loo_Http
destroy loo_Json
destroy loo_SbResponseBody
destroy loo_JRespArr
destroy loo_JResp