Invoices
Query invoice lines for billing insights.
Select
The connector uses the Talkdesk API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the connector.
- AccountId supports the following operators: =, !=, IN, NOT_IN, IS, IS_NOT, CONTAINS, LIKE.
- Number supports the following operators: =, !=, IN, NOT_IN, IS, IS_NOT, CONTAINS, LIKE.
- InvoiceDate supports the following operators: =, !=, <, <=, >, >=, IS, IS_NOT.
For example, the following query is processed server-side:
SELECT * FROM Invoices WHERE AccountId = 'value'
The connector pushes the ORDER BY clause to the Talkdesk API for the following columns. Sorting on any other column is performed client-side within the connector.
- InvoiceDate supports the following sort directions: ASC, DESC.
For example, the following query is sorted server-side:
SELECT * FROM Invoices ORDER BY InvoiceDate ASC
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the invoice record. | |
| AccountId | String |
Account.Id | The Talkdesk account identifier. |
| Number | String | The invoice number. | |
| InvoiceLineNumber | String | The invoice line number. | |
| InvoiceDate | Date | The invoice date. | |
| DueDate | Datetime | The due date of the invoice. | |
| Currency | String | The ISO-4217 currency code for the invoice. | |
| TotalInvoiceAmount | Double | The total invoice amount. | |
| ProductId | String |
Products.Id | The Talkdesk product code. |
| Description | String | A description for the invoice line. | |
| ProductName | String | The name of the product. | |
| Quantity | Double | The quantity of product in the invoice line. | |
| Rate | Double | The rate applied to the invoice line product. | |
| Amount | Double | The total amount on the invoice line. | |
| TotalTaxAmount | Double | The total amount of taxes in the invoice. |