Overview

This section shows the available API objects and provides more information on executing SQL to Zoho Inventory APIs.

Key Features

• The add-in models Zoho Inventory entities like invoices, bills, and currencies as relational views, allowing you to write SQL to query Zoho Inventory data.
• Stored procedures allow you to execute operations to Zoho Inventory, including expense receipt, retainer invoice attachment and attachments.
• Live connectivity to these objects means any changes to your Zoho Inventory account are immediately reflected when using the add-in.
• IncludeCustomFields connection property allows you to retrieve custom fields for supported views. Set this property to True, to enable this feature.

Tables

Tables are statically defined to model Zoho Inventory entitites such as Invoices, Contacts, Bills, and more.

Views

Views describes the available views. Views are read-only tables that are statically defined to model Zoho Inventory entities such as InvoiceListPayments, ContactsListComments and more.

Stored Procedures

Stored Procedures are function-like interfaces to Zoho Inventory. Stored procedures allow you to execute operations to Zoho Inventory, including emailing contacts, inviting users into your organization, and printing invoices.