Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(Visual FoxPro) MYOB: Fetch the Category RegisterReturn 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
LOCAL loHttp LOCAL lnSuccess LOCAL loSbResponseBody LOCAL loJResp LOCAL lnRespStatusCode LOCAL lcNextPageLink LOCAL lnCount LOCAL i LOCAL lnCount_i LOCAL lcCategoryUID LOCAL lcCategoryName LOCAL lcCategoryDisplayID LOCAL lcCategoryURI LOCAL lcAccountUID LOCAL lcAccountName LOCAL lcAccountDisplayID LOCAL lcAccountURI LOCAL lnYear LOCAL lnMonth LOCAL lnActivity LOCAL lnYearEndActivity LOCAL lcRowVersion * This example assumes the Chilkat API to have been previously unlocked. * See Global Unlock Sample for sample code. loHttp = CreateObject('Chilkat_9_5_0.Http') * 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" loHttp.SetRequestHeader("Authorization","Bearer ACCESS_TOKEN") loHttp.SetRequestHeader("x-myobapi-key","{{myob_api_key}}") loHttp.SetRequestHeader("Accept-Encoding","gzip,deflate") loHttp.SetRequestHeader("x-myobapi-version","v2") loSbResponseBody = CreateObject('Chilkat_9_5_0.StringBuilder') lnSuccess = loHttp.QuickGetSb("https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/CategoryRegister",loSbResponseBody) IF (lnSuccess = 0) THEN ? loHttp.LastErrorText RELEASE loHttp RELEASE loSbResponseBody CANCEL ENDIF loJResp = CreateObject('Chilkat_9_5_0.JsonObject') loJResp.LoadSb(loSbResponseBody) loJResp.EmitCompact = 0 ? "Response Body:" ? loJResp.Emit() lnRespStatusCode = loHttp.LastStatus ? "Response Status Code = " + STR(lnRespStatusCode) IF (lnRespStatusCode >= 400) THEN ? "Response Header:" ? loHttp.LastHeader ? "Failed." RELEASE loHttp RELEASE loSbResponseBody RELEASE loJResp CANCEL 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 lcNextPageLink = loJResp.StringOf("NextPageLink") lnCount = loJResp.IntOf("Count") i = 0 lnCount_i = loJResp.SizeOfArray("Items") DO WHILE i < lnCount_i loJResp.I = i lcCategoryUID = loJResp.StringOf("Items[i].Category.UID") lcCategoryName = loJResp.StringOf("Items[i].Category.Name") lcCategoryDisplayID = loJResp.StringOf("Items[i].Category.DisplayID") lcCategoryURI = loJResp.StringOf("Items[i].Category.URI") lcAccountUID = loJResp.StringOf("Items[i].Account.UID") lcAccountName = loJResp.StringOf("Items[i].Account.Name") lcAccountDisplayID = loJResp.StringOf("Items[i].Account.DisplayID") lcAccountURI = loJResp.StringOf("Items[i].Account.URI") lnYear = loJResp.IntOf("Items[i].Year") lnMonth = loJResp.IntOf("Items[i].Month") lnActivity = loJResp.IntOf("Items[i].Activity") lnYearEndActivity = loJResp.IntOf("Items[i].YearEndActivity") lcRowVersion = loJResp.StringOf("Items[i].RowVersion") i = i + 1 ENDDO RELEASE loHttp RELEASE loSbResponseBody RELEASE loJResp |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.