Amazon Selling Partner (SP-API) Connector
Documentation
Version: 1
Documentation

EndPoint Get Report Options


Name

get_report_options

Description

No description available

Parameters

Parameter Label Required Options Description
Filter Filter NO
Option Value
All Options $.data[*].opt[*].v[*]
All Reports $.data[*].opt[0].v[0]
Options For One Report $.data[?(@id=='GET_MERCHANT_LISTINGS_ALL_DATA')].opt[*].v[*]

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
Id DT_WSTR nvarchar(4000) 4000 False
ReportName DT_WSTR nvarchar(4000) 4000 False
ReportCategory DT_WSTR nvarchar(4000) 4000 False
FileFormat DT_WSTR nvarchar(4000) 4000 False
OptionName DT_WSTR nvarchar(4000) 4000 False
OptionValue DT_WSTR nvarchar(4000) 4000 False
OptionNameValue DT_WSTR nvarchar(4000) 4000 False

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 Options using API Source

Amazon Selling Partner (SP-API)
Get Report Options
SSIS API Source - Read from table or endpoint

Get Report Options using API Destination

Amazon Selling Partner (SP-API)
Get Report Options
SSIS API Destination - Access table or endpoint