Connexion Stripe pour LinkyFlow

LinkyFlow connecte Excel a Stripe pour consulter, modifier et publier les donnees e-commerce utiles depuis un tableur.

Ressources

Requetes de lecture

Actions ecriture

Champs documentes

137

Workflows a ramener dans Excel

Chaque ressource ci-dessous correspond a un workflow tableur concret. Les lectures ramenent des colonnes utiles dans Excel; les creations et modifications indiquent ce qui peut etre relu en lignes avant envoi.

Billing

Coupons

Discount coupons.

Lecture

Coupons

Discount coupons.

Route: GET /coupons

Formule Excel: =LF.stripe.coupons("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`limit`	number	No	Rows per page (max 100) Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`amount_off` default	number	—	-
`created` default	date	—	-
`duration` default	enum	—	-
`id` default	id	—	-
`name` default	string	—	-
`percent_off` default	number	—	-
`times_redeemed` default	number	—	-

Creation

Create Coupon

Route: POST /mutation/coupons

Entrees configurables

Name	Type	Required	Description
`amount_off`	number	No	-
`currency`	string	No	-
`duration`	enum	Yes	Values: forever, once, repeating
`duration_in_months`	number	No	-
`name`	string	No	-
`percent_off`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Coupon

Route: PATCH /mutation/coupons

Entrees configurables

Name	Type	Required	Description
`amount_off`	number	No	-
`currency`	string	No	-
`duration`	enum	Yes	Values: forever, once, repeating
`duration_in_months`	number	No	-
`name`	string	No	-
`percent_off`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Coupon

Route: DELETE /mutation/coupons

Entrees configurables

Name	Type	Required	Description
`amount_off`	number	No	-
`currency`	string	No	-
`duration`	enum	Yes	Values: forever, once, repeating
`duration_in_months`	number	No	-
`name`	string	No	-
`percent_off`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Customers

Customers in your Stripe account.

Utilise comme filtre par

Charges · customer

Checkout Sessions · customer

Invoice Items · customer

Invoices · customer

Payment Intents · customer

Subscriptions · customer

Lecture

Customers

Customers in your Stripe account.

Route: GET /customers

Formule Excel: =LF.stripe.customers("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`email`	string	No	Filter by exact email
`limit`	number	No	Rows per page (max 100) Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`balance`	number	—	-
`created` default	date	—	-
`currency`	string	—	-
`delinquent`	boolean	—	-
`description`	string	—	-
`email` default	string	—	-
`id` default	id	—	-
`name` default	string	—	-
`phone`	string	—	-

Creation

Create Customer

Route: POST /mutation/customers

Entrees configurables

Name	Type	Required	Description
`description`	string	No	-
`email`	string	No	-
`name`	string	No	-
`phone`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Customer

Route: PATCH /mutation/customers

Entrees configurables

Name	Type	Required	Description
`description`	string	No	-
`email`	string	No	-
`name`	string	No	-
`phone`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Customer

Route: DELETE /mutation/customers

Entrees configurables

Name	Type	Required	Description
`description`	string	No	-
`email`	string	No	-
`name`	string	No	-
`phone`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Invoice Items

Pending line items added to a customer’s next invoice.

Lecture

Invoice Items

Pending line items added to a customer’s next invoice.

Route: GET /invoiceItems

Formule Excel: =LF.stripe.invoiceItems("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`customer`	id	No	Filter by customer
`limit`	number	No	Rows per page (max 100) Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`amount` default	number	—	-
`created` default	date	—	-
`currency` default	string	—	-
`customer` default	id	→ customers	-
`description` default	string	—	-
`id` default	id	—	-

Creation

Create Invoice Item

Route: POST /mutation/invoiceItems

Entrees configurables

Name	Type	Required	Description
`amount`	number	No	-
`currency`	string	Yes	-
`customer`	id	Yes	-
`description`	string	No	-
`quantity`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Invoice Item

Route: PATCH /mutation/invoiceItems

Entrees configurables

Name	Type	Required	Description
`amount`	number	No	-
`currency`	string	Yes	-
`customer`	id	Yes	-
`description`	string	No	-
`quantity`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Invoice Item

Route: DELETE /mutation/invoiceItems

Entrees configurables

Name	Type	Required	Description
`amount`	number	No	-
`currency`	string	Yes	-
`customer`	id	Yes	-
`description`	string	No	-
`quantity`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Invoices

Invoices issued to customers.

Lecture

Invoices

Invoices issued to customers.

Route: GET /invoices

Formule Excel: =LF.stripe.invoices("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`customer`	id	No	Filter by customer
`status`	enum	No	Filter by status Values: draft, open, paid, uncollectible, void
`limit`	number	No	Rows per page (max 100) Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`amount_due` default	number	—	-
`created` default	date	—	-
`customer` default	id	→ customers	-
`id` default	id	—	-
`number` default	string	—	-
`status` default	string	—	-
`total` default	number	—	-

Creation

Create Invoice

Route: POST /mutation/invoices

Entrees configurables

Name	Type	Required	Description
`auto_advance`	boolean	No	-
`currency`	string	No	-
`customer`	id	Yes	-
`description`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Invoice

Route: PATCH /mutation/invoices

Entrees configurables

Name	Type	Required	Description
`auto_advance`	boolean	No	-
`currency`	string	No	-
`customer`	id	Yes	-
`description`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Draft Invoice

Route: DELETE /mutation/invoices

Entrees configurables

Name	Type	Required	Description
`auto_advance`	boolean	No	-
`currency`	string	No	-
`customer`	id	Yes	-
`description`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Promotion Codes

Customer-facing codes that apply a coupon.

Lecture

Promotion Codes

Customer-facing codes that apply a coupon.

Route: GET /promotionCodes

Formule Excel: =LF.stripe.promotionCodes("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`code`	string	No	Filter by code
`active`	boolean	No	Filter by active state
`limit`	number	No	Rows per page (max 100) Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`active` default	boolean	—	-
`code` default	string	—	-
`coupon` default	id	—	-
`created` default	date	—	-
`id` default	id	—	-
`times_redeemed` default	number	—	-

Creation

Create Promotion Code

Route: POST /mutation/promotionCodes

Entrees configurables

Name	Type	Required	Description
`code`	string	No	-
`coupon`	id	Yes	-
`max_redemptions`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Promotion Code

Route: PATCH /mutation/promotionCodes

Entrees configurables

Name	Type	Required	Description
`code`	string	No	-
`coupon`	id	Yes	-
`max_redemptions`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Subscriptions

Recurring subscriptions.

Lecture

Subscriptions

Recurring subscriptions.

Route: GET /subscriptions

Formule Excel: =LF.stripe.subscriptions("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`customer`	id	No	Filter by customer
`status`	enum	No	Filter by status Values: active, past_due, unpaid, canceled, incomplete
`price`	id	No	Filter by price
`limit`	number	No	Rows per page (max 100) Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`cancel_at_period_end` default	boolean	—	-
`created` default	date	—	-
`current_period_end` default	date	—	-
`current_period_start` default	date	—	-
`customer` default	id	→ customers	-
`id` default	id	—	-
`status` default	string	—	-

Creation

Create Subscription

Route: POST /mutation/subscriptions

Entrees configurables

Name	Type	Required	Description
`customer`	id	Yes	-
`items.0.price`	id	Yes	-
`items.0.quantity`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Subscription

Route: PATCH /mutation/subscriptions

Entrees configurables

Name	Type	Required	Description
`customer`	id	Yes	-
`items.0.price`	id	Yes	-
`items.0.quantity`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Cancel Subscription

Route: DELETE /mutation/subscriptions

Entrees configurables

Name	Type	Required	Description
`customer`	id	Yes	-
`items.0.price`	id	Yes	-
`items.0.quantity`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Tax Rates

Tax rates applied to invoices and subscriptions.

Lecture

Tax Rates

Tax rates applied to invoices and subscriptions.

Route: GET /taxRates

Formule Excel: =LF.stripe.taxRates("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`active`	boolean	No	Filter by active state
`limit`	number	No	Rows per page (max 100) Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`active` default	boolean	—	-
`created` default	date	—	-
`display_name` default	string	—	-
`id` default	id	—	-
`inclusive` default	boolean	—	-
`percentage` default	number	—	-

Creation

Create Tax Rate

Route: POST /mutation/taxRates

Entrees configurables

Name	Type	Required	Description
`country`	string	No	-
`display_name`	string	Yes	-
`inclusive`	boolean	Yes	-
`jurisdiction`	string	No	-
`percentage`	number	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Tax Rate

Route: PATCH /mutation/taxRates

Entrees configurables

Name	Type	Required	Description
`country`	string	No	-
`display_name`	string	Yes	-
`inclusive`	boolean	Yes	-
`jurisdiction`	string	No	-
`percentage`	number	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Catalog

Prices

Prices attached to products.

Lecture

Prices

Prices attached to products.

Route: GET /prices

Formule Excel: =LF.stripe.prices("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`product`	id	No	Filter by product
`active`	boolean	No	Filter by active state
`type`	enum	No	Filter by price type Values: one_time, recurring
`limit`	number	No	Rows per page (max 100) Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`active` default	boolean	—	-
`created` default	date	—	-
`currency` default	string	—	-
`id` default	id	—	-
`nickname` default	string	—	-
`product` default	id	→ products	-
`type` default	string	—	-
`unit_amount` default	number	—	-

Creation

Create Price

Route: POST /mutation/prices

Entrees configurables

Name	Type	Required	Description
`currency`	string	Yes	-
`nickname`	string	No	-
`product`	id	Yes	-
`recurring.interval`	enum	No	Values: day, week, month, year
`unit_amount`	number	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Price

Route: PATCH /mutation/prices

Entrees configurables

Name	Type	Required	Description
`currency`	string	Yes	-
`nickname`	string	No	-
`product`	id	Yes	-
`recurring.interval`	enum	No	Values: day, week, month, year
`unit_amount`	number	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Products

Products in your Stripe catalog.

Utilise comme filtre par

Prices · product

Lecture

Products

Products in your Stripe catalog.

Route: GET /products

Formule Excel: =LF.stripe.products("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`active`	boolean	No	Filter by active state
`limit`	number	No	Rows per page (max 100) Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`active` default	boolean	—	-
`created` default	date	—	-
`default_price` default	id	—	-
`description`	string	—	-
`id` default	id	—	-
`name` default	string	—	-

Creation

Create Product

Route: POST /mutation/products

Entrees configurables

Name	Type	Required	Description
`active`	boolean	No	-
`description`	string	No	-
`name`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Product

Route: PATCH /mutation/products

Entrees configurables

Name	Type	Required	Description
`active`	boolean	No	-
`description`	string	No	-
`name`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Product

Route: DELETE /mutation/products

Entrees configurables

Name	Type	Required	Description
`active`	boolean	No	-
`description`	string	No	-
`name`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Developers

Events

Account activity events.

Lecture

Events

Account activity events.

Route: GET /events

Formule Excel: =LF.stripe.events("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`type`	string	No	Filter by event type (e.g. invoice.paid)
`limit`	number	No	Rows per page (max 100) Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`api_version`	string	—	-
`created` default	date	—	-
`id` default	id	—	-
`type` default	string	—	-

Payments

Charges

Individual charges.

Lecture

Charges

Individual charges.

Route: GET /charges

Formule Excel: =LF.stripe.charges("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`customer`	id	No	Filter by customer
`limit`	number	No	Rows per page (max 100) Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`amount` default	number	—	-
`created` default	date	—	-
`currency` default	string	—	-
`customer` default	id	→ customers	-
`id` default	id	—	-
`paid` default	boolean	—	-
`status` default	string	—	-

Modification

Update Charge

Route: PATCH /mutation/charges

Entrees configurables

Name	Type	Required	Description
`description`	string	No	-
`id`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Checkout Sessions

Stripe Checkout sessions.

Lecture

Checkout Sessions

Stripe Checkout sessions.

Route: GET /checkoutSessions

Formule Excel: =LF.stripe.checkoutSessions("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`customer`	id	No	Filter by customer
`limit`	number	No	Rows per page (max 100) Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`amount_total` default	number	—	-
`created` default	date	—	-
`currency` default	string	—	-
`customer` default	id	→ customers	-
`id` default	id	—	-
`payment_status` default	string	—	-
`status` default	string	—	-

Creation

Create Checkout Session

Route: POST /mutation/checkoutSessions

Entrees configurables

Name	Type	Required	Description
`cancel_url`	string	No	-
`customer`	id	No	-
`line_items.0.price`	id	No	-
`line_items.0.quantity`	number	No	-
`mode`	enum	Yes	Values: payment, subscription, setup
`success_url`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Disputes

Disputes (chargebacks) raised by cardholders.

Lecture

Disputes

Disputes (chargebacks) raised by cardholders.

Route: GET /disputes

Formule Excel: =LF.stripe.disputes("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`limit`	number	No	Rows per page (max 100) Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`amount` default	number	—	-
`charge` default	id	—	-
`created` default	date	—	-
`currency` default	string	—	-
`id` default	id	—	-
`reason` default	string	—	-
`status` default	string	—	-

Modification

Update Dispute

Route: PATCH /mutation/disputes

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-
`metadata.note`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Payment Intents

Payment intents tracking the lifecycle of a payment.

Lecture

Payment Intents

Payment intents tracking the lifecycle of a payment.

Route: GET /paymentIntents

Formule Excel: =LF.stripe.paymentIntents("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`customer`	id	No	Filter by customer
`limit`	number	No	Rows per page (max 100) Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`amount` default	number	—	-
`created` default	date	—	-
`currency` default	string	—	-
`customer` default	id	→ customers	-
`id` default	id	—	-
`status` default	string	—	-

Creation

Create Payment Intent

Route: POST /mutation/paymentIntents

Entrees configurables

Name	Type	Required	Description
`amount`	number	Yes	-
`currency`	string	Yes	-
`customer`	id	No	-
`description`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Payment Intent

Route: PATCH /mutation/paymentIntents

Entrees configurables

Name	Type	Required	Description
`amount`	number	Yes	-
`currency`	string	Yes	-
`customer`	id	No	-
`description`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Payouts

Payouts to your bank account.

Lecture

Payouts

Payouts to your bank account.

Route: GET /payouts

Formule Excel: =LF.stripe.payouts("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`status`	enum	No	Filter by status Values: pending, paid, failed, canceled, in_transit
`limit`	number	No	Rows per page (max 100) Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`amount` default	number	—	-
`arrival_date` default	date	—	-
`created` default	date	—	-
`currency` default	string	—	-
`id` default	id	—	-
`status` default	string	—	-

Creation

Create Payout

Route: POST /mutation/payouts

Entrees configurables

Name	Type	Required	Description
`amount`	number	Yes	-
`currency`	string	Yes	-
`description`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Payout

Route: PATCH /mutation/payouts

Entrees configurables

Name	Type	Required	Description
`amount`	number	Yes	-
`currency`	string	Yes	-
`description`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Refunds

Refunds issued against charges or payment intents.

Lecture

Refunds

Refunds issued against charges or payment intents.

Route: GET /refunds

Formule Excel: =LF.stripe.refunds("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`limit`	number	No	Rows per page (max 100) Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`amount` default	number	—	-
`charge` default	id	—	-
`created` default	date	—	-
`currency` default	string	—	-
`id` default	id	—	-
`status` default	string	—	-

Creation

Create Refund

Route: POST /mutation/refunds

Entrees configurables

Name	Type	Required	Description
`amount`	number	No	-
`charge`	id	No	-
`payment_intent`	id	No	-
`reason`	enum	No	Values: duplicate, fraudulent, requested_by_customer

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Refund

Route: PATCH /mutation/refunds

Entrees configurables

Name	Type	Required	Description
`amount`	number	No	-
`charge`	id	No	-
`payment_intent`	id	No	-
`reason`	enum	No	Values: duplicate, fraudulent, requested_by_customer

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Reports

Balance Transactions

Funds movements through your Stripe balance.

Lecture

Balance Transactions

Funds movements through your Stripe balance.

Route: GET /balanceTransactions

Formule Excel: =LF.stripe.balanceTransactions("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`type`	string	No	Filter by type (e.g. charge, refund, payout)
`limit`	number	No	Rows per page (max 100) Default: 100

Donnees retournees dans Excel

Field	Type	Relations	Description
`amount` default	number	—	-
`created` default	date	—	-
`currency` default	string	—	-
`fee` default	number	—	-
`id` default	id	—	-
`net` default	number	—	-
`status` default	string	—	-
`type` default	string	—	-