ReportRequestListCData ODBC Driver for Amazon Marketplace 2019 - Build 19.0.7354
Usage information for the operation ReportRequestList.rsd.
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_')You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.
|ReportRequestId [KEY]||String||The Report Request Id|
|ReportType||String||TThe 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 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.
|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.|