ODBC Driver for Zoho Books

Build 24.0.9060

Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT/INSERT/UPDATE/DELETE operations with Zoho Books.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Zoho Books, along with an indication of whether the procedure succeeded or failed.

CData ODBC Driver for Zoho Books Stored Procedures

Name Description
AddAttachment Attaches a file to salesorder, invoice, purchaseorder etc.
AddExpenseReceipt Attaches a receipt to an expense.
ApproveAnEntity Approves an estimate, salesorder, invoice, creditnote, retainerinvoice, purchaseorder, bill or vendorcredit.
BillsApplyCredit Applies the vendor credits from excess vendor payments to a bill.
ContactEnableOrDisablePaymentReminder Reminds the associated contact if payment date is missed.
ContactEnablePortalAccess Enables portal access for a contact.
ContactSendEmail Send email to contact.
DeleteAttachment Removes attached file from salesorders, invoices, purchaseorders, or bills.
DeleteCustomModuleField Deletes a column from a custom module.
DeleteImportedStatement Deletes the BankAccounts statement that was previously imported.
DownloadAttachment Returns the file attached to the invoice.
DownloadExpenseReceipt Returns the receipt attached to the expense.
DownloadRetainerInvoiceAttachment Returns the file attached to the retainer invoice.
EmailACreditNote Emails a credit note to the customer.
EmailAnEstimate Emails an estimate to the customer.
EmailAnInvoice Emails an invoice to the customer.
EmailAPurchaseOrder Emails a purchase order to the customer.
EmailARetainerInvoice Email a retainer invoice to the customer. Input json string is not mandatory. If input json string is empty, mail will be send with default mail content.
EmailASalesOrder Email a sales order to the customer. Input json string is not mandatory. If input json string is empty, mail will be send with default mail content.
EmailMultipleEstimates Email an invoice to the customer.
EmailMultipleInvoices Email an invoice to the customer.
ExportReport Downloads report as a pdf or xls file
GetOAuthAccessToken Gets an authentication token from Zoho Books.
GetOAuthAuthorizationURL Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. You will request the OAuthAccessToken from this URL.
ImportCreditCardStatement Imports your bank/credit card feeds into your account.
InvoiceBulkInvoiceReminder Reminds your customer about unpaid invoices by email. A reminder mail is only sent for invoices in an open or overdue status. You can specify a maximum of ten invoices.
InvoiceCancelWriteOFFInvoice Cancels the write-off amount of an invoice.
InvoiceDeleteExpenseReceipt Deletes attached receipt.
InvoiceEnableOrDisablePaymentReminder Enables or disables automated payment reminders for an invoice.
InvoiceWriteOFFInvoice Writes off the invoice balance amount of an invoice.
MarkCustomerContactAsPrimary Updates the status as primary for customer contacts.
MarkJournalAsPublished Updates the status of a journal as published.
ModifyBankAccountStatus Updates the status as active or inactive for a bank account.
ModifyBillStatus Updates the status as void or open for a Bill.
ModifyChartofAccountStatus Updates the status as active or inactive for a chartofaccount.
ModifyContactStatus Updates the status as active or inactive for a contact.
ModifyCreditNoteStatus Updates the status as draft, void or open for a CreditNote.
ModifyEstimateStatus Updates the status as sent, accepted, or declined for estimates.
ModifyInvoiceStatus Updates the status as sent, void, or draft for an invoice.
ModifyItemStatus Updates the status as active or inactive for an item.
ModifyProjectStatus Updates the status as active or inactive for a project.
ModifyPurchaseOrderStatus Updates the status as open, cancelled, or billed for a purchaseorder.
ModifyRecurringBillStatus Updates the status as stop or resume for a recurring bill.
ModifyRecurringExpenseStatus Updates the status as stop or resume for a recurring expense.
ModifyRecurringInvoiceStatus Updates the status as stop or resume for a recurring invoice.
ModifyRetainerInvoiceStatus Updates the status as sent, void, or draft for retainerinvoice.
ModifySalesorderStatus Updates the status as void or open for a project.
ModifyUserStatus Updates the status as active or inactive for a user.
ModifyVendorCreditStatus Changes an existing vendor credit status to void or open.
ProjectsInviteAUser Invites a user to the project.
RefreshOAuthAccessToken Refreshes the OAuth access token used for authentication with ZohoBooks.
SubmitAnEntityForApproval Submits an estimate, salesorder, invoice, creditnote, retainerinvoice, purchaseorder, bill, or vendorcredit for approval.
TransactionsUnCategorizeACategorizedTransaction Reverts a categorized transaction to uncategorized.
TransactionsUnMatchATransaction Categorizes an uncategorized transaction.
UsersInviteAUser Sends invitation email to a user.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060