Freee 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.
Freee Tables
| Name | Description |
| AccountItemItems | Generated schema file. |
| AccountItemPartners | Generated schema file. |
| AccountItems | Generated schema file. |
| ApprovalFlowRoutes | Generated schema file. |
| ApprovalFlowRouteSteps | Generated schema file. |
| ApprovalRequestForms | Generated schema file. |
| ApprovalRequestItems | Generated schema file. |
| ApprovalRequests | Generated schema file. |
| Banks | Generated schema file. |
| Companies | Generated schema file. |
| CompanyFiscalYears | Generated schema file. |
| DealDetails | Generated schema file. |
| DealPayments | Generated schema file. |
| DealReceipts | Generated schema file. |
| DealRenewDetails | Generated schema file. |
| DealRenews | Generated schema file. |
| Deals | Generated schema file. |
| ExpenseApplicationLines | Generated schema file. |
| ExpenseApplicationLineTemplates | Generated schema file. |
| ExpenseApplications | Generated schema file. |
| InvoiceContents | Generated schema file. |
| Invoices | Generated schema file. |
| Items | Generated schema file. |
| Journals | Generated schema file. |
| ManualJournalDetails | Generated schema file. |
| ManualJournals | Generated schema file. |
| Partners | Generated schema file. |
| PaymentRequestDetails | Generated schema file. |
| PaymentRequestLines | Generated schema file. |
| PaymentRequests | Generated schema file. |
| QuotationContents | Generated schema file. |
| Quotations | Generated schema file. |
| Receipts | Generated schema file. |
| Sections | Generated schema file. |
| SegmentTags | Generated schema file. |
| Tags | Generated schema file. |
| Taxes | Generated schema file. |
| Transfers | Generated schema file. |
| TrialBS | Generated schema file. |
| TrialBSPartners | Generated schema file. |
| TrialBSThreeYears | Generated schema file. |
| TrialBSTwoYears | Generated schema file. |
| TrialPL | Generated schema file. |
| TrialPLPartners | Generated schema file. |
| TrialPLSections | Generated schema file. |
| TrialPLThreeYears | Generated schema file. |
| TrialPLTwoYears | Generated schema file. |
| UserMeCompanies | Generated schema file. |
| Users | Generated schema file. |