EndPoint Get Quote By Id
Parameters
Parameter | Label | Required | Options | Description |
---|---|---|---|---|
Id | Quote Id | YES |
Output Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
Id |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
Name |
DT_WSTR
|
nvarchar(128)
|
128 | False |
|
Status |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
OrderReference |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
Created |
DT_DBTIMESTAMP
|
datetime
|
False |
||
Currency |
DT_WSTR
|
nvarchar(12)
|
12 | False |
|
TotalInPayoutCurrency |
DT_R8
|
float
|
False |
||
SubtotalInPayoutCurrency |
DT_R8
|
float
|
False |
||
Item_1 |
DT_WSTR
|
nvarchar(100)
|
100 | False |
First item from this quote |
Item_2 |
DT_WSTR
|
nvarchar(100)
|
100 | False |
Second item from this quote |
Item_3 |
DT_WSTR
|
nvarchar(100)
|
100 | False |
Third item from this quote |
InvoiceId |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
Coupon |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
Subtotal |
DT_R8
|
float
|
False |
||
SubtotalDisplay |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
SubtotalInPayoutCurrencyDisplay |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
Tags |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
|
Tax |
DT_R8
|
float
|
False |
||
TaxRate |
DT_R8
|
float
|
False |
||
TaxType |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
Total |
DT_R8
|
float
|
False |
||
TotalDisplay |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
TotalInPayoutCurrencyDisplay |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
Updated |
DT_DBTIMESTAMP
|
datetime
|
False |
||
TaxId |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
RecipientCompany |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
RecipientEmail |
DT_WSTR
|
nvarchar(255)
|
255 | False |
|
RecipientFirst |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
RecipientLast |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
RecipientPhone |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
RecipientUserId |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
RecipientAddressAddressLine1 |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
RecipientAddressAddressLine2 |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
RecipientAddressCity |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
RecipientAddressCountry |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
RecipientAddressPostalCode |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
RecipientAddressRegion |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
CreatedByCompany |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
CreatedByEmail |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
CreatedByFirst |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
CreatedByLast |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
CreatedByPhone |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
CreatedByUserId |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
Discount |
DT_R8
|
float
|
False |
||
DiscountDisplay |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
DiscountInPayoutCurrency |
DT_R8
|
float
|
False |
||
DiscountInPayoutCurrencyDisplay |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
Expires |
DT_DBTIMESTAMP
|
datetime
|
False |
||
ExpirationDateDays |
DT_I8
|
bigint
|
False |
||
FulfillmentTerm |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
BuyerGenerated |
DT_BOOL
|
bit
|
False |
||
CopyNotesToInvoice |
DT_BOOL
|
bit
|
False |
||
Items |
DT_NTEXT
|
nvarchar(MAX)
|
False |
||
Notes |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
|
NetTermsDays |
DT_I8
|
bigint
|
False |
||
QuoteUrl |
DT_WSTR
|
nvarchar(448)
|
448 | False |
|
SiteId |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
StatusHistory |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
|
Source |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
SourceIP |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
IsGrossTax |
DT_BOOL
|
bit
|
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 Quote By Id using API Source
FastSpring
Get Quote By Id

Get Quote By Id using API Destination
FastSpring
Get Quote By Id
