EndPoint Get FlatFile Report (Live)

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

RequestReportCsv

Description

Returns data from FlatFile Reports (TSV - Tab Seperated Values) listed here http://docs.developer.amazonservices.com/en_US/reports/Reports_ReportType.html. Depending which Report you choose, it can take upto 30 minutes to generate report. To get data from previously generated report, you can use [Get CSV Report By ID - Cached Copy] endpoint to fetch data by GeneratedReportId

Parameters

Parameter

Label

Required

Options

Description

ReportType

YES

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: 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_
Pending Order: Flat File Pending Orders Report	_GET_FLAT_FILE_PENDING_ORDERS_DATA_
Pending Order: Converged Flat File Pending Orders Report	_GET_CONVERGED_FLAT_FILE_PENDING_ORDERS_DATA_
Returns: Flat File Returns Report by Return Date	_GET_FLAT_FILE_RETURNS_DATA_BY_RETURN_DATE_
Returns: CSV Prime Returns Report by Return Date	_GET_CSV_MFN_PRIME_RETURNS_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_
Settlement: Flat File Settlement Report	_GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_
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_

StartDate

Report Start date if applicable - Must be UTC date in ISO format e.g. (2020-01-31T00:00:00Z).

EndDate

Report End date if applicable - Must be UTC date in ISO format e.g. (2020-01-31T00:00:00Z).

ReportOptions

Option	Value
Return Custom Report	custom=true

Version

MarketplaceIdList

Option	Value
US	ATVPDKIKX0DER
Brazil	A2Q3Y263D00KWC
Canada	A2EUQ1WTGCTBG2
Mexico	A1AM78C64UM0Y8
United Arab Emirates (U.A.E.)	A2VIGQ35RCS4UG
Germany	A1PA6795UKMFR9
Egypt	ARBP9OOSHTCHU
Spain	A1RKKUPIHCS9HS
France	A13V1IB3VIYZZH
UK	A1F83G8C2ARO7P
India	A21TJRUUN4KGV
Italy	APJ6JRA9NG5V4
Netherlands	A1805IZSGTT6HS
Saudi Arabia	A17E79C6D8DWNP
Turkey	A33AVAJ2PDY3EV
Singapore	A19VAU5U5O7RUS
Australia	A39IBJ37TRP1C6
Japan	A1VC38T7YXB528

Output Columns

Label	DataType	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Input Columns

Label	DataType	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.