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?
@Jeff_AccAddons wrote:Hi @deeppatin The Add-in OdataLink can provide data in a format that you can queried live from SQLhttps://www.myob.com/au/apps/products/odatalink Here's a video on how to connect using ithttps://odatalink.com/tutorials/integrate-myob-or-xero-with-sql-server-using-odatalink-clr/ Jeff
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/
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?
Self-help & Learning
Level up your skills and find answers across all MYOB products
Help Guides
MYOB Academy
