API extraction to SQL Data Base
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.
Forum Discussion
Hi Andrew999
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.
You can find the documentation for the endpoints here: https://developer.myob.com
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.
Thanks Hayden,
I will go through this documentation.
Best Regards
Andrew
Hello Hayden,
I am trying to extract data from Online Accountright directly to excel using power query
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.
I use:
https://api.myob.com/accountright
and my key but get an error " a web API key can only be specified when a web API key name is provided. Help please!!
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.
Thank you.
Did you find a solution to this?
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.
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
Cheers Mark
