Forum Discussion

Gen1's avatar
Gen1
Contributing User
4 years ago
Solved

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

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 ...
  • nic-acc-addons1's avatar
    nic-acc-addons1
    4 years ago

    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.

Mike_James's avatar
Mike_James
Ultimate Partner

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. 

Gen1's avatar
Gen1
Contributing User
4 years ago

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?