Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the component beyond simple SELECT/INSERT/UPDATE/DELETE operations with Quickbase.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Quickbase, along with an indication of whether the procedure succeeded or failed.
CData SSIS Components for Quickbase Stored Procedures
| Name | Description |
| CreateSolution | Create a solution using either the provided QBL or the stored QBL from the specified record. |
| DeleteFile | Deletes one file attachment's version. |
| DownloadFile | Download the file attachment specified in the record. |
| ExportQBLToRecord | Exports a QBL solution, creating a new record in the specified table. It exports the solution and outputs the resulting QBL in a new record, saving the QBL to a file in the designated file attachment field. The target table must not have required fields other than the file attachment field. |
| GetSolutionQBL | Retrieves the QBL of solution. |
| ListSolutionChanges | Returns a list of changes that would occur if the provided QBL or the QBL from the record were applied. |
| ManageGroupMembership | Adds or removes a list of users to a given group as members. |
| UpdateSolution | Updates the solution using the provided QBL or the QBL stored in the specified record. |