(Excel) MYOB: Get List of Company Files

Gets a list of company files.

For more information, see https://developer.myob.com/api/accountright/v2/company-files/

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

http.AuthToken = "ACCESS_TOKEN"

http.Accept = "application/json"

http.SetRequestHeader "x-myobapi-key","MYOB_API_KEY"
http.SetRequestHeader "x-myobapi-version","v2"


strResp = http.QuickGetStr("https://ar1.api.myob.com/accountright")
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "Response Status Code: "; http.LastStatus

Dim jsonResponse As Chilkat.JsonObject
Set jsonResponse = Chilkat.NewJsonObject
Dim success As Boolean
success = jsonResponse.Load(strResp)
jsonResponse.EmitCompact = False
Debug.Print jsonResponse.Emit()

If (http.LastStatus <> 200) Then
    Debug.Print "Failed."
    Exit Sub
End If

' Sample output...
' (See the parsing code below..)
' 
' Use the this online tool to generate parsing code from sample JSON: 
' Generate Parsing Code from JSON

' {
'   "Id": "d2014f64-ffdf-487b-8d12-67a20976aca6",
'   "Name": "Internal Sandbox API",
'   "LibraryPath": "Internal Sandbox API",
'   "ProductVersion": "2013.0",
'   "ProductLevel": {
'     "Code": 20,
'     "Name": "Standard"
'   },
'   "CheckedOutDate": "2013-06-11T01:47:47.0065514",
'   "CheckedOutBy": "developers@myob.com",
'   "Uri": "{cf_uri}",
'   "Country": "AU"
' }
' 

Id = jsonResponse.StringOf("Id")
Name = jsonResponse.StringOf("Name")
LibraryPath = jsonResponse.StringOf("LibraryPath")
ProductVersion = jsonResponse.StringOf("ProductVersion")
ProductLevelCode = jsonResponse.IntOf("ProductLevel.Code")
ProductLevelName = jsonResponse.StringOf("ProductLevel.Name")
CheckedOutDate = jsonResponse.StringOf("CheckedOutDate")
CheckedOutBy = jsonResponse.StringOf("CheckedOutBy")
Uri = jsonResponse.StringOf("Uri")
Country = jsonResponse.StringOf("Country")