MYOB-Power BI Integration using APIs

Hi Jeff_AccAddons 

Thanks for the information that is great to know there is an addon for Power BI and Excel to connect. 

Thanks, 

Hi Lakshmi 

AccountRight 20xx does have an API called the MYOB AccountRight API. Connection to the API allows integration with the AccountRight software and third-party applications.

For more information on the AccountRight API and getting started do check out our Developer Centre.

Thanks Steven_M . I havechecked with the developer team and tried to view data using postman.  I have followed this link https://developer.myob.com/api/accountright/accountright-postman-collection/  .I got access token and refresh token. But in the next step when I am trying to list out the company files, Getting below error.

Hi Lakshmi (Lakshmi)

Thank you for reaching out, We often see this error when you are trying to connect to an old essentials company file however the Essentials file has been upgraded to our New platform.

Once the Essentials file has been upgraded to the new platform we need to complete Oauth with the scope of la.global CompanyFile. This will cover Old Essentials, New Essentials and AccountRight. Then in order to pull the company file, we need to use the endpoint https://api.myob.com/accountright/ which will pull AccountRight and New Essentials files.

If this does not resolve the error you can raise a support request with us HERE. 

Hi Han-Solo 

I got access to the company files in postman. I took free developer access. Will it expire? Because I cannot get the access token now which I was getting till friday. 

I am not getting the code along with redirect url. Only if i get it i can go for access token and refresh token. I was getting it till last week and i was accessing data also in postman. But now after giving access to app, I am not getting the access code in the redirected page.

Hi Lakshmi,

Thank you for the update, No the Open Developer Access will not expire. I can see you have also raised a developer request with us. I have just replied to this with more information around your error.

Hi Lakshmi 

I get that its a while ago when you started but there is now an odata feed service which users Power BI's internal OData Connector

It allows you to create live connections to MYOB's end points without requiring any API coding

Here's a link to it

https://odatalink.com/