API Data Provider - Online Help
Freee Profile
Connecting to Freee
Using the Profile
ADO.NET
JDBC
ODBC
PowerBI
SSIS
Excel
SQL Compliance
SELECT Statements
SQL Functions
String Functions
Date Functions
Math Functions
EXECUTE Statements
Schema Discovery
ADO.NET
JDBC
System Tables
sys_tables
sys_tablecolumns
sys_procedures
Tables
AccountItemItems
AccountItemPartners
AccountItems
ApprovalFlowRoutes
ApprovalFlowRouteSteps
ApprovalRequestForms
ApprovalRequestItems
ApprovalRequests
Banks
Companies
CompanyFiscalYears
DealDetails
DealPayments
DealReceipts
DealRenewDetails
DealRenews
Deals
ExpenseApplicationLines
ExpenseApplicationLineTemplates
ExpenseApplications
InvoiceContents
Invoices
Items
Journals
ManualJournalDetails
ManualJournals
Partners
PaymentRequestDetails
PaymentRequestLines
PaymentRequests
QuotationContents
Quotations
Receipts
Sections
SegmentTags
Tags
Taxes
Transfers
TrialBS
TrialBSPartners
TrialBSThreeYears
TrialBSTwoYears
TrialPL
TrialPLPartners
TrialPLSections
TrialPLThreeYears
TrialPLTwoYears
UserMeCompanies
Users
ApprovalRequestItems
Generated schema file.
Columns
Name
Type
References
Id [KEY]
String
ApprovalRequests
.Id
RequestItemId
Integer
Type
String
Value
String