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

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

li_Success = 0

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

loo_Http = create oleobject
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
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 = create oleobject
li_rc = loo_Resp.ConnectToNewObject("Chilkat.HttpResponse")

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

loo_SbResponseBody = create oleobject
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_Http
    destroy loo_Json
    destroy loo_Resp
    destroy loo_SbResponseBody
    return
end if

//  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
    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
    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_Resp
destroy loo_SbResponseBody
destroy loo_JRespArr
destroy loo_JResp