PowerBuilder
PowerBuilder
MYOB: Fetch the Category Register
See more MYOB Examples
Return transactions grouped with categories A register of all transactions grouped with categoriesChilkat PowerBuilder Downloads
integer li_rc
integer li_Success
oleobject loo_Http
oleobject loo_SbResponseBody
oleobject loo_JResp
integer li_RespStatusCode
string ls_NextPageLink
integer li_Count
integer i
integer li_Count_i
string ls_CategoryUID
string ls_CategoryName
string ls_CategoryDisplayID
string ls_CategoryURI
string ls_AccountUID
string ls_AccountName
string ls_AccountDisplayID
string ls_AccountURI
integer li_Year
integer li_Month
integer li_Activity
integer li_YearEndActivity
string ls_RowVersion
li_Success = 0
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
loo_Http = create oleobject
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
if li_rc < 0 then
destroy loo_Http
MessageBox("Error","Connecting to COM object failed")
return
end if
// 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"
loo_Http.SetRequestHeader("Authorization","Bearer ACCESS_TOKEN")
loo_Http.SetRequestHeader("x-myobapi-key","{{myob_api_key}}")
loo_Http.SetRequestHeader("Accept-Encoding","gzip,deflate")
loo_Http.SetRequestHeader("x-myobapi-version","v2")
loo_SbResponseBody = create oleobject
li_rc = loo_SbResponseBody.ConnectToNewObject("Chilkat.StringBuilder")
li_Success = loo_Http.QuickGetSb("https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/CategoryRegister",loo_SbResponseBody)
if li_Success = 0 then
Write-Debug loo_Http.LastErrorText
destroy loo_Http
destroy loo_SbResponseBody
return
end if
loo_JResp = create oleobject
li_rc = loo_JResp.ConnectToNewObject("Chilkat.JsonObject")
loo_JResp.LoadSb(loo_SbResponseBody)
loo_JResp.EmitCompact = 0
Write-Debug "Response Body:"
Write-Debug loo_JResp.Emit()
li_RespStatusCode = loo_Http.LastStatus
Write-Debug "Response Status Code = " + string(li_RespStatusCode)
if li_RespStatusCode >= 400 then
Write-Debug "Response Header:"
Write-Debug loo_Http.LastHeader
Write-Debug "Failed."
destroy loo_Http
destroy loo_SbResponseBody
destroy loo_JResp
return
end if
// 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
ls_NextPageLink = loo_JResp.StringOf("NextPageLink")
li_Count = loo_JResp.IntOf("Count")
i = 0
li_Count_i = loo_JResp.SizeOfArray("Items")
do while i < li_Count_i
loo_JResp.I = i
ls_CategoryUID = loo_JResp.StringOf("Items[i].Category.UID")
ls_CategoryName = loo_JResp.StringOf("Items[i].Category.Name")
ls_CategoryDisplayID = loo_JResp.StringOf("Items[i].Category.DisplayID")
ls_CategoryURI = loo_JResp.StringOf("Items[i].Category.URI")
ls_AccountUID = loo_JResp.StringOf("Items[i].Account.UID")
ls_AccountName = loo_JResp.StringOf("Items[i].Account.Name")
ls_AccountDisplayID = loo_JResp.StringOf("Items[i].Account.DisplayID")
ls_AccountURI = loo_JResp.StringOf("Items[i].Account.URI")
li_Year = loo_JResp.IntOf("Items[i].Year")
li_Month = loo_JResp.IntOf("Items[i].Month")
li_Activity = loo_JResp.IntOf("Items[i].Activity")
li_YearEndActivity = loo_JResp.IntOf("Items[i].YearEndActivity")
ls_RowVersion = loo_JResp.StringOf("Items[i].RowVersion")
i = i + 1
loop
destroy loo_Http
destroy loo_SbResponseBody
destroy loo_JResp