Power BI Connector for Zoho Books

Build 20.0.7654


Retrieves details of invoices from an existing Credit Note.

Table Specific Information


The {i will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the {i.
Note: CreditnoteId is required in order to query CreditNoteInvoices.

  • CreditnoteId supports the '=' comparison.
For example:
    SELECT * FROM CreditNoteInvoices WHERE CreditnoteId = '1895452000000083136'


Name Type References SupportedOperators Description
CreditnoteInvoiceId [KEY] String ID of credit note invoice.
CreditnoteId String


ID of a credit note.
Credited_amount Decimal Amount which is credit in credit note invoice.
CreditnoteNumber String Number of a credit note.
Date Date Date of an credit note invoice.
InvoiceId String


ID of an invoice.
InvoiceNumber String Number of an invoice.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654