Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT operations with QuickBooks Online.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from QuickBooks Online, along with an indication of whether the procedure succeeded or failed.
CData Power BI Connector for QuickBooks Online Stored Procedures
| Name | Description |
| CreateAccountListReport | Generates an Account list report schema file. |
| CreateAPAgingDetailReport | Generates an A/P Aging Detail report schema file. |
| CreateAPAgingSummaryReport | Generates an A/P Aging Summary report schema file. |
| CreateARAgingDetailReport | Generates an A/R Aging Detail report schema file. |
| CreateARAgingSummaryReport | Generates an A/R Aging Summary report schema file. |
| CreateBalanceSheetSummaryReport | Generates a Balance Sheet Summary report schema file. |
| CreateCustomerBalanceDetailReport | Generates a Customer Balance detail report schema file. |
| CreateCustomerBalanceReport | Generates a Customer Balance report schema file. |
| CreateCustomerIncomeReport | Generates a Customer Income report schema file. |
| CreateCustomerSalesReport | Generates a Sales by Customer Summary report schema file. |
| CreateExpensesByVendorReport | Generates an Expenses by Vendor report schema file. |
| CreateGeneralLedgerDetailReport | Generates a General Ledger Detail report schema file. |
| CreateInventoryValuationSummaryReport | Generates an Inventory Valuation Summary report schema file. |
| CreateJournalReport | Generates a Journal report schema file. |
| CreateProfitAndLossDetailReport | Generates a Profit and Loss Detail report schema file. |
| CreateProfitAndLossSummaryReport | Generates a Profit and Loss Summary report schema file. |
| CreateSalesByClassReport | Generates a Sales by Class report schema file. |
| CreateSalesByDepartmentReport | Generates a Sales by Department report schema file. |
| CreateSalesByProductReport | Generates a Sales by Product report schema file. |
| CreateStatementOfCashFlowReport | Generates a Statement of Cash Flow report schema file. |
| CreateTransactionListReport | Generates a Transaction List report schema file. |
| CreateTransactionListWithSplitsReport | Generates an Account list report schema file. |
| CreateTrialBalanceReport | Generates a Trial Balance report schema file. |
| CreateVendorBalanceDetailReport | Generates a Vendor Balance Detail report schema file. |
| CreateVendorBalanceReport | Generates a Vendor Balance report schema file. |
| DisconnectOAuthAccessToken | Disconnects the OAuth access token used for authentication with various QuickBooks services. |
| DownloadAttachment | Download Attachment |
| DownloadNote | Download Note from Attachables. |
| DownloadPDF | Download an Invoice, SalesReceipt or Estimate as a PDF |
| GetOAuthAccessToken | Gets the OAuth access token and OAuth secret key from Intuit. |
| GetOAuthAuthorizationURL | Gets the URL, AuthToken, and AuthKey from Intuit. Access the URL returned in the output in an Internet browser. This request returns a verifier token that you will need to use as input along with the AuthToken and AuthKey for GetOAuthAccessToken. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with various QuickBooks services. |
| SendInvoice | Send linked payment Invoices via Email |
| UploadAttachment | Upload Attachment |
| VoidInvoice | To void an existing invoice object |