API extraction to SQL Data Base

Question

Can I get some information on how to extract data from Myob online into an SQL data Base to import into a corporate reporting software model, or is it possible to create a direct link.

andrew999 · Answer

Thanks Hayden,I will go through this documentation.&nbsp;Best RegardsAndrew

mac221267 · Answer

Did you find a solution to this?&nbsp;&nbsp;Trying to do the same. Feels like MYOB want everyone to purchase Add-ons instead of providing an easy solution to replace ODBC for Excel users.&nbsp;I feel its against Trade Practices Act to provide new software that no longer performs the same tasks as the old software you paid for. Instead making you pay for Add-ons&nbsp;Cheers Mark

mac221267 · Answer

Hi Mike,&nbsp;After spending 3 days on this, the following code is that I needed to access my Company file through Excel Power Query Advanced Editor:&nbsp;&nbsp;letSource = Json.Document(Web.Contents("http://localhost:8080/AccountRight/3a57d5e8-88b0-44c1-b3d8-4d59ad327a5c/Account/?api-version=v2&amp;format=json")),// Data source for Item Ledger and conversion to TableToTable = Record.ToTable(Source),// Output number of records in Count and drill down on ValueCountItems = Source[Count],// Bring Back Source StepSourceBack = Source,// Expand list if source count is not null otherwise dont complete next stepsCountTest = if Source[Count] = null then null else Source[Items],NullTableCheck = if CountTest = null then null else Table.FromRecords( CountTest)inNullTableCheck&nbsp;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:&nbsp;&nbsp;letSource = Json.Document(Web.Contents("http://localhost:8080/AccountRight/155359a9-e182-4563-90e4-29263e29f3b9/Account/?api-version=v2&amp;format=json")),// Data source for Item Ledger and conversion to TableToTable = Record.ToTable(Source),// Output number of records in Count and drill down on ValueCountItems = Source[Count],// Bring Back Source StepSourceBack = Source,// Expand list if source count is not null otherwise dont complete next stepsCountTest = 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"&nbsp;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.&nbsp;Pleaese are you able to add the additional code to the aboove so I can access my onlline company file as well.&nbsp;Otherwise I will have to spend another 2 days working it out myself?&nbsp;This is really poor of MYOB not to provide this info considering how easy it would be to.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

haydes · Answer

Hi Andrew999&nbsp;
&nbsp;
Not sure if you're referring to AccountRight or Essentials here but there are API endpoints for both that you can send GET requests to in order to fetch and return data to your application.
&nbsp;
You can find the documentation for the endpoints here: https://developer.myob.com
&nbsp;
Once you have a working application that gets the data from the endpoints you'll just need to whip up something that then posts the returned data into your DB.

andrew999 · Answer

Hello Hayden,I am trying to extract data from Online Accountright directly to excel using power query&nbsp;I have my API key but as I am not a developer it is a bit difficult. If you can give me a few steps to guide me to the data I would appreciate it.&nbsp;&nbsp;I use:&nbsp;https://api.myob.com/accountrightand my key but get an error " a web API key can only be specified when a web API key name is provided. Help please!!&nbsp;Then trying to understand the "Advanced "tab in excel PowerQuery "from Web" what do I fill in on URL parts, URL preview, command time out and HTTP request header parameters. If you can give me this as an example to access the API Sandbox demo that would be extremely helpful.&nbsp;&nbsp;Thank you.&nbsp;

Forum Discussion

API extraction to SQL Data Base

8 Replies

Related content

Extracting data from AR into Excel

How to extract PAYG Summaries

Base hourly rate incorrect

Standard pay > base hour

Import / Export Company data

Automatically Adjust base hourly or base salary

Importing data error 4077

Leave accrual on Base Salary staff