(Excel) Get Akeneo Token given Client ID and Secret

Assumes you're starting with a client ID and secret obtained from your OAuth1 provider, such as OneLogin. Demonstrates how to get an akeneo token using your client id/secret in combination with your akeneo login/password.

Download Excel Class Modules Chilkat Excel Class Modules

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

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

' The HTTP Basic authentication for this request is the
' OAuth client id and secret you've already obtained.
http.BasicAuth = True
http.Login = "my_akeneo_client_id"
http.Password = "my_akeneo_secret"

' Build this JSON:
' {
'   "grant_type": "password",
'   "username": "yourusername",
'   "password": "yourpassword"
' }

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
Dim success As Boolean
success = json.UpdateString("grant_type","password")
success = json.UpdateString("username","my_akeneo_username")
success = json.UpdateString("password","my_akeneo_password")

' POST this JSON (with the Basic Authentication header)

url = "http://pim.my-akeneo-site.com/api/oauth/v1/token"

Set resp = http.PostJson3(url,"application/json",json)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "Response status code: "; resp.StatusCode
Debug.Print "Response body: "; resp.BodyStr

If (resp.StatusCode = 200) Then
    ' Success.
    ' Parse the response, which looks like this:

    ' 		{
    ' 		    "access_token": "MTE0NzNkNzI5YTk0ZTBlNmFlNTI5NmVkOWJhZjUxYWRkN2UzZWIwOWNkMTkwNzY5Mzk3NGViMDFmYzdlODJlMg",
    ' 		    "expires_in": 3600,
    ' 		    "token_type": "bearer",
    ' 		    "scope": null,
    ' 		    "refresh_token": "ZDkyMzA2NDhlZjQ2MGQyMDQ2MWRiMDBmOTdkZjQ5ODY5Mzc3MTEzMjVkNTkwZThmNWRlNWY0MzllYWMxZWQ5ZA"
    ' 		}

    success = json.Load(resp.BodyStr)

    access_token = json.StringOf("access_token")

    expires_in = json.IntOf("expires_in")

    token_type = json.StringOf("token_type")

    scope = json.StringOf("scope")

    refresh_token = json.StringOf("refresh_token")

    Debug.Print "Access Token: "; access_token
End If