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
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/
