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.