Get Quote By Id
Name
get_quote
Description
Related Tables
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:
Lookup a row in Quotes table using API Destination
This Endpoint belongs to Quotes table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

ODBC application
Use these SQL queries in your ODBC application data source:
Get quote by id
SELECT * FROM get_quote
WHERE Id = 'abcd-1234-id'
get_quote
endpoint belongs to
Quotes
table(s), and can therefore be used via those table(s).
SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Get quote by id
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_quote
WHERE Id = ''abcd-1234-id''';
EXEC (@MyQuery) AT [LS_TO_FASTSPRING_IN_GATEWAY];
get_quote
endpoint belongs to
Quotes
table(s), and can therefore be used via those table(s).