(Excel) Aruba Fatturazione Elettronica refresh

The token can be renewed by submitting a refresh request, which requires the following parameters in the format application/x-www-form-urlencoded with UTF-8 encoding. Refreshing the token, avoiding sending login details, offers more security and a more efficient process than requesting a new token via signin.

For more information, see https://fatturazioneelettronica.aruba.it/apidoc/docs_EN.html#auth-refresh

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Implements the following CURL command:

' curl -X POST https://auth.fatturazioneelettronica.aruba.it/auth/signin \
'   -H "Content-Type: application/x-www-form-urlencoded;charset=UTF-8" \
'   -d 'grant_type=refresh_token&refresh_token=ee4aae0c9d754ad08a657510cae82efe'

' Use the following online tool to generate HTTP code from a CURL command
' Convert a cURL Command to HTTP Source Code

Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest
req.HttpVerb = "POST"
req.Path = "/auth/signin"
req.ContentType = "application/x-www-form-urlencoded"
req.AddParam "grant_type","refresh_token"
req.AddParam "refresh_token","ee4aae0c9d754ad08a657510cae82efe"


Set resp = http.PostUrlEncoded("https://auth.fatturazioneelettronica.aruba.it/auth/signin",req)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
Dim success As Boolean
success = resp.GetBodySb(sbResponseBody)
Dim jResp As Chilkat.JsonObject
Set jResp = Chilkat.NewJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False

Debug.Print "Response Body:"
Debug.Print jResp.Emit()


respStatusCode = resp.StatusCode
Debug.Print "Response Status Code = "; respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print resp.Header
    Debug.Print "Failed."

    Exit Sub
End If

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

' {
'   "access_token": "29dba5b2e749e403",
'   "token_type": "bearer",
'   "expires_in": 1800,
'   "refresh_token": "5da9e6c31c8b9b24",
'   "userName": "Utente",
'   "as:client_id": "Auth",
'   ".issued": "Fri, 10 Jul 2020 07:20:00 GMT",
'   ".expires": "Fri, 10 Jul 2020 07:50:00 GMT"
' }

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


access_token = jResp.StringOf("access_token")

token_type = jResp.StringOf("token_type")

expires_in = jResp.IntOf("expires_in")

refresh_token = jResp.StringOf("refresh_token")

userName = jResp.StringOf("userName")

as_client_id = jResp.StringOf("as:client_id")

v_issued = jResp.StringOf(""".issued""")

v_expires = jResp.StringOf(""".expires""")