(Excel) GetHarvest - Test Personal Access Token

Demonstrates how to test your GetHarvest Personal Access Token

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

http.SetRequestHeader "User-Agent","Harvest API Example"
http.SetRequestHeader "Harvest-Account-ID","ACCOUNT_ID"
http.SetRequestHeader "Authorization","Bearer ACCESS_TOKEN"

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = http.QuickGetSb("https://api.harvestapp.com/api/v2/users/me.json",sbResponseBody)
If (success <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

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 = http.LastStatus
Debug.Print "Response Status Code = "; respStatusCode

If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print http.LastResponseHeader
    Exit Sub
End If

' Sample JSON response:

' {
'   "id": 2826142,
'   "first_name": "Joe",
'   "last_name": "Johnson",
'   "email": "joe@example.com",
'   "telephone": "",
'   "timezone": "Central Time (US & Canada)",
'   "weekly_capacity": 126000,
'   "has_access_to_all_future_projects": false,
'   "is_contractor": false,
'   "is_admin": true,
'   "is_project_manager": false,
'   "can_see_rates": true,
'   "can_create_projects": true,
'   "can_create_invoices": true,
'   "is_active": true,
'   "created_at": "2019-06-06T15:57:58Z",
'   "updated_at": "2019-06-06T15:58:32Z",
'   "default_hourly_rate": 175.0,
'   "cost_rate": 60.0,
'   "roles": [
'     "role1",
'     "role2"
'   ],
'   "avatar_url": "https://d3s3969qhosaug.cloudfront.net/default-avatars/4d46.png?1559836678"
' }

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

id = jResp.IntOf("id")
first_name = jResp.StringOf("first_name")
last_name = jResp.StringOf("last_name")
email = jResp.StringOf("email")
telephone = jResp.StringOf("telephone")
timezone = jResp.StringOf("timezone")
weekly_capacity = jResp.IntOf("weekly_capacity")
has_access_to_all_future_projects = jResp.BoolOf("has_access_to_all_future_projects")
is_contractor = jResp.BoolOf("is_contractor")
is_admin = jResp.BoolOf("is_admin")
is_project_manager = jResp.BoolOf("is_project_manager")
can_see_rates = jResp.BoolOf("can_see_rates")
can_create_projects = jResp.BoolOf("can_create_projects")
can_create_invoices = jResp.BoolOf("can_create_invoices")
is_active = jResp.BoolOf("is_active")
created_at = jResp.StringOf("created_at")
updated_at = jResp.StringOf("updated_at")
default_hourly_rate = jResp.StringOf("default_hourly_rate")
cost_rate = jResp.StringOf("cost_rate")
avatar_url = jResp.StringOf("avatar_url")
i = 0
count_i = jResp.SizeOfArray("roles")
Do While i < count_i
    jResp.I = i
    strVal = jResp.StringOf("roles[i]")
    i = i + 1
Loop