ReportList
Returns report details for the reports that match the filters that you specify.
Select
The add-in 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 add-in.
Note: 'ReportType' attribute is required to query the view. You can view available values for 'ReportType' in Amazon Selling-Partner API Documentation, or you can query the 'ReportTypes' view.
- ReportId supports the '=' comparison.
- ReportType supports the '=', 'IN' comparisons.
- MarketplaceIds supports the '=', 'IN' comparisons.
- ProcessingStatus supports the '=', 'IN' comparisons.
- CreatedTime supports the '=', '<', '>', '<=', '>=' comparisons.
Following are example queries that are processed server side:
SELECT * FROM ReportList WHERE ReportId = '51013018828'
SELECT * FROM ReportList WHERE ReportType = 'GET_FLAT_FILE_OPEN_LISTINGS_DATA'
SELECT * FROM ReportList WHERE ReportType = 'GET_FLAT_FILE_OPEN_LISTINGS_DATA' AND CreatedTime > '2021-06-12' AND CreatedTime < '2021-08-01 12:00:00'
SELECT * FROM ReportList WHERE ReportType = 'GET_FLAT_FILE_OPEN_LISTINGS_DATA' AND MarketplaceIds = 'A1VC38T7YXB528'
SELECT * FROM ReportList WHERE ReportType = 'GET_FLAT_FILE_OPEN_LISTINGS_DATA' AND ProcessingStatus = 'DONE'
Note: When filtering with CreatedTime, values older than 90 days will not be accepted.
Columns
| Name | Type | References | Description |
| ReportId [KEY] | String | Report Id. | |
| ReportType | String | The type of the Report. ReportType is not required when UseSandbox=True. | |
| ReportDocumentId | String | The identifier for the report document. | |
| CreatedTime | Datetime | The date and time when the report was created. While filtering, CreatedTime value is only accepted till 90 days old. | |
| DataStartTime | Datetime | The start of a date and time range used for selecting the data to report. | |
| DataEndTime | Datetime | The end of a date and time range used for selecting the data to report. | |
| MarketplaceIds | String | A list of marketplace identifiers for the report. | |
| ProcessingStartTime | Datetime | The date and time when the report processing started. | |
| ProcessingEndTime | Datetime | The date and time when the report processing completed. | |
| ProcessingStatus | String | The processing status of the report. |