CData BizTalk Adapter for Amazon Marketplace 2019 - Online Help
Questions / Feedback?

ReportRequestList

CData BizTalk Adapter for Amazon Marketplace 2019 - Build 19.0.7354

Usage information for the operation ReportRequestList.rsd.

Select

The adapter 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 adapter. 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.

Columns

Name Type References Description
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-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) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0