(AutoIt) MYOB: Fetch the Category Register

Return transactions grouped with categories A register of all transactions grouped with categories

For more information, see https://accountrightapi.myob.cloud/?version=latest#57d83b80-5dcb-4286-882e-5a1f6c2dc41a

Chilkat ActiveX Downloads

ActiveX for 32-bit and 64-bit Windows

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

$oHttp = ObjCreate("Chilkat.Http")
Local $bSuccess

; Implements the following CURL command:

; curl --request GET "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/CategoryRegister" \
;   --header "Authorization: Bearer ACCESS_TOKEN" \
;   --header "x-myobapi-key: {{myob_api_key}}" \
;   --header "x-myobapi-version: v2" \
;   --header "Accept-Encoding: gzip,deflate"

$oHttp.SetRequestHeader "Authorization","Bearer ACCESS_TOKEN"
$oHttp.SetRequestHeader "x-myobapi-key","{{myob_api_key}}"
$oHttp.SetRequestHeader "Accept-Encoding","gzip,deflate"
$oHttp.SetRequestHeader "x-myobapi-version","v2"

$oSbResponseBody = ObjCreate("Chilkat.StringBuilder")
$bSuccess = $oHttp.QuickGetSb("https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/CategoryRegister",$oSbResponseBody)
If ($bSuccess = False) Then
    ConsoleWrite($oHttp.LastErrorText & @CRLF)
    Exit
EndIf

$oJResp = ObjCreate("Chilkat.JsonObject")
$oJResp.LoadSb($oSbResponseBody)
$oJResp.EmitCompact = False

ConsoleWrite("Response Body:" & @CRLF)
ConsoleWrite($oJResp.Emit() & @CRLF)

Local $iRespStatusCode = $oHttp.LastStatus
ConsoleWrite("Response Status Code = " & $iRespStatusCode & @CRLF)
If ($iRespStatusCode >= 400) Then
    ConsoleWrite("Response Header:" & @CRLF)
    ConsoleWrite($oHttp.LastHeader & @CRLF)
    ConsoleWrite("Failed." & @CRLF)
    Exit
EndIf

; Sample JSON response:
; (Sample code for parsing the JSON response is shown below)

; {
;   "Items": [
;     {
;       "Category": {
;         "UID": "80b6a90d-e22a-47e3-a5e7-a2ee9126f153",
;         "Name": "Craigs Category",
;         "DisplayID": "Craigs",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/80b6a90d-e22a-47e3-a5e7-a2ee9126f153"
;       },
;       "Account": {
;         "UID": "40ecbafd-51c0-40f3-9a28-d6a2b6d7422a",
;         "Name": "Produce Income",
;         "DisplayID": "4-1000",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Account/40ecbafd-51c0-40f3-9a28-d6a2b6d7422a"
;       },
;       "Year": 2015,
;       "Month": 8,
;       "Activity": -1050,
;       "YearEndActivity": 0,
;       "RowVersion": "1093536881590665216"
;     },
;     {
;       "Category": {
;         "UID": "20b483b2-9a89-4793-b8c3-2da1a6284e1f",
;         "Name": "Postman sample",
;         "DisplayID": "Postman001",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/20b483b2-9a89-4793-b8c3-2da1a6284e1f"
;       },
;       "Account": {
;         "UID": "9541300c-edee-4e0b-82c0-9bc0d1917b2f",
;         "Name": "Grain Income",
;         "DisplayID": "4-2000",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Account/9541300c-edee-4e0b-82c0-9bc0d1917b2f"
;       },
;       "Year": 2015,
;       "Month": 8,
;       "Activity": -135.23,
;       "YearEndActivity": 0,
;       "RowVersion": "7736911480938823680"
;     },
;     {
;       "Category": {
;         "UID": "80b6a90d-e22a-47e3-a5e7-a2ee9126f153",
;         "Name": "Craigs Category",
;         "DisplayID": "Craigs",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/80b6a90d-e22a-47e3-a5e7-a2ee9126f153"
;       },
;       "Account": {
;         "UID": "80b97a33-a650-4f6c-9e40-d466d92e4bcb",
;         "Name": "GST Paid",
;         "DisplayID": "2-1220",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Account/80b97a33-a650-4f6c-9e40-d466d92e4bcb"
;       },
;       "Year": 2015,
;       "Month": 8,
;       "Activity": -105,
;       "YearEndActivity": 0,
;       "RowVersion": "1165594475628593152"
;     },
;     {
;       "Category": {
;         "UID": "20b483b2-9a89-4793-b8c3-2da1a6284e1f",
;         "Name": "Postman sample",
;         "DisplayID": "Postman001",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/20b483b2-9a89-4793-b8c3-2da1a6284e1f"
;       },
;       "Account": {
;         "UID": "80b97a33-a650-4f6c-9e40-d466d92e4bcb",
;         "Name": "GST Paid",
;         "DisplayID": "2-1220",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Account/80b97a33-a650-4f6c-9e40-d466d92e4bcb"
;       },
;       "Year": 2013,
;       "Month": 9,
;       "Activity": -62.5,
;       "YearEndActivity": 0,
;       "RowVersion": "4407341782405218304"
;     },
;     {
;       "Category": {
;         "UID": "20b483b2-9a89-4793-b8c3-2da1a6284e1f",
;         "Name": "Postman sample",
;         "DisplayID": "Postman001",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/20b483b2-9a89-4793-b8c3-2da1a6284e1f"
;       },
;       "Account": {
;         "UID": "80b97a33-a650-4f6c-9e40-d466d92e4bcb",
;         "Name": "GST Paid",
;         "DisplayID": "2-1220",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Account/80b97a33-a650-4f6c-9e40-d466d92e4bcb"
;       },
;       "Year": 2015,
;       "Month": 8,
;       "Activity": -29.15,
;       "YearEndActivity": 0,
;       "RowVersion": "7881026669014679552"
;     },
;     {
;       "Category": {
;         "UID": "20b483b2-9a89-4793-b8c3-2da1a6284e1f",
;         "Name": "Postman sample",
;         "DisplayID": "Postman001",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/20b483b2-9a89-4793-b8c3-2da1a6284e1f"
;       },
;       "Account": {
;         "UID": "9904f3e0-0ec1-4fee-be1c-477a8624d515",
;         "Name": "Inventory",
;         "DisplayID": "1-1320",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Account/9904f3e0-0ec1-4fee-be1c-477a8624d515"
;       },
;       "Year": 2015,
;       "Month": 8,
;       "Activity": -18.33,
;       "YearEndActivity": 0,
;       "RowVersion": "-1284645196637667328"
;     },
;     {
;       "Category": {
;         "UID": "20b483b2-9a89-4793-b8c3-2da1a6284e1f",
;         "Name": "Postman sample",
;         "DisplayID": "Postman001",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/20b483b2-9a89-4793-b8c3-2da1a6284e1f"
;       },
;       "Account": {
;         "UID": "180a940e-714d-4ebb-88db-3f6044294cad",
;         "Name": "Voluntary Withholdings Payable",
;         "DisplayID": "2-1310",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Account/180a940e-714d-4ebb-88db-3f6044294cad"
;       },
;       "Year": 2013,
;       "Month": 9,
;       "Activity": 3,
;       "YearEndActivity": 0,
;       "RowVersion": "4479399376443146240"
;     },
;     {
;       "Category": {
;         "UID": "20b483b2-9a89-4793-b8c3-2da1a6284e1f",
;         "Name": "Postman sample",
;         "DisplayID": "Postman001",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/20b483b2-9a89-4793-b8c3-2da1a6284e1f"
;       },
;       "Account": {
;         "UID": "44c2047b-5b16-43cf-82ee-d8a174ebec09",
;         "Name": "Voluntary Withholding Credits",
;         "DisplayID": "1-1340",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Account/44c2047b-5b16-43cf-82ee-d8a174ebec09"
;       },
;       "Year": 2013,
;       "Month": 9,
;       "Activity": 14,
;       "YearEndActivity": 0,
;       "RowVersion": "4335284188367290368"
;     },
;     {
;       "Category": {
;         "UID": "20b483b2-9a89-4793-b8c3-2da1a6284e1f",
;         "Name": "Postman sample",
;         "DisplayID": "Postman001",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/20b483b2-9a89-4793-b8c3-2da1a6284e1f"
;       },
;       "Account": {
;         "UID": "b2ff345a-2de6-4160-b319-66d01334a5ad",
;         "Name": "GST Collected",
;         "DisplayID": "2-1210",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Account/b2ff345a-2de6-4160-b319-66d01334a5ad"
;       },
;       "Year": 2015,
;       "Month": 8,
;       "Activity": 24.72,
;       "YearEndActivity": 0,
;       "RowVersion": "-1428760384713523200"
;     },
;     {
;       "Category": {
;         "UID": "20b483b2-9a89-4793-b8c3-2da1a6284e1f",
;         "Name": "Postman sample",
;         "DisplayID": "Postman001",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/20b483b2-9a89-4793-b8c3-2da1a6284e1f"
;       },
;       "Account": {
;         "UID": "40ecbafd-51c0-40f3-9a28-d6a2b6d7422a",
;         "Name": "Produce Income",
;         "DisplayID": "4-1000",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Account/40ecbafd-51c0-40f3-9a28-d6a2b6d7422a"
;       },
;       "Year": 2015,
;       "Month": 8,
;       "Activity": 90.91,
;       "YearEndActivity": 0,
;       "RowVersion": "-1572875572789379072"
;     },
;     {
;       "Category": {
;         "UID": "20b483b2-9a89-4793-b8c3-2da1a6284e1f",
;         "Name": "Postman sample",
;         "DisplayID": "Postman001",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/20b483b2-9a89-4793-b8c3-2da1a6284e1f"
;       },
;       "Account": {
;         "UID": "737c0032-a48a-48fa-930e-07da50005d0b",
;         "Name": "Cost Of Sales",
;         "DisplayID": "5-1000",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Account/737c0032-a48a-48fa-930e-07da50005d0b"
;       },
;       "Year": 2015,
;       "Month": 8,
;       "Activity": 91.66,
;       "YearEndActivity": 0,
;       "RowVersion": "-1212587602599739392"
;     },
;     {
;       "Category": {
;         "UID": "20b483b2-9a89-4793-b8c3-2da1a6284e1f",
;         "Name": "Postman sample",
;         "DisplayID": "Postman001",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/20b483b2-9a89-4793-b8c3-2da1a6284e1f"
;       },
;       "Account": {
;         "UID": "bb628b6e-b113-46df-bb22-cc73ebb33449",
;         "Name": "Trade Debtors",
;         "DisplayID": "1-1310",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Account/bb628b6e-b113-46df-bb22-cc73ebb33449"
;       },
;       "Year": 2015,
;       "Month": 8,
;       "Activity": 198.62,
;       "YearEndActivity": 0,
;       "RowVersion": "-1140530008561811456"
;     },
;     {
;       "Category": {
;         "UID": "20b483b2-9a89-4793-b8c3-2da1a6284e1f",
;         "Name": "Postman sample",
;         "DisplayID": "Postman001",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/20b483b2-9a89-4793-b8c3-2da1a6284e1f"
;       },
;       "Account": {
;         "UID": "72bec1c2-49a6-4b02-96d0-5ee79fefdefa",
;         "Name": "Trade Creditors",
;         "DisplayID": "2-1510",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Account/72bec1c2-49a6-4b02-96d0-5ee79fefdefa"
;       },
;       "Year": 2015,
;       "Month": 8,
;       "Activity": 320.7,
;       "YearEndActivity": 0,
;       "RowVersion": "7592796292862967808"
;     },
;     {
;       "Category": {
;         "UID": "20b483b2-9a89-4793-b8c3-2da1a6284e1f",
;         "Name": "Postman sample",
;         "DisplayID": "Postman001",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/20b483b2-9a89-4793-b8c3-2da1a6284e1f"
;       },
;       "Account": {
;         "UID": "6ef5febd-4027-4f87-9bb3-2f1d904eb948",
;         "Name": "Accum. Depr. Buildings",
;         "DisplayID": "1-2420",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Account/6ef5febd-4027-4f87-9bb3-2f1d904eb948"
;       },
;       "Year": 2013,
;       "Month": 9,
;       "Activity": 625,
;       "YearEndActivity": 0,
;       "RowVersion": "4263226594329362432"
;     },
;     {
;       "Category": {
;         "UID": "20b483b2-9a89-4793-b8c3-2da1a6284e1f",
;         "Name": "Postman sample",
;         "DisplayID": "Postman001",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/20b483b2-9a89-4793-b8c3-2da1a6284e1f"
;       },
;       "Account": {
;         "UID": "72bec1c2-49a6-4b02-96d0-5ee79fefdefa",
;         "Name": "Trade Creditors",
;         "DisplayID": "2-1510",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Account/72bec1c2-49a6-4b02-96d0-5ee79fefdefa"
;       },
;       "Year": 2013,
;       "Month": 9,
;       "Activity": 698.5,
;       "YearEndActivity": 0,
;       "RowVersion": "4191169000291434496"
;     },
;     {
;       "Category": {
;         "UID": "80b6a90d-e22a-47e3-a5e7-a2ee9126f153",
;         "Name": "Craigs Category",
;         "DisplayID": "Craigs",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/80b6a90d-e22a-47e3-a5e7-a2ee9126f153"
;       },
;       "Account": {
;         "UID": "b2ff345a-2de6-4160-b319-66d01334a5ad",
;         "Name": "GST Collected",
;         "DisplayID": "2-1210",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Account/b2ff345a-2de6-4160-b319-66d01334a5ad"
;       },
;       "Year": 2014,
;       "Month": 1,
;       "Activity": 909.09,
;       "YearEndActivity": 0,
;       "RowVersion": "-7193649382724468736"
;     },
;     {
;       "Category": {
;         "UID": "80b6a90d-e22a-47e3-a5e7-a2ee9126f153",
;         "Name": "Craigs Category",
;         "DisplayID": "Craigs",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/80b6a90d-e22a-47e3-a5e7-a2ee9126f153"
;       },
;       "Account": {
;         "UID": "72bec1c2-49a6-4b02-96d0-5ee79fefdefa",
;         "Name": "Trade Creditors",
;         "DisplayID": "2-1510",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Account/72bec1c2-49a6-4b02-96d0-5ee79fefdefa"
;       },
;       "Year": 2015,
;       "Month": 8,
;       "Activity": 1155,
;       "YearEndActivity": 0,
;       "RowVersion": "1021479287552737280"
;     },
;     {
;       "Category": {
;         "UID": "80b6a90d-e22a-47e3-a5e7-a2ee9126f153",
;         "Name": "Craigs Category",
;         "DisplayID": "Craigs",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/80b6a90d-e22a-47e3-a5e7-a2ee9126f153"
;       },
;       "Account": {
;         "UID": "40ecbafd-51c0-40f3-9a28-d6a2b6d7422a",
;         "Name": "Produce Income",
;         "DisplayID": "4-1000",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Account/40ecbafd-51c0-40f3-9a28-d6a2b6d7422a"
;       },
;       "Year": 2014,
;       "Month": 1,
;       "Activity": 9090.91,
;       "YearEndActivity": 0,
;       "RowVersion": "-7265706976762396672"
;     },
;     {
;       "Category": {
;         "UID": "80b6a90d-e22a-47e3-a5e7-a2ee9126f153",
;         "Name": "Craigs Category",
;         "DisplayID": "Craigs",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/80b6a90d-e22a-47e3-a5e7-a2ee9126f153"
;       },
;       "Account": {
;         "UID": "bb628b6e-b113-46df-bb22-cc73ebb33449",
;         "Name": "Trade Debtors",
;         "DisplayID": "1-1310",
;         "URI": "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Account/bb628b6e-b113-46df-bb22-cc73ebb33449"
;       },
;       "Year": 2014,
;       "Month": 1,
;       "Activity": 10000,
;       "YearEndActivity": 0,
;       "RowVersion": "-7337764570800324608"
;     }
;   ],
;   "NextPageLink": null,
;   "Count": 19
; }

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

Local $sNextPageLink
Local $iCount
Local $i
Local $iCount_i
Local $sCategoryUID
Local $sCategoryName
Local $sCategoryDisplayID
Local $sCategoryURI
Local $sAccountUID
Local $sAccountName
Local $sAccountDisplayID
Local $sAccountURI
Local $iYear
Local $iMonth
Local $iActivity
Local $iYearEndActivity
Local $sRowVersion

$sNextPageLink = $oJResp.StringOf("NextPageLink")
$iCount = $oJResp.IntOf("Count")
$i = 0
$iCount_i = $oJResp.SizeOfArray("Items")
While $i < $iCount_i
    $oJResp.I = $i
    $sCategoryUID = $oJResp.StringOf("Items[i].Category.UID")
    $sCategoryName = $oJResp.StringOf("Items[i].Category.Name")
    $sCategoryDisplayID = $oJResp.StringOf("Items[i].Category.DisplayID")
    $sCategoryURI = $oJResp.StringOf("Items[i].Category.URI")
    $sAccountUID = $oJResp.StringOf("Items[i].Account.UID")
    $sAccountName = $oJResp.StringOf("Items[i].Account.Name")
    $sAccountDisplayID = $oJResp.StringOf("Items[i].Account.DisplayID")
    $sAccountURI = $oJResp.StringOf("Items[i].Account.URI")
    $iYear = $oJResp.IntOf("Items[i].Year")
    $iMonth = $oJResp.IntOf("Items[i].Month")
    $iActivity = $oJResp.IntOf("Items[i].Activity")
    $iYearEndActivity = $oJResp.IntOf("Items[i].YearEndActivity")
    $sRowVersion = $oJResp.StringOf("Items[i].RowVersion")
    $i = $i + 1
Wend