Power BI Connector for Zoho Inventory

Build 24.0.9062

ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、Zoho Inventory の単純なSELECT 処理にとどまらず本製品 の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにZoho Inventory から関連するレスポンスデータを返します。

CData Power BI Connector for Zoho Inventory ストアドプロシージャ

Name Description
ApplyCreditsToABill Apply vendor credit to existing bills.
ApproveACreditNote Approve a Vendor credit.
ApproveARetainerInvoice Approve a retainer invoice.
ApproveAVendorCredit Approve a Vendor credit.
BillMarkAsOpen Marks a Bill as Open.
BillMarkAsVoid Marks a Bill as Open.
BulkExportInvoices Maximum of 25 invoices can be exported in a single pdf.
BulkPrintInvoices Export invoices as pdf and print them..
BulkPrintPackages Print package slips.
BundlingHistory Mark Contact as active
CancelWriteOffInvoice Enable automated payment reminders for 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 Disable automated payment reminders for an invoice.
CreditNoteUpdateBillingAddress Updates the billing address for this invoice alone.
CreditNoteUpdateShippingAddress Updates the billing address for this invoice alone.
CreditNoteUpdateTemplate Update the pdf template associated with the retainer invoice.
DeleteAnItemImage Deletes the image associated for an item in Zoho Inventory.
DeleteSalesReturnReceive Deletes the image associated for an item in Zoho Inventory.
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.
GetAPackage Get package details
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.
GetStatementMailContent Get Content of Mail
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 payment related to 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 Attach a file to an invoice.
InvoiceMarkAsDraft Mark a voided invoice as draft.
InvoiceMarkAsSent Mark a draft retainer invoice as sent.
InvoiceUpdateAttachmentPreference Update the preference for the attachment related to invoice
InvoiceUpdateBillingAddress Updates the billing address for this invoice alone.
InvoiceUpdateShippingAddress Updates the billing 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 Changes the status of an item to active.
ItemGroupsMarkAsInactive Mark an item 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 active.
ListComments List recent activities of a contact.
MailContent Get the mail content of a contacts billing statement.
MarkARetainerInvoiceAsSent Mark a draft retainer invoice as sent.
MarkAsActive Mark Contact as active
MarkAsActiveGroupItems Changes the status of an item to active.
MarkAsConfirmedSalesOrders Changes the status of a Sales Order to Confirmed.
MarkAsInactive Mark Contact as Inactive
MarkAsInactiveGroupItems Changes the status of an item to active.
MarkAsReceived Mark Contact as active
MarkAsVoidSalesOrders Changes the status of a Sales Order to Void.
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 Active.
PurchaseordersMarkAsCancelled Changes the status of an item to active.
PurchaseordersMarkAsIssued Changes the status to 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 Vendor credit 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 Received.
UpdateRetainerInvoiceTemplate Update template for retainer invoice
UserMarkUserAsActive Mark an inactive user as active.
UserMarkUserAsInactive Mark the user as inactive.
VendorCreditConvertToOpen Change an existing vendor credit status to open.
VoidACreditNote Mark the credit note as Void.
VoidAnInvoice Mark an existing invoice as void.
VoidARetainerInvoice Mark an existing retainer invoice 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.

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