FastSpring Connector Help

Version: 1
Home > Connectors > FastSpring > EndPoints > Get Quotes

EndPoint Get Quotes

Name

get_quotes

Description

Parameters

Parameter Label Required Options Description
PageSize PageSize NO
CreatedBegin Created Begin Date (yyyy-MM-dd) NO
Option Value
2023-12-31 2023-12-31
today today
yesterday yesterday
yearstart-10y yearstart-10y
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
monthend+1d-1y monthend+1d-1y
filters results to include quotes created after the specified begin date (must be at least one day before the specified end date)
CreatedEnd Created End Date (yyyy-MM-dd) NO
Option Value
2023-12-31 2023-12-31
today today
yesterday yesterday
yearstart-10y yearstart-10y
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
monthend+1d-1y monthend+1d-1y
filters results to include quotes created before the specified end date
CreatedEmail Created Email NO
QuoteId QuoteId NO
SearchFor SearchFor NO
Statuses Statuses NO
Option Value
OPEN OPEN
COMPLETED COMPLETED
CANCELED CANCELED
EXPIRED EXPIRED
expiresBegin Expires Begin Date (yyyy-MM-dd) NO
Option Value
2023-12-31 2023-12-31
today today
yesterday yesterday
yearstart-10y yearstart-10y
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
monthend+1d-1y monthend+1d-1y
filters results to include quotes expiring after the specified begin date (must be at least one day before the specified end date)
expiresEnd Expires End Date (yyyy-MM-dd) NO
Option Value
2023-12-31 2023-12-31
today today
yesterday yesterday
yearstart-10y yearstart-10y
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
monthend+1d-1y monthend+1d-1y
filters results to include quotes expiring before the specified end date
expiresBefore Expires Before Date (yyyy-MM-dd) NO
Option Value
2023-12-31 2023-12-31
today today
yesterday yesterday
yearstart-10y yearstart-10y
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
monthend+1d-1y monthend+1d-1y
filters results to include quotes expiring before the specified end date

Output Columns

Label DataType Length Raw Description
Id DT_WSTR 100 False
Name DT_WSTR 128 False
Status DT_WSTR 100 False
OrderReference DT_WSTR 100 False
Created DT_DBTIMESTAMP 0 False
Currency DT_WSTR 12 False
TotalInPayoutCurrency DT_R8 0 False
SubtotalInPayoutCurrency DT_R8 0 False
Item_1 DT_WSTR 100 False First item from this quote
Item_2 DT_WSTR 100 False Second item from this quote
Item_3 DT_WSTR 100 False Third item from this quote
InvoiceId DT_WSTR 100 False
Coupon DT_WSTR 100 False
Subtotal DT_R8 0 False
SubtotalDisplay DT_WSTR 100 False
SubtotalInPayoutCurrencyDisplay DT_WSTR 100 False
Tags DT_WSTR 4000 False
Tax DT_R8 0 False
TaxRate DT_R8 0 False
TaxType DT_WSTR 100 False
Total DT_R8 0 False
TotalDisplay DT_WSTR 100 False
TotalInPayoutCurrencyDisplay DT_WSTR 100 False
Updated DT_DBTIMESTAMP 0 False
TaxId DT_WSTR 100 False
RecipientCompany DT_WSTR 100 False
RecipientEmail DT_WSTR 255 False
RecipientFirst DT_WSTR 100 False
RecipientLast DT_WSTR 100 False
RecipientPhone DT_WSTR 100 False
RecipientUserId DT_WSTR 100 False
RecipientAddressAddressLine1 DT_WSTR 100 False
RecipientAddressAddressLine2 DT_WSTR 100 False
RecipientAddressCity DT_WSTR 100 False
RecipientAddressCountry DT_WSTR 100 False
RecipientAddressPostalCode DT_WSTR 100 False
RecipientAddressRegion DT_WSTR 100 False
CreatedByCompany DT_WSTR 100 False
CreatedByEmail DT_WSTR 100 False
CreatedByFirst DT_WSTR 100 False
CreatedByLast DT_WSTR 100 False
CreatedByPhone DT_WSTR 100 False
CreatedByUserId DT_WSTR 100 False
Discount DT_R8 0 False
DiscountDisplay DT_WSTR 100 False
DiscountInPayoutCurrency DT_R8 0 False
DiscountInPayoutCurrencyDisplay DT_WSTR 100 False
Expires DT_DBTIMESTAMP 0 False
ExpirationDateDays DT_I8 0 False
FulfillmentTerm DT_WSTR 100 False
BuyerGenerated DT_BOOL 0 False
CopyNotesToInvoice DT_BOOL 0 False
Items DT_NTEXT 0 False
Notes DT_WSTR 4000 False
NetTermsDays DT_I8 0 False
QuoteUrl DT_WSTR 448 False
SiteId DT_WSTR 100 False
StatusHistory DT_WSTR 4000 False
Source DT_WSTR 100 False
SourceIP DT_WSTR 100 False
IsGrossTax DT_BOOL 0 False

Input Columns

Label DataType Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.