Michael, Sorry, we have no idea how a connection with ODBC would work from 4D, I doubt that it would as there is no SDK provided by Intuit for 4D.
Check out the following site: https://developer.intuit.com/docs/api/accounting In the top blue navigation bar, you will see two options, Quickbooks Online and QuickBooks Desktop. What you will need to connect will depend upon which of these two QB Apps are being used. What are you trying to get to/from Quickbooks? We have written a small Windows executable which allows us to create invoices from a 4D Database and get customer balances back from the Desktop Version of Quickbooks. It should be noted, this is the OLD Quickbooks application and way of doing things. Quickbooks Online is the new Application and has it’s own web based API’s. While we have not messed with the Online API’s, they seem pretty strait forward. As for the Desktop App, the way integration here works (and you may have several options, I did not write our App and it is quite old) is that Intuit has an SDK which can be used in Visual Studio (in our case) to create a Windows EXE which can then be called by 4D. So with QB launched (in our case, there are other security options here) the user can run a 4D Method which drops and XML file in a preset location. 4D then Launches the EXE which we call QBXMLAgent. QBXMLAgent then reads the XML and does all the communication with QB’s and returns an XML file for 4D to the same preset location. Note, NO ODBC setup is required to make this work. Only that the EXE be present on the Windows machine in preset path where 4D calls. it. The Visual Basic code for this is quite simple and we would be happy to send you a copy of the Main Visual Basic Method (it is a single Method). I doubt that the person here who wrote the Main Method even wrote much from scratch, I would bet it is mostly copied from examples, etc. The key to the whole thing is the integrated Library provided by Intuit which can be brought into Visual Studio. See here for samples: https://developer.intuit.com/docs/0200_quickbooks_desktop/0400_tools/quickbooks_desktop/sample_code Hope this helps! Thanks, Kevin Abraham Digital Retirement Solutions [email protected] On Jan 22, 2017, at 1:16 PM, Michael Ferguson <[email protected]> wrote: > Hi, > > I am working with a 4D OBDC connection to Quickbooks. I would like the syntax > of the sql to get a list of tables, a list of field names and properties into > arrays. > > I have example code for returning specific table columns, but not for the > above. > > Also, I have googled for ODBC user groups, particularly with regard to 4D and > Quickbooks, but don’t find much. Any recommendations? I need examples to get > up to speed as quickly as I can. > > Thanks, > > Michael > > > > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
