ReportListCData ODBC Driver for Amazon Marketplace 2019 - Build 19.0.7354
Usage information for the operation ReportList.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 ReportList WHERE ReportType IN '_GET_MERCHANT_LISTINGS_INACTIVE_DATA_'
SELECT * FROM ReportList WHERE ReportRequestId = '50566018029'
SELECT * FROM ReportList WHERE ReportRequestId IN ('50566018029', '50564018026')
SELECT * FROM ReportList WHERE AvailableDate > '2016-12-12' AND AvailableDate< '2018-11-12 12:00:00'
SELECT * FROM ReportList WHERE AvailableDate >= '2016-12-12' AND Acknowledged = 'true'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.
|ReportId [KEY]||String||Report Id|
|ReportType||String||The type of the Report.|
|ReportRequestId||String||The Report Request Id|
|Acknowledged||Boolean||A boolean value that indicates whether the order report has been acknowledged|
|AvailableDate||Datetime||Date on which the report was available. By default, reports available from the last 90 days will be returned.|