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
|
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 |
|