Reference

Endpoint Get Report Count

Name

GetReportCount

Description

Returns a count of the reports, created in the previous 90 days, with a status of _DONE_ and that are available for download. [API reference]

Parameters

Parameter

Required

Options

Name: AmazonOrderId

Label: AmazonOrderId

A list of AmazonOrderId values. An AmazonOrderId is an Amazon-defined order identifier, in 3-7-7 format. (Example: 058-1233752-8214740).

YES

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: Acknowledged

Label: Acknowledged

A Boolean value that indicates if an order report has been acknowledged by a prior call to UpdateReportAcknowledgements. Set to true to list order reports that have been acknowledged; set to false to list order reports that have not been acknowledged. This filter is valid only with order reports; it does not work with listing reports.

Option	Value
true	true
false	false

Name: AvailableFromDate

Label: AvailableFromDate

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

Name: AvailableToDate

Label: AvailableToDate

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

Name: Version

Label: Version

Output 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.

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 Count

Required Parameters
AmazonOrderId	Fill-in the parameter...
Optional Parameters
ReportTypeList
Acknowledged
AvailableFromDate
AvailableToDate
Version	2009-01-01

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 Count

Required Parameters
AmazonOrderId	Fill-in the parameter...
Optional Parameters
ReportTypeList
Acknowledged
AvailableFromDate
AvailableToDate
Version	2009-01-01

SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get report count

SELECT * FROM GetReportCount
WITH
(
    "AmazonOrderId" = 'abcd-1234-amazonorderid'
)

SQL Server

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

Get report count

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM GetReportCount
WITH
(
    "AmazonOrderId" = ''abcd-1234-amazonorderid''
)';

EXEC (@MyQuery) AT [LS_TO_AMAZON_MWS_IN_GATEWAY];