API extraction to SQL Data Base

Hi Mike,

After spending 3 days on this, the following code is that I needed to access my Company file through Excel Power Query Advanced Editor:

let
Source = Json.Document(Web.Contents("http://localhost:8080/AccountRight/3a57d5e8-88b0-44c1-b3d8-4d59ad327a5c/Account/?api-version=v2&format=json")),
// Data source for Item Ledger and conversion to Table

ToTable = Record.ToTable(Source),

// Output number of records in Count and drill down on Value
CountItems = Source[Count],

// Bring Back Source Step
SourceBack = Source,

// Expand list if source count is not null otherwise dont complete next steps
CountTest = if Source[Count] = null then null else Source[Items],
NullTableCheck = if CountTest = null then null else Table.FromRecords( CountTest)
in
NullTableCheck

I can then do all other data maninulation in the Excel Power Query Advanced Editor which then adds it to the code like below for example:

let
Source = Json.Document(Web.Contents("http://localhost:8080/AccountRight/155359a9-e182-4563-90e4-29263e29f3b9/Account/?api-version=v2&format=json")),
// Data source for Item Ledger and conversion to Table

ToTable = Record.ToTable(Source),

// Output number of records in Count and drill down on Value
CountItems = Source[Count],

// Bring Back Source Step
SourceBack = Source,

// Expand list if source count is not null otherwise dont complete next steps
CountTest = if Source[Count] = null then null else Source[Items],
NullTableCheck = if CountTest = null then null else Table.FromRecords( CountTest),

// Data Rows and Columns Sorted
#"Removed Other Columns" = Table.SelectColumns(NullTableCheck,{"Name", "DisplayID", "CurrentBalance"}),
#"Reordered Columns" = Table.ReorderColumns(#"Removed Other Columns",{"DisplayID", "Name", "CurrentBalance"}),
#"Sorted Rows" = Table.Sort(#"Reordered Columns",{{"DisplayID", Order.Ascending}}),
#"Filtered Rows" = Table.SelectRows(#"Sorted Rows", each ([DisplayID] = "2-2130"))
in
#"Filtered Rows"

I realy don't understand why MYOB wouldn't just realease a 2 page document explaining this to everyone instead of directing them to third party addon's wanting $50/month on top of the $100 plus we are already paying you.

Pleaese are you able to add the additional code to the aboove so I can access my onlline company file as well.

Otherwise I will have to spend another 2 days working it out myself?

This is really poor of MYOB not to provide this info considering how easy it would be to.