EndPoint List All Quotes

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

get_quotes

Description

You can list all invoices, or list the invoices for a specific customer. The invoices are returned sorted by creation date, with the most recently created invoices appearing first. [API reference]

Parameters

Parameter

Label

Required

Options

Description

customer

Customer Id

Only return invoices for the customer specified by this customer Id.

status

Status (draft or open or paid or uncollectible or void)

Option	Value
draft	draft
open	open
paid	paid
uncollectible	uncollectible
void	void

The status of the invoice, one of draft, open, paid, uncollectible, or void

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(108)`	108	False
object	`DT_WSTR`	`nvarchar(20)`	20	False
amount_subtotal	`DT_I8`	`bigint`		False
amount_total	`DT_I8`	`bigint`		False
application	`DT_WSTR`	`nvarchar(1020)`	1020	False
application_fee_amount	`DT_WSTR`	`nvarchar(1020)`	1020	False
application_fee_percent	`DT_WSTR`	`nvarchar(1020)`	1020	False
automatic_tax_enabled	`DT_BOOL`	`bit`		False
automatic_tax_status	`DT_WSTR`	`nvarchar(1020)`	1020	False
collection_method	`DT_WSTR`	`nvarchar(80)`	80	False
recurring_amount_subtotal	`DT_I8`	`bigint`		False
recurring_amount_total	`DT_I8`	`bigint`		False
recurring_interval	`DT_WSTR`	`nvarchar(20)`	20	False
recurring_interval_count	`DT_I8`	`bigint`		False
recurring_total_amount_discount	`DT_I8`	`bigint`		False
recurring_total_amount_shipping	`DT_I8`	`bigint`		False
recurring_total_amount_tax	`DT_I8`	`bigint`		False
upfront_amount_subtotal	`DT_I8`	`bigint`		False
upfront_amount_total	`DT_I8`	`bigint`		False
upfront_total_amount_discount	`DT_I8`	`bigint`		False
upfront_total_amount_shipping	`DT_I8`	`bigint`		False
upfront_total_amount_tax	`DT_I8`	`bigint`		False
Created	`DT_DBTIMESTAMP`	`datetime`		False
currency	`DT_WSTR`	`nvarchar(12)`	12	False
customer	`DT_WSTR`	`nvarchar(72)`	72	False
default_tax_rates	`DT_WSTR`	`nvarchar(8)`	8	False
description	`DT_WSTR`	`nvarchar(140)`	140	False
discounts	`DT_WSTR`	`nvarchar(8)`	8	False
expires_at	`DT_DBTIMESTAMP`	`datetime`		False
footer	`DT_WSTR`	`nvarchar(80)`	80	False
from_quote	`DT_WSTR`	`nvarchar(1020)`	1020	False
header	`DT_WSTR`	`nvarchar(80)`	80	False
invoice	`DT_WSTR`	`nvarchar(1020)`	1020	False
invoice_settings_days_until_due	`DT_WSTR`	`nvarchar(1020)`	1020	False
livemode	`DT_BOOL`	`bit`		False
number	`DT_WSTR`	`nvarchar(72)`	72	False
on_behalf_of	`DT_WSTR`	`nvarchar(1020)`	1020	False
status	`DT_WSTR`	`nvarchar(16)`	16	False
status_transitions_accepted_at	`DT_DBTIMESTAMP`	`datetime`		False
status_transitions_canceled_at	`DT_DBTIMESTAMP`	`datetime`		False
status_transitions_finalized_at	`DT_DBTIMESTAMP`	`datetime`		False
subscription	`DT_WSTR`	`nvarchar(1020)`	1020	False
subscription_data_description	`DT_WSTR`	`nvarchar(1020)`	1020	False
subscription_data_effective_date	`DT_DBTIMESTAMP`	`datetime`		False
subscription_data_trial_period_days	`DT_WSTR`	`nvarchar(1020)`	1020	False
subscription_schedule	`DT_WSTR`	`nvarchar(1020)`	1020	False
test_clock	`DT_WSTR`	`nvarchar(1020)`	1020	False
total_amount_discount	`DT_I8`	`bigint`		False
total_amount_shipping	`DT_I8`	`bigint`		False
total_details_amount_tax	`DT_I8`	`bigint`		False
transfer_data	`DT_WSTR`	`nvarchar(1020)`	1020	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.