Using QuickBooks Online via QODBC

QODBC has the ability to communicate with the Web version of QuickBooks called "QuickBooks Online". This is a version of QuickBooks which is not sold as software, but rather is run live over the Internet in the customers browser. This page will detail the settings to talk to this version of QuickBooks.

Please note that not all files and reports documented in QODBC are available in the Online edition.

Setting QODBC to Use QuickBooks Online Edition

On the QODBC Setup Screen, the Advanced button brings up the Advanced screen. Checking the Connect To QuickBooks Online Edition checkbox activates the fields required to connect to the QuickBooks Online Edition. The connection string attribute for this item is IBizOEConnection. The valid values are Yes and No. The default is No.

The Ticket GUID comes from Intuit by running the following URL: https://login.quickbooks.com/j/qbn/sdkapp/confirm?serviceid=2004&appid=71271511 and following the wizard. The “…” will launch a browser with the above URL. The connection string attribute for this item is IBizOETicketGUID. The default is an empty string.

The Login GUID comes from Intuit by running the following URL: https://login.quickbooks.com/j/qbn/sdkapp/sessionauth2?serviceid=2004&appid=71271511 and logging in. The “…” will launch a browser with the above URL. The connection string attribute for this item is IBizOELoginGUID. The default is an empty string. This is only required if the QuickBooks Online Edition company file has user security activated.

Ask to login if invalid can be checked to allow the user to be sent to the Intuit WEB site to login if the Login GUID is not valid. After the user has successfully logged in the user must copy the Login Key to the clipboard, close the browser and paste the Login Key into the Popup prompting for a Login Key. If not checked, and the Login GUID is invalid, then an error message is returned to the calling program. The connection string attribute for this item is IBizOEPromptForLogin. The valid values are Yes and No. The default value is Yes. This is only useful if the QuickBooks Online Edition company file has user security activated.

The Login Name can be used if the user has not activated the QuickBooks Online Edition company file user security. It will be sent during connection and if valid allow connection without user intervention. The connection string attribute for this item is IBizOEUID. The default is an empty string.

Setting Miscellaneous Properties That Affect Remote Connector Sessions

Reconnect Delay can be used to configure how many seconds QODBC will wait after it disconnects. This allows QuickBooks time to unload properly before the calling application returns to reopen the connection. The connection string attribute for this item is IBizReconnectionDelay. The default value is 0 seconds.

Setting Miscellaneous QODBC Properties

Maximum Field Name Length is used to force QODBC to shorten it field names. Some programming environments, like Delphi will not work with the default 50 character field names. Note that the field names returned will be abbreviated versions of the names listed in the schema definition. The connection string attribute for this item is ColumnNameLen. The default value is 50 characters.