CreateAccountListReport

Generates an Account List report schema file, allowing you to extract the structure of your QuickBooks chart of accounts for integration or analysis.

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'


Name	Type	Description
ReportName	String	The name of the report that is to be generated. This name identifies which report definition QuickBooks Online should use. The default value is AccountListReport.
ReportDescription	String	A description for the report. If the report description is not specified, QuickBooks Online selects a description based on the report type.
WriteToFile	String	Indicates whether the stored procedure writes the output to a file. This input defaults to true. Set it to false to have the procedure write the output to the filestream that you supply or to return the output as file data.


Name	Type	Description
Result	String	Indicates whether the stored-procedure execution completed successfully or failed. The stored procedure returns the Result output so that calling applications can check the execution status.
SchemaFile	String	The generated schema file that is produced by the stored procedure. The SchemaFile output contains the structure of the report.
Columns	String	The number of columns that are found in the generated report. The Columns output helps applications validate and map returned data.
FileData	String	The Base64-encoded downloaded file content. The FileData output is returned only when the WriteToFile parameter is set to false and the FileStream parameter is not set.