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 | Description |
| ReportName | String | The name of the report.
デフォルト値はAccountListReportです。 |
| ReportDescription | String | A description for the report. If one is not specified, a description based on the ReportType will be selected. |
| WriteToFile | String | 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. |