Endpoint

Get Report Types

Name

get_report_types

No description available

Parameter

Label

Required

Options

Description

Filter

Option	Value
All Reports	$.data[*]
Tab-delimited / Flat File Reports	$.data[?(@format=='TSV')]
Comma-delimited Reports	$.data[?(@format=='CSV')]
XML Reports	$.data[?(@format=='XML')]
PDF Reports	$.data[?(@format=='PDF')]
Excel (XLSX) Reports	$.data[?(@format=='XLSX')]

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
Name	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
Category	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
Format	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
Options	`DT_WSTR`	`nvarchar(4000)`	4000	`False`

If the column you are looking for is missing, consider customizing Amazon Selling Partner (SP-API) Connector.

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.

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

This Endpoint belongs to ReportTypes table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Amazon Selling Partner (SP-API)

ReportTypes

Select

Use these SQL queries in your ODBC application data source:

SELECT * FROM get_report_types

Lists report types which you can use for download_report / get_report_tsv / get_report_csv or get_report_xml endpoints

SELECT * FROM ReportTypes)

get_report_types endpoint belongs to ReportTypes table(s), and can therefore be used via those table(s).

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

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

EXEC (@MyQuery) AT [LS_TO_AMAZON_SELLING_PARTNER_SP_API_IN_GATEWAY];

Lists report types which you can use for download_report / get_report_tsv / get_report_csv or get_report_xml endpoints

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

EXEC (@MyQuery) AT [LS_TO_AMAZON_SELLING_PARTNER_SP_API_IN_GATEWAY];

get_report_types endpoint belongs to ReportTypes table(s), and can therefore be used via those table(s).