Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
February 2019
February 2019
Hi all
I'd like to get started with Excel Power Pivot and AccountRight 2018.4 cloud.
Does anyone know what is needed to connect Excel Power Pivot to AR?
eg. Do I need an API?
Thanks in advance
David
February 2019
February 2019
Hi @DavidFisher, this documentation has some basics to get you started:
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
February 2019
February 2019
Thanks Mike.
It refers to 2013 which makes me think its old. eg my MYOB files are in C:\Users\[username]\AppData\Local\MYOB\AccountRight.
Was I meant to seach for 'installer' or 'api'? I didn't find a file that I need to run to install the api.
I'm still stuck I'm afraid.
Regards
David
February 2019
February 2019
Hi @DavidFisher, if you open a browser and type in http://localhost:8080/AccountRight/, do you see a list of company files from your local library? If so, you can drill down on any line, and see what resources are available.
However, you will need to modify the URL to add the API version, Eg: http://localhost:8080/AccountRight/3ae6a4e1-4acf-48c5-bde6-40fac54cd4ef?x-myobapi-version=v2.
You will need to replace the blue text with the file id from your own system.
Version 2 of the API allows you to access many more endpoints.
I'm assuming the file you want to analyse is in a local library. If it is in the cloud, that's another story.
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
February 2019
February 2019
Hi Mke
Thanks for your continued assistance/persistence.
Neither url works. I'm not sure where I'd find my local ID to replace the blue.
Confirming that my file is in the cloud....
Regards
David
February 2019
February 2019
Hi David
I specialise in connecting MYOB to Power Pivot, along with Power BI and Power Query. Contact me at matt@accountingpower.com.au and I can point you in the right direction to get you started.
Matt