JDBC Driver for QuickBooks Online

Build 24.0.9060

CreateAccountListReport

Generates an Account list report schema file.

Stored Procedure Specific Information

QuickBooks Online allows only a small subset of columns to be used in the Exec query. All the columns are optional for this Stored Procedure.

For example:

To create the RSD file, it will be generated based on the value of the Location connection property.

EXECUTE CreateAccountListReport

To return BASE64 encoded data in FileData column.

EXECUTE CreateAccountListReport WriteToFile	= 'False'

Input

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

The default value is AccountListReport.

ReportDescription String False A description for the report. If one is not specified, a description based on the ReportType will be selected.
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 24.0.9060