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