EndPoint Get Product Prices
Parameters
Parameter | Label | Required | Options | Description |
---|---|---|---|---|
Country | Country Code | NO | ||
Currency | Currency Code | NO | ||
PageSize | PageSize | NO |
Output Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
Product |
DT_WSTR
|
nvarchar(200)
|
200 | False |
|
Country |
DT_WSTR
|
nvarchar(8)
|
8 | False |
|
Currency |
DT_WSTR
|
nvarchar(12)
|
12 | False |
|
Price |
DT_R8
|
float
|
False |
||
PriceDisplay |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
Discount2DiscountPercent |
DT_R8
|
float
|
False |
||
Discount2DiscountValue |
DT_R8
|
float
|
False |
||
Discount2DiscountValueDisplay |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
Discount2UnitPrice |
DT_R8
|
float
|
False |
||
Discount2UnitPriceDisplay |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
Discount3DiscountPercent |
DT_R8
|
float
|
False |
||
Discount3DiscountValue |
DT_R8
|
float
|
False |
||
Discount3DiscountValueDisplay |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
Discount3UnitPrice |
DT_R8
|
float
|
False |
||
Discount3UnitPriceDisplay |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
Discount4DiscountPercent |
DT_R8
|
float
|
False |
||
Discount4DiscountValue |
DT_R8
|
float
|
False |
||
Discount4DiscountValueDisplay |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
Discount4UnitPrice |
DT_R8
|
float
|
False |
||
Discount4UnitPriceDisplay |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
Discount5DiscountPercent |
DT_R8
|
float
|
False |
||
Discount5DiscountValue |
DT_R8
|
float
|
False |
||
Discount5DiscountValueDisplay |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
Discount5UnitPrice |
DT_R8
|
float
|
False |
||
Discount5UnitPriceDisplay |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
DiscountReason |
DT_WSTR
|
nvarchar(64)
|
64 | False |
|
DiscountPeriodCount |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
|
AvailableStart |
DT_DBDATE
|
date
|
False |
||
AvailableEnd |
DT_DBDATE
|
date
|
False |
||
SetupFeePrice |
DT_R8
|
float
|
False |
||
SetupFeePriceDisplay |
DT_WSTR
|
nvarchar(50)
|
50 | False |
|
SetupFeeReason |
DT_WSTR
|
nvarchar(100)
|
100 | 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 FastSpring Connector in API Source component to read data or in API Destination component to read/write data:
Get Product Prices using API Source
FastSpring
Get Product Prices

Get Product Prices using API Destination
FastSpring
Get Product Prices
