Xojo Plugin
Xojo Plugin
GetHarvest - List Clients
See more GetHarvest Examples
Returns a list of your clients.Chilkat Xojo Plugin Downloads
Dim success As Boolean
success = False
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
Dim http As New Chilkat.Http
// Implements the following CURL command:
// curl "https://api.harvestapp.com/v2/clients" \
// -H "Authorization: Bearer ACCESS_TOKEN" \
// -H "Harvest-Account-Id: ACCOUNT_ID" \
// -H "User-Agent: MyApp (yourname@example.com)"
http.SetRequestHeader "User-Agent","MyApp (yourname@example.com)"
http.SetRequestHeader "Authorization","Bearer ACCESS_TOKEN"
http.SetRequestHeader "Harvest-Account-Id","ACCOUNT_ID"
Dim sbResponseBody As New Chilkat.StringBuilder
success = http.QuickGetSb("https://api.harvestapp.com/v2/clients",sbResponseBody)
If (success = False) Then
System.DebugLog(http.LastErrorText)
Return
End If
Dim jResp As New Chilkat.JsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False
System.DebugLog("Response Body:")
System.DebugLog(jResp.Emit())
Dim respStatusCode As Int32
respStatusCode = http.LastStatus
System.DebugLog("Response Status Code = " + Str(respStatusCode))
If (respStatusCode >= 400) Then
System.DebugLog("Response Header:")
System.DebugLog(http.LastHeader)
System.DebugLog("Failed.")
Return
End If
// Sample JSON response:
// {
// "clients": [
// {
// "id": 5735776,
// "name": "123 Industries",
// "is_active": true,
// "address": "123 Main St.\r\nAnytown, LA 71223",
// "created_at": "2017-06-26T21:02:12Z",
// "updated_at": "2017-06-26T21:34:11Z",
// "currency": "EUR"
// },
// {
// "id": 5735774,
// "name": "ABC Corp",
// "is_active": true,
// "address": "456 Main St.\r\nAnytown, CT 06467",
// "created_at": "2017-06-26T21:01:52Z",
// "updated_at": "2017-06-26T21:27:07Z",
// "currency": "USD"
// }
// ],
// "per_page": 100,
// "total_pages": 1,
// "total_entries": 2,
// "next_page": null,
// "previous_page": null,
// "page": 1,
// "links": {
// "first": "https://api.harvestapp.com/v2/clients?page=1&per_page=100",
// "next": null,
// "previous": null,
// "last": "https://api.harvestapp.com/v2/clients?page=1&per_page=100"
// }
// }
// Sample code for parsing the JSON response...
// Use the following online tool to generate parsing code from sample JSON:
// Generate Parsing Code from JSON
Dim per_page As Int32
Dim total_pages As Int32
Dim total_entries As Int32
Dim next_page As String
Dim previous_page As String
Dim page As Int32
Dim linksFirst As String
Dim linksNext As String
Dim linksPrevious As String
Dim linksLast As String
Dim i As Int32
Dim count_i As Int32
Dim id As Int32
Dim name As String
Dim is_active As Boolean
Dim address As String
Dim created_at As String
Dim updated_at As String
Dim currency As String
per_page = jResp.IntOf("per_page")
total_pages = jResp.IntOf("total_pages")
total_entries = jResp.IntOf("total_entries")
next_page = jResp.StringOf("next_page")
previous_page = jResp.StringOf("previous_page")
page = jResp.IntOf("page")
linksFirst = jResp.StringOf("links.first")
linksNext = jResp.StringOf("links.next")
linksPrevious = jResp.StringOf("links.previous")
linksLast = jResp.StringOf("links.last")
i = 0
count_i = jResp.SizeOfArray("clients")
While i < count_i
jResp.I = i
id = jResp.IntOf("clients[i].id")
name = jResp.StringOf("clients[i].name")
is_active = jResp.BoolOf("clients[i].is_active")
address = jResp.StringOf("clients[i].address")
created_at = jResp.StringOf("clients[i].created_at")
updated_at = jResp.StringOf("clients[i].updated_at")
currency = jResp.StringOf("clients[i].currency")
i = i + 1
Wend