Can i access myob db tables usin api
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?
Forum Discussion
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?
- 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 .
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)
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 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/
