JDBC Driver for Amazon Marketplace

Build 22.0.8538

ReportList

Usage information for the operation ReportList.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 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'

Columns

Name Type References Description
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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8538