Forum Discussion

Gen1's avatar
Gen1
Contributing User
4 years ago

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

  • 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

    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

      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's avatar
        nic-acc-addons1
        Experienced User

        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.

  • 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's avatar
      Gen1
      Contributing User

      Hi Nicolas 

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

      • nic-acc-addons1's avatar
        nic-acc-addons1
        Experienced User

        Hi Gen1,

         

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