Connecting to a copy of my Account Right database. A .myox file

[Gen1]

Hello

I am completely new to mYOB, my Sydney office has sent me a copy of their database to try integrate with our datawarehouse. They use AccountRight Premier AU 2020 4.2. Not the cloud version. I therefore have  a.myox file.  I have an administrator user name and password and fileID. How can i get hold of the MYOB API , so I can connect to this file.

I see many expensive solutions like odataLink I could use. Which I have instealled but get stuck at the url  link. But my understanding is I could use the MYOB standard API to connect from SQL for example or Power BI desktop

Kind Regards

Gen

[Mike_James]

Hi @Gen1 , welcome to the forum. You will need to have AccountRIght installed on your computer, see myob.com/au/support/downloads, look for the PC edition, and install the correct version. (Check with your office about that). Once installed, save the file into the local library, see https://help.myob.com/wiki/display/ar/Manage+libraries for the location.

Then have a look at https://developer.myob.com/api/accountright/v2/company-files/, and look for the advice about connecting to local files. http://localhost:8080/accountright/ will get you a list of files in the library, and give you the file id for your file. 

Postman is an excellent way to look further - see https://developer.myob.com/api/accountright/accountright-postman-collection/

oDataLink have a free trial, and wil be putting out a free version, which wil be limited in some way they are yet to decide on.  

MYOB for Excel (https://help.myob.com/wiki/display/ar/Getting+started+with+MYOB+for+Excel) is another free tool for extracting data, but only for files stored in the cloud. 

[nic-acc-addons1]

Hi Gen,

Regarding OdataLink, we have recently added a Free Edition to the mix which should reduce the cost of getting started greatly.

If you have any questions regarding OdataLink since you got stuck with getting url, let us know and we may be able to steer you in the right direction.

[Gen1]

Hi Nicolas 

Isit also posisble to connect to an offline copy with OdataLink?

[nic-acc-addons1]

Hi Gen1,

No, unfortunately, at this stage, odatalink can only connect to cloud data files.

[Gen1]

Hi Mike

A month further and I am no closer. I have done all the steps above.

I even tried the postman steps but could not get further as after following the tutorial I could only see the online test databse and not my local database. 

I have tried to access my datbase via the web browser: 

I have account right 2020.4 stored locally on my computer and teh add on is running
When I type http://localhost:8080/accountright/ in google chrome, I can see a list of databases. When I click on the copy of the database I want to access: (I get a prompt to enter my user name/password)
Link was: http://localhost:8080/AccountRight/xxxxxxxx
I then see a list of files in my datbase. But when I click on the link of one of the files such as :
http://localhost:8080/AccountRight/xxxxxx/Account/
I Get an error:
This page isn't working
localhost is unable to handle this request (HTTP ERROR 500)

Do you know why this would be?

I would like to make a connection to the table from power BI, using the web connection. But there I get a similar errror, so I think if I can solve the above maybe I can also get power query to connect. 

What am I missing?

[nic-acc-addons1 · Accepted solution]

Hi Gen,

Once you browse to your data file, append ?api-version=v2. It should return the more modern endpoints for version 2 of the api. I have a feeling version 1 is obsolete, deprecated and might not be installed.  As you browse through the urls, remember to keep appending ?api-version=v2 as it's possible it'll get removed as you navigate through.

[Gen1]

Hi Nicolas

Thank you for that tip. I now see many more end points available when connecting to my database. However I still receive an error when trying to connect to one of the tables.

For example I type:  http://localhost:8080/AccountRight/xxxxxxxContact/Customer/?api-version=v2

or http://localhost:8080/AccountRight/xxxxxxxxxxxxxxx/Contact/Customer/?api-version=v2&format=html

I get the error message:

  “InternalError An exception was thrown that was not handled correctly. If this situation persists please contact developers@myob.com for further assistance.          20”

My Goal is to load some tables into power BI using power BI desktop, so that I can combine it with data from other erp systems in our company. When I try connecting using the web connection in power query (http://localhost:8080/AccountRight/xxxxx/Account/?api-version=v2) I get a similar error:

[Mike_James]

hI @Gen1 , try x-myobapi-version=v2, see https://developer.myob.com/api/accountright/api-overview/headers/

[nic-acc-addons1]

Hi Gen1,

Can you confirm which installer of MYOB you installed on your machine.  Either the PC or Server edition ? 

If you go to add/remove programs, the server edition will end with SE (e.g. MYOB accountRight 2020.4 SE).