JDBC Driver for Amazon Marketplace

Build 22.0.8538

ReportRequestList

Usage information for the operation ReportRequestList.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 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_')

Columns

Name Type References Description
ReportRequestId [KEY] String The Report Request Id.
ReportType String The 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-Columns

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.

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

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