Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
April 2022
April 2022
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?
April 2022
April 2022
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?
April 2022
April 2022
April 2022
April 2022
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
April 2022
April 2022
@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/
April 2022
April 2022
@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)
by
AL6
4 weeks ago
0
122
|
0
|
122
|
||
41
|
3271
|
|||
14
|
568
|
|||
1
|
218
|
|||
33
|
1529
|