Reference

Endpoint Get Report Requests

Name

GetReportRequestList

Description

Returns a list of report requests that you can use to get the ReportRequestId for a report. [API reference]

Parameters

Parameter Required Options
Name: Version

Label: Version
Name: ReportTypeList

Label: ReportTypeList
Option Value
Inventory: Inventory Report _GET_FLAT_FILE_OPEN_LISTINGS_DATA_
Inventory: Inventory ReportAll Listings Report _GET_MERCHANT_LISTINGS_ALL_DATA_
Inventory: Active Listings Report _GET_MERCHANT_LISTINGS_DATA_
Inventory: Inactive Listings Report _GET_MERCHANT_LISTINGS_INACTIVE_DATA_
Inventory: Open Listings Report _GET_MERCHANT_LISTINGS_DATA_BACK_COMPAT_
Inventory: Open Listings Report Lite _GET_MERCHANT_LISTINGS_DATA_LITE_
Inventory: Open Listings Report Liter _GET_MERCHANT_LISTINGS_DATA_LITER_
Inventory: Canceled Listings Report _GET_MERCHANT_CANCELLED_LISTINGS_DATA_
Inventory: Sold Listings Report _GET_CONVERGED_FLAT_FILE_SOLD_LISTINGS_DATA_
Inventory: Listing Quality and Suppressed Listing Report _GET_MERCHANT_LISTINGS_DEFECT_DATA_
Inventory: Pan-European Eligibility: FBA ASINs _GET_PAN_EU_OFFER_STATUS_
Inventory: Pan-European Eligibility: Self-fulfilled ASINs _GET_MFN_PAN_EU_OFFER_STATUS_
Inventory: Global Expansion Opportunities Report _GET_FLAT_FILE_GEO_OPPORTUNITIES_
Inventory: Referral Fee Preview Report _GET_REFERRAL_FEE_PREVIEW_REPORT_
Order: Unshipped Orders Report _GET_FLAT_FILE_ACTIONABLE_ORDER_DATA_
Order: Scheduled XML Order Report _GET_ORDERS_DATA_
Order: Requested or Scheduled Flat File Order Report _GET_FLAT_FILE_ORDERS_DATA_
Order: Flat File Order Report _GET_CONVERGED_FLAT_FILE_ORDER_REPORT_DATA_
Order Tracking: Flat File Orders By Last Update Report _GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_
Order Tracking: Flat File Orders By Order Date Report _GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_
Order Tracking: Flat File Archived Orders Report _GET_FLAT_FILE_ARCHIVED_ORDERS_DATA_BY_ORDER_DATE_
Order Tracking: XML Orders By Last Update Report _GET_XML_ALL_ORDERS_DATA_BY_LAST_UPDATE_
Order Tracking: XML Orders By Order Date Report _GET_XML_ALL_ORDERS_DATA_BY_ORDER_DATE_
Pending Order: Flat File Pending Orders Report _GET_FLAT_FILE_PENDING_ORDERS_DATA_
Pending Order: XML Pending Orders Report _GET_PENDING_ORDERS_DATA_
Pending Order: Converged Flat File Pending Orders Report _GET_CONVERGED_FLAT_FILE_PENDING_ORDERS_DATA_
Returns: XML Returns Report by Return Date _GET_XML_RETURNS_DATA_BY_RETURN_DATE_
Returns: Flat File Returns Report by Return Date _GET_FLAT_FILE_RETURNS_DATA_BY_RETURN_DATE_
Returns: XML Prime Returns Report by Return Date _GET_XML_MFN_PRIME_RETURNS_REPORT_
Returns: CSV Prime Returns Report by Return Date _GET_CSV_MFN_PRIME_RETURNS_REPORT_
Returns: XML Return Attributes Report by Return Date _GET_XML_MFN_SKU_RETURN_ATTRIBUTES_REPORT_
Returns: Flat File Return Attributes Report by Return Date _GET_FLAT_FILE_MFN_SKU_RETURN_ATTRIBUTES_REPORT_
Performance: Flat File Feedback Report _GET_SELLER_FEEDBACK_DATA_
Performance: XML Customer Metrics Report _GET_V1_SELLER_PERFORMANCE_REPORT_
Settlement: Flat File Settlement Report _GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_
Settlement: XML Settlement Report _GET_V2_SETTLEMENT_REPORT_DATA_XML_
Settlement: Flat File V2 Settlement Report _GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2_
FBA Sales: FBA Amazon Fulfilled Shipments Report _GET_AMAZON_FULFILLED_SHIPMENTS_DATA_
FBA Sales: Flat File All Orders Report by Last Update _GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_
FBA Sales: Flat File All Orders Report by Order Date _GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_
FBA Sales: XML All Orders Report by Last Update _GET_XML_ALL_ORDERS_DATA_BY_LAST_UPDATE_
FBA Sales: XML All Orders Report by Order Date _GET_XML_ALL_ORDERS_DATA_BY_ORDER_DATE_
FBA Sales: FBA Customer Shipment Sales Report _GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_SALES_DATA_
FBA Sales: FBA Promotions Report _GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_PROMOTION_DATA_
FBA Sales: FBA Customer Taxes _GET_FBA_FULFILLMENT_CUSTOMER_TAXES_DATA_
FBA Sales: Remote Fulfillment Eligibility _GET_REMOTE_FULFILLMENT_ELIGIBILITY_
FBA Inventory: FBA Amazon Fulfilled Inventory Report _GET_AFN_INVENTORY_DATA_
FBA Inventory: FBA Multi-Country Inventory Report _GET_AFN_INVENTORY_DATA_BY_COUNTRY_
FBA Inventory: FBA Daily Inventory History Report _GET_FBA_FULFILLMENT_CURRENT_INVENTORY_DATA_
FBA Inventory: FBA Monthly Inventory History Report _GET_FBA_FULFILLMENT_MONTHLY_INVENTORY_DATA_
FBA Inventory: FBA Received Inventory Report _GET_FBA_FULFILLMENT_INVENTORY_RECEIPTS_DATA_
FBA Inventory: FBA Reserved Inventory Report _GET_RESERVED_INVENTORY_DATA_
FBA Inventory: FBA Inventory Event Detail Report _GET_FBA_FULFILLMENT_INVENTORY_SUMMARY_DATA_
FBA Inventory: FBA Inventory Adjustments Report _GET_FBA_FULFILLMENT_INVENTORY_ADJUSTMENTS_DATA_
FBA Inventory: FBA Inventory Health Report _GET_FBA_FULFILLMENT_INVENTORY_HEALTH_DATA_
FBA Inventory: FBA Manage Inventory _GET_FBA_MYI_UNSUPPRESSED_INVENTORY_DATA_
FBA Inventory: FBA Manage Inventory - Archived _GET_FBA_MYI_ALL_INVENTORY_DATA_
FBA Inventory: Restock Inventory Report _GET_RESTOCK_INVENTORY_RECOMMENDATIONS_REPORT_
FBA Inventory: FBA Inbound Performance Report _GET_FBA_FULFILLMENT_INBOUND_NONCOMPLIANCE_DATA_
FBA Inventory: FBA Stranded Inventory Report _GET_STRANDED_INVENTORY_UI_DATA_
FBA Inventory: FBA Bulk Fix Stranded Inventory Report _GET_STRANDED_INVENTORY_LOADER_DATA_
FBA Inventory: FBA Inventory Age Report _GET_FBA_INVENTORY_AGED_DATA_
FBA Inventory: FBA Manage Excess Inventory Report _GET_EXCESS_INVENTORY_DATA_
FBA Inventory: FBA Storage Fees Report _GET_FBA_STORAGE_FEE_CHARGES_DATA_
FBA Inventory: Get Report Exchange Data _GET_PRODUCT_EXCHANGE_DATA_
FBA Inventory: FBA Fee Preview Report _GET_FBA_ESTIMATED_FBA_FEES_TXT_DATA_
FBA Inventory: FBA Reimbursements Report _GET_FBA_REIMBURSEMENTS_DATA_
FBA Inventory: FBA Long Term Storage Fee Charges Report _GET_FBA_FULFILLMENT_LONGTERM_STORAGE_FEE_CHARGES_DATA_
FBA Inventory: FBA Returns Report _GET_FBA_FULFILLMENT_CUSTOMER_RETURNS_DATA_
FBA Inventory: FBA Replacements Report _GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_REPLACEMENT_DATA_
FBA Inventory: FBA Recommended Removal Report _GET_FBA_RECOMMENDED_REMOVAL_DATA_
FBA Inventory: FBA Removal Order Detail Report _GET_FBA_FULFILLMENT_REMOVAL_ORDER_DETAIL_DATA_
FBA Inventory: FBA Removal Shipment Detail Report _GET_FBA_FULFILLMENT_REMOVAL_SHIPMENT_DETAIL_DATA_
FBA Inventory: Small and Light Inventory Report _GET_FBA_UNO_INVENTORY_DATA_
Tax: Sales Tax Report _GET_FLAT_FILE_SALES_TAX_DATA_
Tax: Amazon VAT Calculation Report _SC_VAT_TAX_REPORT_
Tax: Amazon VAT Transactions Report _GET_VAT_TRANSACTION_DATA_
Tax: On Demand GST Merchant Tax Report B2B _GET_GST_MTR_B2B_CUSTOM_
Tax: On Demand GST Merchant Tax Report B2C _GET_GST_MTR_B2C_CUSTOM_
Browse Tree: Browse Tree Report _GET_XML_BROWSE_TREE_DATA_
Name: MaxCount

Label: MaxCount

Maximum number of report requests to return. If you specify a number greater than 100, the request is rejected. Default is 100 if you do not enter.
Name: ReportStatus

Label: ReportStatus

A structured list of report processing statuses by which to filter report requests. Default is All
Option Value
_SUBMITTED_ _SUBMITTED_
_IN_PROGRESS_ _IN_PROGRESS_
_CANCELLED_ _CANCELLED_
_DONE_ _DONE_
_DONE_NO_DATA_ _DONE_NO_DATA_
Name: RequestedFromDate

Label: RequestedFromDate

The earliest date you are looking for. Date format must be UTC - ISO 8601 format (e.g. 2017-02-10T12:10:02Z)
Name: RequestedToDate

Label: RequestedToDate

The most recent date you are looking for. Date format must be UTC - ISO 8601 format (e.g. 2017-02-10T12:10:02Z)
Name: ReportRequestIdList.Id.1

Label: ReportRequestId

If you like to check status of specific ReportRequestId then enter here

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
ReportRequestId DT_I8 bigint
ReportType DT_WSTR nvarchar(220) 220
Acknowledged DT_BOOL bit
GeneratedReportId DT_I8 bigint
StartDate DT_DBTIMESTAMP datetime
EndDate DT_DBTIMESTAMP datetime
ReportProcessingStatus DT_WSTR nvarchar(50) 50
SubmittedDate DT_DBTIMESTAMP datetime
StartedProcessingDate DT_DBTIMESTAMP datetime
CompletedDate DT_DBTIMESTAMP datetime
If the column you are looking for is missing, consider customizing Amazon MWS Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Amazon MWS Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

API Source - Amazon MWS
Read and write Amazon MWS data effortlessly. Integrate, manage, and automate listings, orders, payments, and reports — almost no coding required.
Amazon MWS
Get Report Requests
Optional Parameters
Version 2009-01-01
ReportTypeList
MaxCount
ReportStatus
RequestedFromDate
RequestedToDate
ReportRequestId
ElementsToTreatAsArray ReportRequestInfo
SSIS API Source - Read from table or endpoint

API Destination

API Destination - Amazon MWS
Read and write Amazon MWS data effortlessly. Integrate, manage, and automate listings, orders, payments, and reports — almost no coding required.
Amazon MWS
Get Report Requests
Optional Parameters
Version 2009-01-01
ReportTypeList
MaxCount
ReportStatus
RequestedFromDate
RequestedToDate
ReportRequestId
ElementsToTreatAsArray ReportRequestInfo
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get report requests 

SELECT * FROM GetReportRequestList

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get report requests 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM GetReportRequestList';

EXEC (@MyQuery) AT [LS_TO_AMAZON_MWS_IN_GATEWAY];