Stored Procedures

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

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

CData Tableau Connector for Zoho Inventory Stored Procedures


Name	Description
ApplyCreditsToABill	Apply vendor credit to existing bills.
ApproveACreditNote	Approve a credit note.
ApproveARetainerInvoice	Approve a retainer invoice.
ApproveAVendorCredit	Approve a Vendor credit.
BillMarkAsOpen	Marks a Bill as Open.
BillMarkAsVoid	Marks a Bill as Void.
BulkExportInvoices	Maximum of 25 invoices can be exported in a single pdf.
BulkPrintInvoices	Export invoices as pdf and print them.
BulkPrintPackages	Print package slips.
CancelWriteOffInvoice	Cancel the write off amount of an invoice.
CompositeItemsMarkAsInactive	Mark Contact as active
CompositeItemsMarkAsActive	Mark Contact as active
EmailContact	Send email to contact.
ContactEmailStatement	Email Statement to the contact
ContactMarkAsActive	Mark Contact as active
ContactMarkAsInactive	Marks a contact as inactive
ContactPersonMarkAsPrimaryContact	Mark as Primary Contact Person
ConvertCreditNoteToDraft	Convert a voided credit note to Draft.
ConvertCreditNoteToOpen	Convert a credit note in Draft status to Open.
CreateASalesReturnReceive	Creating a sales return receive to mark the receivable goods as received.
CreditNoteUpdateBillingAddress	Updates the billing address for an existing credit note.
CreditNoteUpdateShippingAddress	Updates the shipping address for an existing credit note.
CreditNoteUpdateTemplate	Update the pdf template associated with the credit note.
DeleteAnItemImage	Deletes the image associated for an item in Zoho Inventory.
DeleteSalesReturnReceive	Deletes the sales return receive of a sales return.
EmailAnInvoices	Email an invoice to the customer.
EmailCreditNote	Email a credit note.
EmailRetainerInvoice	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.
EnableMultiWarehouse	Enable Multiple warehouse for an organisation.
GetATaxAuthority	Get the details of a tax authority.
GetATaxExemption	Get the details of a tax exemption.
GetOAuthAccessToken	Gets an authentication token from Zoho Inventory.
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.
InviteAUser	Send invitation email to a person, you wish to add as a user to your organisation.
InvoiceAddAttachment	Attach a file to an invoice.
InvoiceDeleteAPayment	Delete a payment made to an invoice.
InvoiceDeleteAttachment	Delete the file attached to the invoice.
InvoiceDisablePaymentReminder	Disable automated payment reminders for an invoice.
InvoiceEnablePaymentReminder	Enable automated payment reminders for an invoice.
InvoiceGetAttachment	Get a file attached to an invoice.
InvoiceMarkAsDraft	Mark a voided invoice as draft.
InvoiceMarkAsSent	Mark a draft invoice as sent.
InvoiceUpdateAttachmentPreference	Set whether you want to send the attached file while emailing the invoice.
InvoiceUpdateBillingAddress	Updates the billing address for this invoice alone.
InvoiceUpdateShippingAddress	Updates the shipping address for this invoice alone.
InvoiceUpdateTemplate	Update the pdf template associated with the invoice.
InvoiceWriteOff	Write off the invoice balance amount of an invoice.
ItemGroupsMarkAsActive	Marks an Item group as Active.
ItemGroupsMarkAsInactive	Marks an Item group as Inactive.
ItemsDeleteItemImage	Deletes the image associated for an item in Zoho Inventory.
ItemsMarkAsActive	Changes the status of an item to active.
ItemsMarkAsInactive	Changes the status of an item to inactive.
MailContent	Get the mail content of a contacts billing statement.
MarkARetainerInvoiceAsSent	Mark a draft retainer invoice as sent.
MarkAsActive	Mark Contact as active
MarkAsActiveGroupItems	Marks an Item group as Active.
MarkAsInactive	Mark Contact as Inactive
MarkAsInactiveGroupItems	Marks an Item Group as Inactive.
MarkAsReceived	Changes the status of a transfer order to Transferred.
MarkItemAsActive	Changes the status of an item to active.
MarkItemAsInactive	Mark an item as inactive.
PriceListMarkAsActive	Mark the pricebook as Active.
PriceListMarkAsInactive	Mark the pricebook as Inactive.
PurchaseordersMarkAsCancelled	Marks a Purchase Order as Cancelled.
PurchaseordersMarkAsIssued	Marks a Purchase Order as Issued.
RefreshOAuthAccessToken	Refreshes the OAuth access token used for authentication with Zoho Inventory.
RetainerInvoiceMarkAsDraft	Mark a voided retainer invoice as draft.
RetainerInvoiceUpdateBillingAddress	Updates the billing address for this invoice alone.
RetainerInvoiceUpdateTemplate	Update the pdf template associated with the retainer invoice.
SalesOrderMarkAsConfirmed	Changes the status of a Sales Order to Confirmed.
SalesOrderMarkAsVoid	Changes the status of a Sales Order to Void.
ShipmentOrdersMarkAsDelivered	Changes the status of a Sales Order to Confirmed.
SubmitACreditNoteForApproval	Submit a credit note for approval.
SubmitARetainerInvoiceForApproval	Submit a retainer invoice for approval.
SubmitAVendorCreditForApproval	Submit a Vendor credit for approval.
TransferOrdersMarkAsReceived	Changes the status of a transfer order to Transferred.
UpdateRetainerInvoiceTemplate	Update template for retainer invoice
UserMarkUserAsActive	Mark an inactive user as active.
UserMarkUserAsInactive	Mark an active user as inactive.
VendorCreditConvertToOpen	Change an existing vendor credit status to open.
VoidACreditNote	Mark the credit note as Void.
VoidAnInvoice	Mark an invoice status as void.
VoidARetainerInvoice	Mark an invoice status as void
VoidVendorCredit	Mark an existing vendor credit as void.
WarehouseMarkAsActive	Mark warehouse as Active.
WarehouseMarkAsInactive	Mark warehouse as Inactive.
WarehouseMarkAsPrimary	Mark warehouse as primary.