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. |