EndPoint Get Report Data - Tab Separated File (TSV)

Name

get_report_tsv

Description

No description available

Parameters

Parameter

Label

Required

Options

Description

ReportType

YES

MarketplaceIds

YES

Option	Value
United States of America	ATVPDKIKX0DER
Brazil	A2Q3Y263D00KWC
Canada	A2EUQ1WTGCTBG2
Mexico	A1AM78C64UM0Y8
Spain	A1RKKUPIHCS9HS
United Kingdom	A1F83G8C2ARO7P
France	A13V1IB3VIYZZH
Belgium	AMEN7PMS3EDWL
Netherlands	A1805IZSGTT6HS
Germany	A1PA6795UKMFR9
Italy	APJ6JRA9NG5V4
Sweden	A2NODRKZP88ZB9
South Africa	AE08WJ6YKNBMC
Poland	A1C3SOZRARQ6R3
Egypt	ARBP9OOSHTCHU
Turkey	A33AVAJ2PDY3EV
Saudi Arabia	A17E79C6D8DWNP
United Arab Emirates (U.A.E.)	A2VIGQ35RCS4UG
India	A21TJRUUN4KGV
Singapore	A19VAU5U5O7RUS
Australia	A39IBJ37TRP1C6
Japan	A1VC38T7YXB528

StartDate

Option	Value
2023-12-31	2023-12-31
2023-12-31T00:00:00	2023-12-31T00:00:00
now	now
now-24h	now-24h
today	today
yesterday	yesterday
yearstart-10y	yearstart-10y
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d
monthend+1d-1y	monthend+1d-1y

Report Start date if applicable - Must be UTC date in ISO format e.g. (2020-01-31T00:00:00Z). You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)

EndDate

Option	Value
2023-12-31	2023-12-31
2023-12-31T00:00:00	2023-12-31T00:00:00
now	now
now-24h	now-24h
today	today
yesterday	yesterday
yearstart-10y	yearstart-10y
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d
monthend+1d-1y	monthend+1d-1y

Report End date if applicable - Must be UTC date in ISO format e.g. (2020-01-31T00:00:00Z). You can use static values or date functions. Supported functions are now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)

ReportOptions

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	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 Selling Partner (SP-API) Connector.

Input Columns

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

Examples

SSIS

Use Amazon Selling Partner (SP-API) Connector in API Source component to read data or in API Destination component to read/write data:

Get Report Data - Tab Separated File (TSV) using API Source

Amazon Selling Partner (SP-API)

Get Report Data - Tab Separated File (TSV)

SSIS API Source - Read from table or endpoint

Get Report Data - Tab Separated File (TSV) using API Destination

Amazon Selling Partner (SP-API)

Get Report Data - Tab Separated File (TSV)

SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Generate Report

This example shows how to get data from a specified report

SELECT *
FROM get_report_tsv
WITH(
	  ReportType='GET_MERCHANT_LISTINGS_ALL_DATA'
	, MarketplaceIds='ATVPDKIKX0DER'
)

SQL Server

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

Generate Report

This example shows how to get data from a specified report

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT *
FROM get_report_tsv
WITH(
	  ReportType=''GET_MERCHANT_LISTINGS_ALL_DATA''
	, MarketplaceIds=''ATVPDKIKX0DER''
)';

EXEC (@MyQuery) AT [LS_TO_AMAZON_SELLING_PARTNER_SP_API_IN_GATEWAY];