Reference

Endpoint List All Quotes

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 Required Options
Name: customer

Label: Customer Id

Only return invoices for the customer specified by this customer Id.
Name: status

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

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

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_WSTR nvarchar(108) 108
object DT_WSTR nvarchar(20) 20
amount_subtotal DT_I8 bigint
amount_total DT_I8 bigint
application DT_WSTR nvarchar(1020) 1020
application_fee_amount DT_WSTR nvarchar(1020) 1020
application_fee_percent DT_WSTR nvarchar(1020) 1020
automatic_tax_enabled DT_BOOL bit
automatic_tax_status DT_WSTR nvarchar(1020) 1020
collection_method DT_WSTR nvarchar(80) 80
recurring_amount_subtotal DT_I8 bigint
recurring_amount_total DT_I8 bigint
recurring_interval DT_WSTR nvarchar(20) 20
recurring_interval_count DT_I8 bigint
recurring_total_amount_discount DT_I8 bigint
recurring_total_amount_shipping DT_I8 bigint
recurring_total_amount_tax DT_I8 bigint
upfront_amount_subtotal DT_I8 bigint
upfront_amount_total DT_I8 bigint
upfront_total_amount_discount DT_I8 bigint
upfront_total_amount_shipping DT_I8 bigint
upfront_total_amount_tax DT_I8 bigint
Created DT_DBTIMESTAMP datetime
currency DT_WSTR nvarchar(12) 12
customer DT_WSTR nvarchar(72) 72
default_tax_rates DT_WSTR nvarchar(8) 8
description DT_WSTR nvarchar(140) 140
discounts DT_WSTR nvarchar(8) 8
expires_at DT_DBTIMESTAMP datetime
footer DT_WSTR nvarchar(80) 80
from_quote DT_WSTR nvarchar(1020) 1020
header DT_WSTR nvarchar(80) 80
invoice DT_WSTR nvarchar(1020) 1020
invoice_settings_days_until_due DT_WSTR nvarchar(1020) 1020
livemode DT_BOOL bit
number DT_WSTR nvarchar(72) 72
on_behalf_of DT_WSTR nvarchar(1020) 1020
status DT_WSTR nvarchar(16) 16
status_transitions_accepted_at DT_DBTIMESTAMP datetime
status_transitions_canceled_at DT_DBTIMESTAMP datetime
status_transitions_finalized_at DT_DBTIMESTAMP datetime
subscription DT_WSTR nvarchar(1020) 1020
subscription_data_description DT_WSTR nvarchar(1020) 1020
subscription_data_effective_date DT_DBTIMESTAMP datetime
subscription_data_trial_period_days DT_WSTR nvarchar(1020) 1020
subscription_schedule DT_WSTR nvarchar(1020) 1020
test_clock DT_WSTR nvarchar(1020) 1020
total_amount_discount DT_I8 bigint
total_amount_shipping DT_I8 bigint
total_details_amount_tax DT_I8 bigint
transfer_data DT_WSTR nvarchar(1020) 1020
If the column you are looking for is missing, consider customizing Stripe Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Stripe Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

API Source - Stripe
This connector support read/write operations for Stripe APIs
Stripe
List All Quotes
Optional Parameters
Customer Id
Status (draft or open or paid or uncollectible or void)
SSIS API Source - Read from table or endpoint

API Destination

API Destination - Stripe
This connector support read/write operations for Stripe APIs
Stripe
List All Quotes
Optional Parameters
Customer Id
Status (draft or open or paid or uncollectible or void)
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

List all quotes 

SELECT * FROM get_quotes

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

List all quotes 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_quotes';

EXEC (@MyQuery) AT [LS_TO_STRIPE_IN_GATEWAY];