(Excel) Get Populi Access Key (Token)

Demonstrates how to authenticate and obtain an access key using a username and password.

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 rest As Chilkat.Rest
Set rest = Chilkat.NewRest

' Connect using TLS.
' A single REST object, once connected, can be used for many Populi REST API calls.
' The auto-reconnect indicates that if the already-established HTTPS connection is closed,
' then it will be automatically re-established as needed.

bAutoReconnect = True

success = rest.Connect("yourcollege.populi.co",443,True,bAutoReconnect)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

success = rest.AddQueryParam("username","POPULI_USERNAME")
success = rest.AddQueryParam("password","POPULI_PASSWORD")


responseBody = rest.FullRequestFormUrlEncoded("POST","/api/index.php")
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' We should expect a 200 response if successful.
If (rest.ResponseStatusCode <> 200) Then
    Debug.Print "Request Header: "
    Debug.Print rest.LastRequestHeader
    Debug.Print "----"
    Debug.Print "Response StatusCode = "; rest.ResponseStatusCode
    Debug.Print "Response StatusLine: "; rest.ResponseStatusText
    Debug.Print "Response Header:"
    Debug.Print rest.ResponseHeader
    Debug.Print "Response Body:"
    Debug.Print responseBody
    Exit Sub
End If

Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml
success = xml.LoadXml(responseBody)
Debug.Print xml.GetXml()

' Sample response:
' <?xml version="1.0" encoding="ISO-8859-1"?>
' <response>
' <access_key>63481e36023b5d ... 76d0dbc314</access_key>
'     <accountid>19999999</accountid>
'     <accounttype>PERSON</accounttype>
' </response>

' Save the XML to a file for subsequent requests..
success = xml.SaveXml("qa_data/tokens/populi_token.xml")