JDBC Driver for QuickBooks

Build 21.0.7867

Stored Procedures

Stored procedures are available to complement the data available from the Data Model. It may be necessary to update data available from a view using a stored procedure because the data does not provide for direct, table-like, two-way updates. In these situations, the retrieval of the data is done using the appropriate view or table, while the update is done by calling a stored procedure. Stored procedures take a list of parameters and return back a dataset that contains the collection of tuples that constitute the response.

CData JDBC Driver for QuickBooks Stored Procedures

Name Description
ClearTransaction Marks the transaction checks with Cleared, NotCleared or Pending status.
CreateReportSchema Generates a report schema file.
GetQBFileStatus Gets the status of the quickbooks file.
ListMerge Merge two accounts, customers, or vendors. Requires QBXML version 7.0 or higher.
SearchEntities Search entities in QuickBooks.
SendQBXML Sends the provided QBXML directly to QuickBooks.
SendQBXMLFile Sends the provided QBXML file directly to QuickBooks. This is designed for use with mass inserts.
VoidTransaction Voids a given transaction in QuickBooks.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7867