Tableau Connector for Amazon Marketplace

Build 20.0.7712

ReportList

Usage information for the operation ReportList.rsd.

Select

The connector 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 connector. 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) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7712