Can i access myob db tables usin api

[deeppatin]

Hi i m looking for connecting my production machine program to MYob sales order table. Is there anyway i can connect to my subscribed account database tables? 

[kjm]

connecting directly to db kind of goes against the whole concept of having an API

The API is there to help and present the functionality the developers want you to see and use.

Going directly to the db could create all sorts of problems..data integrity etc

Cant you access the sales orders from the API? what ar eyou trying to do exactly? 

[deeppatin]

We are Manufacturing company and we have folder machine which have drawing software.  That software sends customer name and sales order line to sql db. Then my team have to go to your software and re-enter them in sales order. it takes huge time and we have to do a lot of rework. i just need connectivity to sql where we can store our data directly in sales order tables.  If you have any api method that can help us in inserting and reading data from any tables it will solve our issue .

[Jeff_AccAddons]

Hi @deeppatin 

The Add-in OdataLink can provide data in a format that you can queried live from SQL

https://www.myob.com/au/apps/products/odatalink

Here's a video on how to connect using it

https://odatalink.com/tutorials/integrate-myob-or-xero-with-sql-server-using-odatalink-clr/

Jeff

[kjm]

---

@Jeff_AccAddons wrote:

Hi @deeppatin 

The Add-in OdataLink can provide data in a format that you can queried live from SQL

https://www.myob.com/au/apps/products/odatalink

Here's a video on how to connect using it

https://odatalink.com/tutorials/integrate-myob-or-xero-with-sql-server-using-odatalink-clr/

Jeff

---

@Jeff_AccAddons  is the odatalink write as well..? I didnt know that. I thought it was read only get data only . As I understand it OP wants to write to the sales order table.

@deeppatin here is the API call to sales order...why dont you use that?

https://developer.myob.com/api/myob-business-api/v2/sale/order/order_item/

[PowerMyobBI]

@deeppatin, If you are familar with Power BI /Power Query it can read data from API's and SQL tables quiet easily.

There are also various power bi options to write back data to an SQL database if you try to goole Power BI write back.

For MYOB entering myob transactions you can use the import process in the software to get sales item records into your MYOB data files or get a developer to write some code to POST transactions to api.

Good Luck with your project! 

Garry (Fiveledger.com)