ReportRequestList
Usage information for the operation ReportRequestList.rsd.
Select
The driver will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.
For example, the following query is processed server side:
SELECT * FROM ReportRequestList WHERE ReportType = '_GET_MERCHANT_LISTINGS_INACTIVE_DATA_'
SELECT * FROM ReportRequestList WHERE ReportType IN ('_GET_MERCHANT_LISTINGS_INACTIVE_DATA_', '_GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_')
SELECT * FROM ReportRequestList WHERE ReportRequestId = '50566018029'
SELECT * FROM ReportRequestList WHERE ReportRequestId IN ('50566018029', '50564018026')
SELECT * FROM ReportRequestList WHERE RequestedDate > '2016-12-12'
SELECT * FROM ReportRequestList WHERE RequestedDate > '2016-12-12' AND RequestedDate > '2018-12-12 13:00'
SELECT * FROM ReportRequestList WHERE RequestedDate <= '2016-12-12' AND ReportProcessingStatus = '_DONE_'
SELECT * FROM ReportRequestList WHERE ReportProcessingStatus IN ('_DONE_', '_SUBMITTED_', '_CANCELLED_')
Columns
| Name | Type | References | Description |
| ReportRequestId [KEY] | String | The Report Request Id. | |
| ReportType | String | The type of the Report. | |
| StartDate | Datetime | The start date of the request. | |
| EndDate | Datetime | The end date of the request. | |
| Scheduled | Boolean | A boolean value that indicates whether the report request was scheduled. | |
| SubmittedDate | Datetime | The date and time the report was submitted. | |
| ReportProcessingStatus | String | Processing status of the report. Possible values are: _SUBMITTED_, _IN_PROGRESS_, _CANCELLED_, _DONE_, _DONE_NO_DATA_ | |
| GeneratedReportId | String | The report id generated from Amazon MWS. | |
| StartedProcessingDate | Datetime | The date and time that the report stated to be processed. | |
| CompletedDate | Datetime | The date and time that the report was completed. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| RequestedDate | Datetime | The date and time that the report was requested. By default, reports requested within the range of the last 90 days will be returned. |