Stripe connection for LinkyFlow

LinkyFlow brings Stripe ecommerce data into Excel so teams can browse, edit, validate, and publish from the spreadsheet.

Resources

Read requests

Write actions

Documented fields

267

Workflows you can move into Excel

Each resource below maps to a practical spreadsheet workflow. Read actions bring useful columns into Excel; create and edit actions show what can be reviewed in rows before sending changes.

Billing

Accept Quote

Accepts on the customer’s behalf. Creates whatever the quote describes — an invoice, a subscription, or both.

Create

Accept Quote

Route: POST /mutation/quoteAccept

Inputs you can set

Name	Type	Required	Description
`quote_id`	id	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Cancel Quote

Withdraws the quote. It can no longer be accepted.

Create

Cancel Quote

Route: POST /mutation/quoteCancel

Inputs you can set

Name	Type	Required	Description
`quote_id`	id	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Cancel Subscription Schedule

Cancels the schedule and the subscription it drives.

Create

Cancel Subscription Schedule

Route: POST /mutation/subscriptionScheduleCancel

Inputs you can set

Name	Type	Required	Description
`invoice_now`	boolean	No	-
`prorate`	boolean	No	-
`schedule_id`	id	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Coupons

Discount coupons.

Read

Coupons

Discount coupons.

Route: GET /coupons

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in 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	—	-

Create

Create Coupon

Route: POST /mutation/coupons

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Coupon

Route: PATCH /mutation/coupons

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Coupon

Route: DELETE /mutation/coupons

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Credit Note Preview

What a credit note would do to an invoice, without creating one.

Read

Credit Note Preview

What a credit note would do to an invoice, without creating one.

Route: GET /creditNotesPreview

Excel formula: =LF.stripe.creditNotesPreview("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`invoice`	id	Yes	-
`amount`	number	No	Amount in the smallest currency unit (e.g. cents).
`reason`	enum	No	Values: duplicate, fraudulent, order_change, product_unsatisfactory
`refund_amount`	number	No	Amount in the smallest currency unit (e.g. cents).
`credit_amount`	number	No	Amount in the smallest currency unit (e.g. cents).
`out_of_band_amount`	number	No	Amount in the smallest currency unit (e.g. cents).
`lines`	string	No	-

Data returned in Excel

Field	Type	Relations	Description
`amount`	number	—	-
`currency` default	string	—	-
`invoice` default	id	—	-
`subtotal`	number	—	-
`total` default	number	—	-

Credit Notes

Credit notes adjusting finalised invoices — a refund, a customer credit, or neither.

Read

Credit Notes

Credit notes adjusting finalised invoices — a refund, a customer credit, or neither.

Route: GET /creditNotes

Excel formula: =LF.stripe.creditNotes("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`invoice`	id	No	Only credit notes against this invoice
`customer`	id	No	Filter by customer
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`created` default	date	—	-
`currency` default	string	—	-
`id` default	id	—	-
`invoice` default	id	—	-
`number` default	string	—	-
`status` default	enum	—	-
`total` default	number	—	-

Create

Create Credit Note

Route: POST /mutation/creditNotes

Inputs you can set

Name	Type	Required	Description
`amount`	number	No	-
`credit_amount`	number	No	-
`invoice`	id	Yes	-
`lines`	string	No	-
`memo`	string	No	-
`out_of_band_amount`	number	No	-
`reason`	enum	No	Values: duplicate, fraudulent, order_change, product_unsatisfactory
`refund_amount`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Customer Portal Session

A short-lived link letting one customer manage their own subscriptions, payment methods and invoices.

Create

Create Portal Session

Route: POST /mutation/billingPortalSessions

Inputs you can set

Name	Type	Required	Description
`configuration`	id	No	-
`customer`	id	Yes	-
`locale`	string	No	-
`on_behalf_of`	id	No	-
`return_url`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Customers

Customers in your Stripe account.

Used as filter by

Charges · customer

Checkout Sessions · customer

Credit Notes · customer

Invoice Items · customer

Invoices · customer

Upcoming Invoice · customer

Meter Event Summaries · customer

Payment Intents · customer

Quotes · customer

Subscription Schedules · customer

Subscriptions · customer

Read

Customers

Customers in your Stripe account.

Route: GET /customers

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`email`	string	No	Filter by exact email
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in 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	—	-

Create

Create Customer

Route: POST /mutation/customers

Inputs you can set

Name	Type	Required	Description
`currency`	string	No	-
`description`	string	No	-
`email`	string	No	-
`metadata.linkyflow_external_reference`	string	No	-
`name`	string	No	-
`phone`	string	No	-
`preferred_locales`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Customer

Route: PATCH /mutation/customers

Inputs you can set

Name	Type	Required	Description
`currency`	string	No	-
`description`	string	No	-
`email`	string	No	-
`metadata.linkyflow_external_reference`	string	No	-
`name`	string	No	-
`phone`	string	No	-
`preferred_locales`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Customer

Route: DELETE /mutation/customers

Inputs you can set

Name	Type	Required	Description
`currency`	string	No	-
`description`	string	No	-
`email`	string	No	-
`metadata.linkyflow_external_reference`	string	No	-
`name`	string	No	-
`phone`	string	No	-
`preferred_locales`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Finalize Invoice

Turns a draft into an issued invoice. Numbers it, freezes most of it, and may email the customer.

Create

Finalize Invoice

Route: POST /mutation/invoiceFinalize

Inputs you can set

Name	Type	Required	Description
`auto_advance`	boolean	No	-
`invoice_id`	id	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Finalize Quote

Issues the quote so the customer can accept it.

Create

Finalize Quote

Route: POST /mutation/quoteFinalize

Inputs you can set

Name	Type	Required	Description
`expires_at`	number	No	-
`quote_id`	id	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Invoice Items

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

Read

Invoice Items

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

Route: GET /invoiceItems

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`customer`	id	No	Filter by customer
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

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

Create

Create Invoice Item

Route: POST /mutation/invoiceItems

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Invoice Item

Route: PATCH /mutation/invoiceItems

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Invoice Item

Route: DELETE /mutation/invoiceItems

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Invoices

Invoices issued to customers.

Read

Invoices

Invoices issued to customers.

Route: GET /invoices

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`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

Data returned in Excel

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

Create

Create Invoice

Route: POST /mutation/invoices

Inputs you can set

Name	Type	Required	Description
`auto_advance`	boolean	No	-
`automatic_tax.enabled`	boolean	No	-
`collection_method`	enum	No	Values: charge_automatically, send_invoice
`currency`	string	No	-
`customer`	id	Yes	-
`days_until_due`	number	No	-
`description`	string	No	-
`metadata.linkyflow_external_reference`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Invoice

Route: PATCH /mutation/invoices

Inputs you can set

Name	Type	Required	Description
`auto_advance`	boolean	No	-
`automatic_tax.enabled`	boolean	No	-
`collection_method`	enum	No	Values: charge_automatically, send_invoice
`currency`	string	No	-
`customer`	id	Yes	-
`days_until_due`	number	No	-
`description`	string	No	-
`metadata.linkyflow_external_reference`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Draft Invoice

Route: DELETE /mutation/invoices

Inputs you can set

Name	Type	Required	Description
`auto_advance`	boolean	No	-
`automatic_tax.enabled`	boolean	No	-
`collection_method`	enum	No	Values: charge_automatically, send_invoice
`currency`	string	No	-
`customer`	id	Yes	-
`days_until_due`	number	No	-
`description`	string	No	-
`metadata.linkyflow_external_reference`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Mark Invoice Uncollectible

Writes the invoice off as bad debt. An accounting statement, not a cancellation.

Create

Mark Invoice Uncollectible

Route: POST /mutation/invoiceMarkUncollectible

Inputs you can set

Name	Type	Required	Description
`invoice_id`	id	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Meter Event Adjustments

Cancels a usage event already reported, by its identifier.

Create

Cancel Usage Event

Route: POST /mutation/meterEventAdjustments

Inputs you can set

Name	Type	Required	Description
`cancel.identifier`	string	Yes	-
`event_name`	string	Yes	-
`type`	enum	Yes	Values: cancel

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Meter Event Summaries

Usage a meter has aggregated for one customer over a window.

Read

Meter Event Summaries

Usage a meter has aggregated for one customer over a window.

Route: GET /meterEventSummaries

Excel formula: =LF.stripe.meterEventSummaries("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`meter_id`	id	Yes	-
`customer`	id	Yes	-
`start_time`	number	Yes	Epoch seconds
`end_time`	number	Yes	Epoch seconds
`value_grouping_window`	enum	No	Values: day, hour
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`aggregated_value` default	number	—	-
`end_time` default	date	—	-
`id` default	id	—	-
`meter` default	id	—	-
`start_time` default	date	—	-

Meter Events

Reports one unit of usage. Stripe aggregates asynchronously, so it will not appear immediately.

Create

Record Usage

Route: POST /mutation/meterEvents

Inputs you can set

Name	Type	Required	Description
`event_name`	string	Yes	-
`identifier`	string	No	-
`payload.stripe_customer_id`	id	Yes	-
`payload.value`	string	Yes	-
`timestamp`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Meters

Meters aggregating usage events, for prices billed on what a customer actually used.

Read

Meters

Meters aggregating usage events, for prices billed on what a customer actually used.

Route: GET /meters

Excel formula: =LF.stripe.meters("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`status`	enum	No	Values: active, inactive
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`created` default	date	—	-
`default_aggregation` default	string	—	-
`display_name` default	string	—	-
`event_name` default	string	—	-
`id` default	id	—	-
`status` default	enum	—	-

Create

Create Meter

Route: POST /mutation/meters

Inputs you can set

Name	Type	Required	Description
`customer_mapping.event_payload_key`	string	No	-
`customer_mapping.type`	enum	No	Values: by_id
`default_aggregation.formula`	enum	No	Values: sum, count
`display_name`	string	Yes	-
`event_name`	string	Yes	-
`value_settings.event_payload_key`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Meter

Route: PATCH /mutation/meters

Inputs you can set

Name	Type	Required	Description
`customer_mapping.event_payload_key`	string	No	-
`customer_mapping.type`	enum	No	Values: by_id
`default_aggregation.formula`	enum	No	Values: sum, count
`display_name`	string	Yes	-
`event_name`	string	Yes	-
`value_settings.event_payload_key`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Pause Subscription

Stops collecting on a subscription without cancelling it.

Edit

Pause Subscription

Route: PATCH /mutation/subscriptionPause

Inputs you can set

Name	Type	Required	Description
`id`	id	Yes	-
`pause_collection.behavior`	enum	No	Values: keep_as_draft, mark_uncollectible, void
`pause_collection.resumes_at`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Pay Invoice

Attempts payment with the customer’s saved method, or records one taken outside Stripe.

Create

Pay Invoice

Route: POST /mutation/invoicePay

Inputs you can set

Name	Type	Required	Description
`forgive`	boolean	No	-
`invoice_id`	id	Yes	-
`paid_out_of_band`	boolean	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Promotion Codes

Customer-facing codes that apply a coupon.

Read

Promotion Codes

Customer-facing codes that apply a coupon.

Route: GET /promotionCodes

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`code`	string	No	Filter by code
`active`	boolean	No	Filter by active state
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

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

Create

Create Promotion Code

Route: POST /mutation/promotionCodes

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Promotion Code

Route: PATCH /mutation/promotionCodes

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Quotes

Quotes a customer can accept, which then create an invoice or a subscription.

Read

Quotes

Quotes a customer can accept, which then create an invoice or a subscription.

Route: GET /quotes

Excel formula: =LF.stripe.quotes("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`customer`	id	No	Filter by customer
`status`	enum	No	Values: draft, open, accepted, canceled
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

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

Create

Create Quote

Route: POST /mutation/quotes

Inputs you can set

Name	Type	Required	Description
`collection_method`	enum	No	Values: charge_automatically, send_invoice
`customer`	id	No	-
`description`	string	No	-
`expires_at`	number	No	-
`footer`	string	No	-
`header`	string	No	-
`line_items`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Quote

Route: PATCH /mutation/quotes

Inputs you can set

Name	Type	Required	Description
`collection_method`	enum	No	Values: charge_automatically, send_invoice
`customer`	id	No	-
`description`	string	No	-
`expires_at`	number	No	-
`footer`	string	No	-
`header`	string	No	-
`line_items`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Release Subscription Schedule

Detaches the schedule. The subscription keeps running, unmanaged.

Create

Release Subscription Schedule

Route: POST /mutation/subscriptionScheduleRelease

Inputs you can set

Name	Type	Required	Description
`schedule_id`	id	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Resume Subscription

Restarts a paused subscription.

Create

Resume Subscription

Route: POST /mutation/subscriptionResume

Inputs you can set

Name	Type	Required	Description
`billing_cycle_anchor`	enum	No	Values: now, unchanged
`proration_behavior`	enum	No	Values: create_prorations, none, always_invoice
`subscription_id`	id	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Send Invoice

Emails the invoice to the customer. Stripe sends the mail.

Create

Send Invoice

Route: POST /mutation/invoiceSend

Inputs you can set

Name	Type	Required	Description
`invoice_id`	id	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Subscription Change Preview

What changing a subscription would cost — the proration, before it is applied.

Read

Subscription Change Preview

What changing a subscription would cost — the proration, before it is applied.

Route: GET /subscriptionsUpcoming

Excel formula: =LF.stripe.subscriptionsUpcoming("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`subscription`	id	Yes	-
`subscription_items`	string	No	-
`subscription_proration_behavior`	enum	No	Values: create_prorations, none, always_invoice

Data returned in Excel

Field	Type	Relations	Description
`amount_due` default	number	—	-
`currency` default	string	—	-
`lines` default	string	—	-
`period_end`	date	—	-
`period_start`	date	—	-
`subtotal`	number	—	-
`total` default	number	—	-

Subscription Schedules

Subscriptions planned in phases — a trial, then one price, then another.

Read

Subscription Schedules

Subscriptions planned in phases — a trial, then one price, then another.

Route: GET /subscriptionSchedules

Excel formula: =LF.stripe.subscriptionSchedules("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`customer`	id	No	Filter by customer
`scheduled`	boolean	No	Only schedules that have not started
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`created` default	date	—	-
`customer` default	id	→ customers	-
`id` default	id	—	-
`phases` default	string	—	-
`status` default	enum	—	-
`subscription` default	id	—	-

Create

Create Subscription Schedule

Route: POST /mutation/subscriptionSchedules

Inputs you can set

Name	Type	Required	Description
`customer`	id	No	-
`end_behavior`	enum	No	Values: release, cancel
`from_subscription`	id	No	-
`phases`	string	No	-
`start_date`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Subscription Schedule

Route: PATCH /mutation/subscriptionSchedules

Inputs you can set

Name	Type	Required	Description
`customer`	id	No	-
`end_behavior`	enum	No	Values: release, cancel
`from_subscription`	id	No	-
`phases`	string	No	-
`start_date`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Subscriptions

Recurring subscriptions.

Read

Subscriptions

Recurring subscriptions.

Route: GET /subscriptions

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`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

Data returned in 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	enum	—	-

Create

Create Subscription

Route: POST /mutation/subscriptions

Inputs you can set

Name	Type	Required	Description
`automatic_tax.enabled`	boolean	No	-
`cancel_at_period_end`	boolean	No	-
`collection_method`	enum	No	Values: charge_automatically, send_invoice
`coupon`	id	No	-
`customer`	id	Yes	-
`days_until_due`	number	No	-
`items.0.price`	id	Yes	-
`items.0.quantity`	number	No	-
`metadata.linkyflow_external_reference`	string	No	-
`promotion_code`	id	No	-
`trial_end`	number	No	-
`trial_period_days`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Subscription

Route: PATCH /mutation/subscriptions

Inputs you can set

Name	Type	Required	Description
`automatic_tax.enabled`	boolean	No	-
`cancel_at_period_end`	boolean	No	-
`collection_method`	enum	No	Values: charge_automatically, send_invoice
`coupon`	id	No	-
`customer`	id	Yes	-
`days_until_due`	number	No	-
`items.0.price`	id	Yes	-
`items.0.quantity`	number	No	-
`metadata.linkyflow_external_reference`	string	No	-
`promotion_code`	id	No	-
`trial_end`	number	No	-
`trial_period_days`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Cancel Subscription

Route: DELETE /mutation/subscriptions

Inputs you can set

Name	Type	Required	Description
`automatic_tax.enabled`	boolean	No	-
`cancel_at_period_end`	boolean	No	-
`collection_method`	enum	No	Values: charge_automatically, send_invoice
`coupon`	id	No	-
`customer`	id	Yes	-
`days_until_due`	number	No	-
`items.0.price`	id	Yes	-
`items.0.quantity`	number	No	-
`metadata.linkyflow_external_reference`	string	No	-
`promotion_code`	id	No	-
`trial_end`	number	No	-
`trial_period_days`	number	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Tax Calculation

Works out the tax due on a hypothetical sale. Nothing is recorded and nothing is owed.

Create

Calculate Tax

Route: POST /mutation/taxCalculations

Inputs you can set

Name	Type	Required	Description
`currency`	string	Yes	-
`customer`	id	No	-
`customer_details.address.country`	string	No	-
`customer_details.address.postal_code`	string	No	-
`customer_details.address.state`	string	No	-
`customer_details.address_source`	enum	No	Values: billing, shipping
`line_items`	string	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Tax Rates

Tax rates applied to invoices and subscriptions.

Read

Tax Rates

Tax rates applied to invoices and subscriptions.

Route: GET /taxRates

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`active`	boolean	No	Filter by active state
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

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

Create

Create Tax Rate

Route: POST /mutation/taxRates

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Tax Rate

Route: PATCH /mutation/taxRates

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Tax Transactions

Tax actually recorded against a completed sale — what a filing is built from.

Read

Tax Transactions

Tax actually recorded against a completed sale — what a filing is built from.

Route: GET /taxTransactions

Excel formula: =LF.stripe.taxTransactions("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`created` default	date	—	-
`currency` default	string	—	-
`customer`	id	→ customers	-
`id` default	id	—	-
`reference` default	string	—	-
`type` default	enum	—	-

Upcoming Invoice

What a customer or subscription would be billed next. Never persisted, and it changes as the period does.

Read

Upcoming Invoice

What a customer or subscription would be billed next. Never persisted, and it changes as the period does.

Route: GET /invoicesUpcoming

Excel formula: =LF.stripe.invoicesUpcoming("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`customer`	id	No	Filter by customer
`subscription`	id	No	Preview this subscription’s next invoice
`subscription_items`	string	No	Items to price as if they were already applied
`subscription_proration_behavior`	enum	No	Values: create_prorations, none, always_invoice
`subscription_proration_date`	number	No	Epoch seconds the proration is computed at

Data returned in Excel

Field	Type	Relations	Description
`amount_due` default	number	—	-
`currency` default	string	—	-
`customer` default	id	→ customers	-
`id` default	id	—	-
`subscription` default	id	—	-
`total` default	number	—	-

Void Credit Note

Cancels a credit note, putting the invoice balance back where it was.

Create

Void Credit Note

Route: POST /mutation/creditNoteVoid

Inputs you can set

Name	Type	Required	Description
`credit_note_id`	id	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Void Invoice

Cancels a finalised invoice. Irreversible, and the invoice number stays used.

Create

Void Invoice

Route: POST /mutation/invoiceVoid

Inputs you can set

Name	Type	Required	Description
`invoice_id`	id	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Catalog

Prices

Prices attached to products.

Read

Prices

Prices attached to products.

Route: GET /prices

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`product`	id	No	Filter by product
`active`	boolean	No	Filter by active state
`type`	enum	No	Filter by price type Values: one_time, recurring
`currency`	string	No	Filter by three-letter ISO currency code
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in 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	enum	—	-
`unit_amount` default	number	—	-

Create

Create Price

Route: POST /mutation/prices

Inputs you can set

Name	Type	Required	Description
`currency`	string	Yes	-
`nickname`	string	No	-
`product`	id	Yes	-
`recurring.interval`	enum	No	Values: day, week, month, year
`recurring.interval_count`	number	No	-
`recurring.meter`	id	No	-
`recurring.usage_type`	enum	No	Values: licensed, metered
`tax_behavior`	enum	No	Values: inclusive, exclusive, unspecified
`type`	enum	No	Values: one_time, recurring
`unit_amount`	number	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Price

Route: PATCH /mutation/prices

Inputs you can set

Name	Type	Required	Description
`currency`	string	Yes	-
`nickname`	string	No	-
`product`	id	Yes	-
`recurring.interval`	enum	No	Values: day, week, month, year
`recurring.interval_count`	number	No	-
`recurring.meter`	id	No	-
`recurring.usage_type`	enum	No	Values: licensed, metered
`tax_behavior`	enum	No	Values: inclusive, exclusive, unspecified
`type`	enum	No	Values: one_time, recurring
`unit_amount`	number	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Products

Products in your Stripe catalog.

Used as filter by

Prices · product

Read

Products

Products in your Stripe catalog.

Route: GET /products

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`active`	boolean	No	Filter by active state
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

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

Create

Create Product

Route: POST /mutation/products

Inputs you can set

Name	Type	Required	Description
`active`	boolean	No	-
`description`	string	No	-
`metadata.linkyflow_external_reference`	string	No	-
`name`	string	Yes	-
`statement_descriptor`	string	No	-
`tax_code`	string	No	-
`unit_label`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Product

Route: PATCH /mutation/products

Inputs you can set

Name	Type	Required	Description
`active`	boolean	No	-
`description`	string	No	-
`metadata.linkyflow_external_reference`	string	No	-
`name`	string	Yes	-
`statement_descriptor`	string	No	-
`tax_code`	string	No	-
`unit_label`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Product

Route: DELETE /mutation/products

Inputs you can set

Name	Type	Required	Description
`active`	boolean	No	-
`description`	string	No	-
`metadata.linkyflow_external_reference`	string	No	-
`name`	string	Yes	-
`statement_descriptor`	string	No	-
`tax_code`	string	No	-
`unit_label`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Shipping Rates

Delivery options and their cost, offered at checkout.

Read

Shipping Rates

Delivery options and their cost, offered at checkout.

Route: GET /shippingRates

Excel formula: =LF.stripe.shippingRates("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`active`	boolean	No	-
`currency`	string	No	-
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`active` default	boolean	—	-
`created` default	date	—	-
`display_name` default	string	—	-
`fixed_amount` default	string	—	-
`id` default	id	—	-
`type` default	enum	—	-

Create

Create Shipping Rate

Route: POST /mutation/shippingRates

Inputs you can set

Name	Type	Required	Description
`delivery_estimate.maximum.unit`	enum	No	Values: hour, day, business_day, week, month
`delivery_estimate.maximum.value`	number	No	-
`delivery_estimate.minimum.unit`	enum	No	Values: hour, day, business_day, week, month
`delivery_estimate.minimum.value`	number	No	-
`display_name`	string	Yes	-
`fixed_amount.amount`	number	Yes	-
`fixed_amount.currency`	string	Yes	-
`tax_behavior`	enum	No	Values: inclusive, exclusive, unspecified

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Shipping Rate

Route: PATCH /mutation/shippingRates

Inputs you can set

Name	Type	Required	Description
`delivery_estimate.maximum.unit`	enum	No	Values: hour, day, business_day, week, month
`delivery_estimate.maximum.value`	number	No	-
`delivery_estimate.minimum.unit`	enum	No	Values: hour, day, business_day, week, month
`delivery_estimate.minimum.value`	number	No	-
`display_name`	string	Yes	-
`fixed_amount.amount`	number	Yes	-
`fixed_amount.currency`	string	Yes	-
`tax_behavior`	enum	No	Values: inclusive, exclusive, unspecified

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Connect

Account Links

A short-lived onboarding link for a connected account.

Create

Create Onboarding Link

Route: POST /mutation/accountLinks

Inputs you can set

Name	Type	Required	Description
`account`	id	Yes	-
`refresh_url`	string	Yes	-
`return_url`	string	Yes	-
`type`	enum	Yes	Values: account_onboarding, account_update

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Application Fees

Fees the platform collected on connected-account charges.

Read

Application Fees

Fees the platform collected on connected-account charges.

Route: GET /applicationFees

Excel formula: =LF.stripe.applicationFees("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`account` default	id	—	-
`amount` default	number	—	-
`amount_refunded`	number	—	-
`created` default	date	—	-
`currency` default	string	—	-
`id` default	id	—	-
`refunded`	boolean	—	-

Connected Account Requirements

What a connected account still owes before it can charge or be paid out.

Read

Connected Account Requirements

What a connected account still owes before it can charge or be paid out.

Route: GET /accountRequirements

Excel formula: =LF.stripe.accountRequirements("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	Yes	-

Data returned in Excel

Field	Type	Relations	Description
`charges_enabled` default	boolean	—	-
`details_submitted`	boolean	—	-
`id` default	id	—	-
`payouts_enabled` default	boolean	—	-
`requirements` default	string	—	-

Connected Accounts

Accounts connected to this platform.

Read

Connected Accounts

Accounts connected to this platform.

Route: GET /accounts

Excel formula: =LF.stripe.accounts("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`charges_enabled` default	boolean	—	-
`country` default	string	—	-
`created` default	date	—	-
`id` default	id	—	-
`payouts_enabled` default	boolean	—	-
`type` default	enum	—	-

Create

Create Connected Account

Route: POST /mutation/accounts

Inputs you can set

Name	Type	Required	Description
`country`	string	No	-
`email`	string	No	-
`type`	enum	No	Values: standard, express, custom

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Connected Account

Route: PATCH /mutation/accounts

Inputs you can set

Name	Type	Required	Description
`country`	string	No	-
`email`	string	No	-
`type`	enum	No	Values: standard, express, custom

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Transfer Reversals

Pulls a transfer back from a connected account.

Create

Reverse Transfer

Route: POST /mutation/transferReversals

Inputs you can set

Name	Type	Required	Description
`amount`	number	No	-
`refund_application_fee`	boolean	No	-
`transfer_id`	id	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Transfers

Money moved from the platform balance to a connected account.

Read

Transfers

Money moved from the platform balance to a connected account.

Route: GET /transfers

Excel formula: =LF.stripe.transfers("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`destination`	id	No	Only transfers to this connected account
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`amount` default	number	—	-
`amount_reversed`	number	—	-
`created` default	date	—	-
`currency` default	string	—	-
`description`	string	—	-
`destination` default	id	—	-
`id` default	id	—	-
`reversed`	boolean	—	-

Create

Create Transfer

Route: POST /mutation/transfers

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Developers

Events

Account activity events.

Read

Events

Account activity events.

Route: GET /events

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`type`	string	No	Filter by event type (e.g. invoice.paid)
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

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

Payments

Cancel Payout

Cancels a payout still in transit. An automatic payout usually cannot be cancelled.

Create

Cancel Payout

Route: POST /mutation/payoutCancel

Inputs you can set

Name	Type	Required	Description
`payout_id`	id	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Cancel Refund

Cancels a refund that has not left yet. Only refunds in certain states can be.

Create

Cancel Refund

Route: POST /mutation/refundCancel

Inputs you can set

Name	Type	Required	Description
`refund_id`	id	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Charges

Individual charges.

Read

Charges

Individual charges.

Route: GET /charges

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`customer`	id	No	Filter by customer
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in 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	enum	—	-

Edit

Update Charge

Route: PATCH /mutation/charges

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Checkout Sessions

Stripe Checkout sessions.

Read

Checkout Sessions

Stripe Checkout sessions.

Route: GET /checkoutSessions

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`customer`	id	No	Filter by customer
`subscription`	id	No	Only sessions that created this subscription
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in 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	enum	—	-
`status` default	enum	—	-

Create

Create Checkout Session

Route: POST /mutation/checkoutSessions

Inputs you can set

Name	Type	Required	Description
`allow_promotion_codes`	boolean	No	-
`automatic_tax.enabled`	boolean	No	-
`billing_address_collection`	enum	No	Values: auto, required
`cancel_url`	string	No	-
`client_reference_id`	string	No	-
`customer`	id	No	-
`customer_email`	string	No	-
`expires_at`	number	No	-
`line_items.0.price`	id	No	-
`line_items.0.quantity`	number	No	-
`mode`	enum	Yes	Values: payment, subscription, setup
`success_url`	string	Yes	-
`tax_id_collection.enabled`	boolean	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Close Dispute

Concedes the dispute. Irreversible, and the money stays with the cardholder.

Create

Close Dispute

Route: POST /mutation/disputeClose

Inputs you can set

Name	Type	Required	Description
`dispute_id`	id	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Disputes

Disputes (chargebacks) raised by cardholders.

Read

Disputes

Disputes (chargebacks) raised by cardholders.

Route: GET /disputes

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`charge`	id	No	Only disputes against this charge
`status`	enum	No	Filter by dispute status Values: warning_needs_response, warning_under_review, warning_closed, needs_response, under_review
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in 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	enum	—	-

Edit

Update Dispute

Route: PATCH /mutation/disputes

Inputs you can set

Name	Type	Required	Description
`evidence.cancellation_policy`	id	No	-
`evidence.customer_communication`	id	No	-
`evidence.customer_email_address`	string	No	-
`evidence.customer_name`	string	No	-
`evidence.product_description`	string	No	-
`evidence.receipt`	id	No	-
`evidence.refund_policy`	id	No	-
`evidence.service_date`	string	No	-
`evidence.shipping_carrier`	string	No	-
`evidence.shipping_documentation`	id	No	-
`evidence.shipping_tracking_number`	string	No	-
`evidence.uncategorized_text`	string	No	-
`id`	id	Yes	-
`submit`	boolean	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Payment Intents

Payment intents tracking the lifecycle of a payment.

Read

Payment Intents

Payment intents tracking the lifecycle of a payment.

Route: GET /paymentIntents

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`customer`	id	No	Filter by customer
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

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

Create

Create Payment Intent

Route: POST /mutation/paymentIntents

Inputs you can set

Name	Type	Required	Description
`amount`	number	Yes	-
`automatic_payment_methods[allow_redirects]`	string	No	-
`automatic_payment_methods[enabled]`	boolean	No	-
`confirm`	boolean	No	-
`currency`	string	Yes	-
`customer`	id	No	-
`description`	string	No	-
`payment_method`	id	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Payment Intent

Route: PATCH /mutation/paymentIntents

Inputs you can set

Name	Type	Required	Description
`amount`	number	Yes	-
`automatic_payment_methods[allow_redirects]`	string	No	-
`automatic_payment_methods[enabled]`	boolean	No	-
`confirm`	boolean	No	-
`currency`	string	Yes	-
`customer`	id	No	-
`description`	string	No	-
`payment_method`	id	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Payment Links

Reusable shareable payment links. Unlike a checkout session, a link does not expire and can be paid many times.

Read

Payment Links

Reusable shareable payment links. Unlike a checkout session, a link does not expire and can be paid many times.

Route: GET /paymentLinks

Excel formula: =LF.stripe.paymentLinks("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`active`	boolean	No	Filter by whether the link still works
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

Field	Type	Relations	Description
`active` default	boolean	—	-
`allow_promotion_codes`	boolean	—	-
`currency` default	string	—	-
`id` default	id	—	-
`url` default	string	—	-

Create

Create Payment Link

Route: POST /mutation/paymentLinks

Inputs you can set

Name	Type	Required	Description
`after_completion.redirect.url`	string	No	-
`after_completion.type`	enum	No	Values: hosted_confirmation, redirect
`allow_promotion_codes`	boolean	No	-
`automatic_tax.enabled`	boolean	No	-
`billing_address_collection`	enum	No	Values: auto, required
`line_items.0.price`	id	No	-
`line_items.0.quantity`	number	No	-
`metadata.linkyflow_external_reference`	string	No	-
`tax_id_collection.enabled`	boolean	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Payment Link

Route: PATCH /mutation/paymentLinks

Inputs you can set

Name	Type	Required	Description
`after_completion.redirect.url`	string	No	-
`after_completion.type`	enum	No	Values: hosted_confirmation, redirect
`allow_promotion_codes`	boolean	No	-
`automatic_tax.enabled`	boolean	No	-
`billing_address_collection`	enum	No	Values: auto, required
`line_items.0.price`	id	No	-
`line_items.0.quantity`	number	No	-
`metadata.linkyflow_external_reference`	string	No	-
`tax_id_collection.enabled`	boolean	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Payouts

Payouts to your bank account.

Read

Payouts

Payouts to your bank account.

Route: GET /payouts

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`status`	enum	No	Filter by status Values: pending, paid, failed, canceled, in_transit
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

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

Create

Create Payout

Route: POST /mutation/payouts

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Payout

Route: PATCH /mutation/payouts

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Refunds

Refunds issued against charges or payment intents.

Read

Refunds

Refunds issued against charges or payment intents.

Route: GET /refunds

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`charge`	id	No	Only refunds against this charge
`payment_intent`	id	No	Only refunds against this payment intent
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in Excel

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

Create

Create Refund

Route: POST /mutation/refunds

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Refund

Route: PATCH /mutation/refunds

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Reverse Payout

Pulls a completed payout back into the Stripe balance.

Create

Reverse Payout

Route: POST /mutation/payoutReverse

Inputs you can set

Name	Type	Required	Description
`payout_id`	id	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Submit Dispute Evidence

Sends the drafted evidence to the bank. Final — evidence can be submitted once.

Edit

Submit Dispute Evidence

Route: PATCH /mutation/disputeSubmit

Inputs you can set

Name	Type	Required	Description
`id`	id	Yes	-
`submit`	boolean	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Reports

Balance

What is available now and what is still pending, per currency.

Read

Balance

What is available now and what is still pending, per currency.

Route: GET /balance

Excel formula: =LF.stripe.balance("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-

Data returned in Excel

Field	Type	Relations	Description
`available` default	string	—	-
`connect_reserved`	string	—	-
`livemode` default	boolean	—	-
`pending` default	string	—	-

Balance Transactions

Funds movements through your Stripe balance.

Read

Balance Transactions

Funds movements through your Stripe balance.

Route: GET /balanceTransactions

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or a not-found error.
`createdAfter`	string	No	Only records created at or after this moment — an ISO date, or epoch seconds.
`createdBefore`	string	No	Only records created at or before this moment — an ISO date, or epoch seconds.
`type`	string	No	Filter by type (e.g. charge, refund, payout)
`limit`	number	No	Rows per page (max 100) Default: 100

Data returned in 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	enum	—	-
`type` default	string	—	-

Payout Reconciliation

The charges, refunds and fees that make up one payout.

Read

Payout Reconciliation

The charges, refunds and fees that make up one payout.

Route: GET /payoutReconciliation

Excel formula: =LF.stripe.payoutReconciliation("selection", "fields")

Inputs you can set

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

Data returned in Excel

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