API Data Provider - Online Help

ZohoSubscriptions Tables

The provider models the data in API into a list of tables that can be queried using standard SQL statements.

Generally, querying API tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.

ZohoSubscriptions Tables

Name Description
Addons Returns the list of all addons.
ContactPersons Returns the list of all contact persons of a customer.
CouponDetails Returns details of a coupon.
Coupons Returns the list of all coupons.
CreditCards Returns the list of all the active credit cards of a customer.
CreditNoteDetails Returns details of a credit note.
CreditNotes Returns the list of all credit notes.
CustomerDetails Returns details of a customer.
Customers Returns the list of all customers.
HostedPages Returns the list of all hosed pages.
InvoiceDetails Returns details of an invoice.
Invoices Returns the list of all invoices.
Organizations Returns the list of organizations.
PaymentDetails Returns details of a payment.
Payments Returns the list of all payments.
Plans Returns the list of all plans.
Products Returns the list of all products .
SubscriptionActivities Returns List of all the recent activities associated to a subscription.
SubscriptionDetails Returns details of a subscription.
Subscriptions Returns the list of all subscriptions.
Transactions Returns the list of all customers.
UnbilledCharges Returns the list of all unbilled charges.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8487.0