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

ReportList

CData BizTalk Adapter for Amazon Marketplace 2019 - Build 19.0.7354

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

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