Forum Discussion

Gen1's avatar
Gen1
Contributing User
5 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
    5 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 Cover User
5 years ago

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
5 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?

 

 

 

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.