MYOB AccountsRight 2016.3 - How to connect to sql server 2014

This thread is now archived and closed to new comments.
Some of the links provided in this thread may no longer be available or relevant.
If you have a question please post a new topic.
15 REPLIES
Experienced Cover User HIP
15 Posts
Experienced Cover User
Australia

Re: MYOB AccountsRight 2016.3 - How to connect to sql server 2014

Hello,

 

This link for 2016 version http://localhost:8080/AccountRight/1...a/?api-version=v2 is bringing a lot more end points than earlier. However when I click on http://localhost:8080/AccountRight/1...a/sale/invoice/item link, it gives me http 404 error.

 

Link from General ledger, contact seem to work fine.

 

All I'm looking for is to extract data from Sales table that we use in Accountright plus v19.13 at the moment.

Please let me know how to get this data.

 

Thanks,

Jyothi

Experienced Cover User HIP
15 Posts
Experienced Cover User
Australia

Re: MYOB AccountsRight 2016.3 - How to connect to sql server 2014

Hi Keran,

 

Thanks for the response in regards to Sql server. I will look into options shortly.

 

In regards to importing in Excel, I am unable to get all end points. Please advise how to resolve this issue.

 

Best regards,

Jyothi

API Evangelist KeranM
250 Posts
API Evangelist
Australia

Re: MYOB AccountsRight 2016.3 - How to connect to sql server 2014

Hi there Jyothi

 

To READ the API you will need to do one of the following:

  • write software to connect to our API, to query the API for the right data and to pass that data to a system you wish to use - eg: SQL Server
  • leverage an existing tool (an add-on) who have already completed this work and make the integration process easier - I'm aware of solutions that connect our API to Excel and to AccessDB - I'm not aware of any connecting to SQL Server

Hope that helps

K.

 

Keran McKenzie
Futurist in residence @MYOB

Are you a developer? Check out http://developer.myob.com
Looking for an Add-on? Check out http://myob.com/addons/

Twitter: @myobapi | @keranm
Experienced Cover User HIP
15 Posts
Experienced Cover User
Australia

Re: MYOB AccountsRight 2016.3 - How to connect to sql server 2014

Hello Steve,

 

My understanding is that we don't need to buy Add-on if we are just connecting to READ all end points.

 

I will leave it to Developers to confirm that.

 

Regards,

Jyothi

Trusted Partner Steve_Marriott
149 Posts
Trusted Partner
Australia

Re: MYOB AccountsRight 2016.3 - How to connect to sql server 2014

Hi @HIP

 

What you need is a 3rd party add-on, or one that you build yourself, to read AccountRight Live, end-point by end-point, and store the data in an SQL database. Its not like the old ODBC way of doing things as the database in now in the cloud and not on-site.

 

Look in the Development Partner section of the website for Add-Ons.

 

Cheers

 

Steve

 

Steve Marriott
Very Impressive Software
steve@veryimpressive.co.nz
Experienced Cover User HIP
15 Posts
Experienced Cover User
Australia

Re: MYOB AccountsRight 2016.3 - How to connect to sql server 2014

Hello,

 

Can someone please help me how to connect myob (all end points) to sql server 2014.

 

Thank you,

Jyothi

Experienced Cover User HIP
15 Posts
Experienced Cover User
Australia

Re: MYOB AccountsRight 2016.3 - How to connect to sql server 2014

Hello Keran,

 

Thanks for your reply.

 

Yes, I have used ?api_version=v2 in the URL and it still gets a few endpoints that I stated below.

 

Also, when I clicked on the link you have provided, I get the 404 error.

 

Regards,

Jyothi

API Evangelist KeranM
250 Posts
API Evangelist
Australia

Re: MYOB AccountsRight 2016.3 - How to connect to sql server 2014

Hi there

 

Provided you are using ?api_version=v2 in the URL then you should be able to see ALL the endpoints.

To find out which ones there are you can visit http://developer.myob.com/api/accountright/v2/ 

You can filter and create queries using OData and you can learn more about this here http://developer.myob.com/api/accountright/api-overview/retrieving-data/ 

 

 

If you are having troubles with those you can email your API access logs or details to developers@myob.com and the team can support you there

 

Hope that helps

Keran McKenzie
Futurist in residence @MYOB

Are you a developer? Check out http://developer.myob.com
Looking for an Add-on? Check out http://myob.com/addons/

Twitter: @myobapi | @keranm
MYOB Moderator Neil_M
5,266 Posts
MYOB Moderator
New Zealand

Re: MYOB AccountsRight 2016.3 - How to connect to sql server 2014

Hi @HIP

 

I have moved your post onto our API board where our API and Developer support team as well as our other Forum users and developers will be able to further assist you further.



Kind regards,
Neil
MYOB Client Support
Experienced Cover User HIP
15 Posts
Experienced Cover User
Australia

Re: MYOB AccountsRight 2016.3 - How to connect to sql server 2014

Thank you Helen/Neil.

 

I was able to import data into excel successfully.

 

I can see very few tables like account/customer/contact/generaljounal/personalcard/taxcode etc, but I don't see any tables related to sales or invoices.

 

I understand that we extracting via web query. Is it possible to use database query, so we can apply parameters.

 

Would you be able to help me.

 

Thank you very much.

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post