Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the component beyond simple SELECT/INSERT/UPDATE/DELETE operations with QuickBooks.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from QuickBooks, along with an indication of whether the procedure succeeded or failed.
CData SSIS Components for QuickBooks Stored Procedures
| Name | Description |
| ClearTransaction | Marks specified transaction checks in QuickBooks with statuses such as Cleared, NotCleared, or Pending for reconciliation. |
| CreateReportSchema | Generates a schema file for custom QuickBooks reports, providing a structure for tailored data extraction. |
| GetQBFileStatus | Retrieves the current status of the QuickBooks file, providing insight into its availability or issues. |
| ListMerge | Merges two accounts, customers, or vendors in QuickBooks. Requires QBXML Version 7.0 or higher. |
| SearchEntities | Facilitates entity searches in QuickBooks by various attributes, streamlining entity identification. |
| SendQBXML | Sends QBXML data directly to QuickBooks, enabling custom operations or mass processing. |
| SendQBXMLFile | Sends a QBXML file directly to QuickBooks for bulk operations or advanced data handling. |
| VoidTransaction | Voids a specified transaction in QuickBooks, ensuring proper tracking and adjustment of financial records. |