?
Solved

Quick Books API

Posted on 2014-08-18
2
Medium Priority
?
341 Views
Last Modified: 2014-08-21
Is there a Quick Books API that can be used to synchronize a QuickBooks database on a Windows Server 2012 OS with a web server based MySQL Database?

We are presently running a Microsof Access set of Macros / Queries where the corresponding QB tables are references as external to the Access database. We synch once nightly using a Windows scheduled task to initiate the process. It's messy & fails under certain conditions.

It would be nice to synchronize "on the fly".

Thanks
0
Comment
Question by:Richard Korts
2 Comments
 
LVL 31

Accepted Solution

by:
Frosty555 earned 2000 total points
ID: 40269128
QuickBooks does have an API, although I haven't personally dived into using it, it is most definitely possible to interact with a QuickBooks database via a programmable API for the purposes of synchronizing or interacting with the data.

You need to join the Intuit Partner Program, and download and take a look at the QuickBooks Desktop SDK.

https://developer.intuit.com/us

https://developer.intuit.com/docs/0250_qb
0
 

Author Comment

by:Richard Korts
ID: 40269168
I have seen some references on the web to a php / Quickbooks integgration. I am very familiar with php. Does someone know about that? I saw a reference to an example of where a customer is created in a store (on-line), causing that same customer to be created in Quick Books.

We probably want the opposite; create a new QB customer, synchronize with the web by inserting in our web MySQL database.

But we need the reverse too; invoices are paid on-line, we would want those to update in QB instantly.

Thanks
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You may need to view past transactions from previous QuickBooks files or other QuickBooks company files when:       1. you are working in another QuickBooks file       2. QuickBooks is closed QuickBooks users who would benefit from this artic…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month15 days, 12 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question