ZohoExpense 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.
ZohoExpense Tables
| Name | Description |
| Currencies | List of all currencies |
| CustomerDetails | Details of an existing customer |
| Customers | List of all customers |
| ExpenseCategories | List of all active expense categories. |
| ExpenseReportDetails | Details of an existing expense report. |
| ExpenseReports | List of all expense reports. |
| Expenses | List of all existing expenses. |
| Organizations | List of all origanizations |
| Projects | List of all projects |
| Taxes | List of all existing taxes |
| TripDetails | Retrive details of an existing trip. |
| Trips | List all existing trips. |
| UserDetails | Retrieve details of an user. |
| Users | List of all users |