ReportList
Returns report details for the reports that match the filters that you specify.
Select
The connector 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 connector.
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. |