GetReport
Creates and/or returns data for a specific report.
Execute
We can use GetReport stored procedure in two ways:
To create and download a report in which case you must at least set ReportType, StartDate and DownloadPath attributes. The stored procedure will wait until the report is processed server side.
EXEC GetReport @ReportDocumentId = '1234', @DownloadPath = 'C:\Tests\AmazonMarketplaceTest'
Input
| Name | Type | Required | Description |
| ReportDocumentId | String | True | Unique ID of the report to download. |
| DownloadPath | String | True | The File path to write the report data. If no path is specified, the file is kept in memory in the FileData output. |
| IsRestrictedReport | Boolean | False | Boolean indicating whether the specified report ID is a restricted report (report containing PII).
The default value is false. |
Result Set Columns
| Name | Type | Description |
| Success | Boolean | Boolean indicating the result of the operation. |
| Url | String | A unique identifier for the report. |
| FileData | String | The file data output, if the LocalPath input is empty. |