Stripe walkthrough

info

Stripe API version 2019/12 is currently supported.

Integrating Stripe with Data Integration enables businesses to centralize and automate their payment data. This integration enhances reporting, provides comprehensive insights, and supports data-driven financial decisions.

Connection

To connect Stripe with your destination, refer to Stripe connection. Use this connection for generating reports.

Predefined reports

Data Integration provides a convenient entry point and recommended approach for accessing a range of predefined reports. Each report includes a concise data description, a list of customizable fields (if applicable), and the schema mapping.

Since these reports follow a standardized format, specific fields are locked and can only be accessed through Custom Reports.

Custom reports

Select a specific report to pull data from the Stripe API.

Stripe reports in Data Integration

Procedure

1. Select a report in the Report field:

• Customers
• Invoices
• Subscriptions
• Subscriptions Items
• Disputes
• Coupons
• Payout
• Refunds
• Charges
• Tax Rates
• Invoice Items
• Balance Transaction
• Cards
• Events
• Transfers
• Top Ups
• Balance
• Transactions
• Cardholders
• Issuing Cards List
• Payment Intents
• Connected Accounts
• Invoice Line Items
• Prices
• Products

2. Select filters to filter the report results. Leaving the filters empty returns all the available data for the selected report.
3. Select an extract method:

• All: Select All to pull all available data. Do not use this option if the report has a large amount of data.
• Incremental: Select the Incremental option to pull data for a specific date period.
• For reports that have more than one column of a timestamp type, an Incremental field input will be opened and enabled. In such a case, set a different column as the created column.
  

Reports time period

Select the time period of the report. All the reports support two kinds of time period:

1. Date Range

• Pulls data in the date range between the start and end date provided, including the end date.
• You must select a start date.
• Leaving the end date empty pulls data according to the current time of the river's run.
• Select a timezone offset to send dates considering the offset.
• Use the Last Days Back For Each Run to expand the start date and pull data a given number of days back before the chosen start date.
• The start date does not advance if a River run is unsuccessful.

note

To override this default behavior, click More Options and select the checkbox to advance the start date even if the River run is unsuccessful (Not recommended).

2. Predefined date: A date range defined by Data Integration:

   • Day - Yesterday.
   • Week (From Monday to Sunday) - Week to date, Previous week, Previous week to date.
   • Month - Month to date, Previous month, Previous month to date.
   • Year - Year to date.

Interval Chunks

Data Integration can run over the increment using chunks to make the loading efficient and precise. Your options are:

• Don't Split: Data Integration pulls the data from the chosen start date to the end date in one bulk.
• Daily: The run is chunked daily from the start to the end date.
• Monthly: The run is chunked monthly from the start to the end date.
• Yearly (Less Recommended): The run is chunked yearly from the start to the end date.

Interval size

Set the size of each interval. For example, setting the Interval Size to 4 with Interval Chunk set to Daily will split the date period into 4-day chunks. The period from January 1, 2025, to January 8, 2025, will be split into two intervals: from January 1, 2025, to January 4, 2025, and from January 5, 2025, to January 8, 2025.