JDBC Driver for QuickBooks Online

Build 23.0.8770


Generates a Trial Balance report schema file.


Name Type Accepts Output Streams Description
ReportName String False The name of the report.


ReportDescription String False A description for the report. If one is not specified, a description based on the ReportType will be selected.
AccountingMethod String False The accounting method used in the report.

使用できる値は次のとおりです。Cash, Accrual

DateMacro String False A predefined date range. Use this if you want the report to cover a standard report date range. Otherwise, use the StartDate and EndDate to cover an explicit range.

使用できる値は次のとおりです。Today, Yesterday, This Week, This Week-to-date, Last Week, Last Week-to-date, Next Week, Next 4 Weeks, This Month, This Month-to-date, Last Month, Last Month-to-date, Next Month, This Fiscal Quarter, This Fiscal Year, This Fiscal Year-to-date, Last Fiscal Year, Last Fiscal Year-to-date, Next Fiscal Year

StartDate String False The startdate of the report. StartDate must be less than EndDate.
EndDate String False The enddate of the report. EndDate must be greater than StartDate.
SummarizeColumnsBy String False The criteria by which to group the report results.

使用できる値は次のとおりです。Total, Month, Week, Days, Quarter, Year, Customers, Vendors, Classes, Departments, Employees, ProductsAndServices

Locale String False Specify the Locale of the QBOnline Company you are running this report for. This is generally needed when calling GeneralLedger and TrailBalance reports for a French company. In that case, specify the locale as FR.
FileStream String True An instance of an output stream where file data is written to.
FileStream String True An instance of an output stream where file data is written to. Only used if WriteToFile set to false
WriteToFile String False Whether to write to an output file or not. Defaults to true, must be set to false to write to FileStream or FileData.

Result Set Columns

Name Type Description
Result String Success or Failure.
SchemaFile String The generated schema file.
Columns String The number of columns found.
FileData String The BASE64 downloaded file content. Only returned if WriteToFile set to false and FileStream is not set.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8770