Stripe

Stripe is a cloud platform that allows private individuals and companies to accept payments over the Internet.

Data integration: Skyvia supports importing data to and from Stripe, exporting Stripe data to CSV files, replicating Stripe data to relational databases, and synchronizing Stripe data with other cloud apps and relational databases.

Backup: Skyvia Backup supports Stripe backup.

Query: Skyvia Query supports Stripe.

Establishing Connection

To create a connection with Stripe, specify the API Key or Secret Key.

Connection Editor window

Getting Credentials

API Key

You can use different types of API keys for Stripe connection.

Publishable Key — an automatically generated REST API key for connecting to Stripe.
Secret Key - API Key used for full access to Stripe objects.
Restricted Key - API Key used for custom access configuration.

More details on Stripe API keys are available here.

To get the API key, perform the following steps:

  1. Go to Stripe.

  2. Click Developers and move to API Keys tab.

    Stripe API Keys

  3. Generate an API key of the needed type or copy the existing one.

Creating Connection

Enter the obtained API Key to the corresponding box to connect to Stripe.

Additional Connection Parameters

Connected Account Id

Enter this parameter if you want to retrieve data from the connected account. The connected account ID value should look like acct_XXXXXXXXXXXXXXXX. When the connected account ID is specified, all the queries and data-related operations in Skyvia are executed against the connected account instead of the main account.

Connector Specifics

Object Peculiarities

Accounts

There are three types of Stripe accounts: standard, custom, and express. Stripe API supports INSERT operation for standard and custom accounts and the UPDATE operation for custom accounts.

Plans

Stripe does not autogenerate the Id field. You must map it to a constant or a unique field to insert data into this object.

Charges

To import data to this object, you must map the CustomerId field. It has to be a customer that has at least one card.

Transfers

To import data to this object, you must specify an ID from the Account object as the DestinationId value. Make sure your Stripe account balance covers the transfer amount.

Incremental Replication and Synchronization

Skyvia fully supports the Incremental Replication for the Products, Orders, and ReportTypes objects. Incremental Replication detects only new records for the Accounts, AllSubscriptionItems, AllSubscriptions, ApplicationFeeRefunds, ApplicationFees, BalanceTransactions, Charges, Coupons, CreditNotes, CustomerBalanceTransactions, Customers, CustomerTaxIds, Disputes, EarlyFraudWarnings, Events, FileLinks, Files, InvoiceItems, Invoices, PaymentIntents, PaymentMethods, Payouts, Persons, Plans, Prices, Quotes, Refunds, Reports, Returns, Reviews, SetupIntents, SKUs, SubscriptionItems, Subscriptions, SubscriptionSchedules, TaxRates, Top-ups, TransferReversals, Transfers, ValueListItems, ValueLists, and WebhookEndpoints objects.

Skyvia fully supports Synchronization for the Products object. Synchronization tracks only new records for the Accounts, AllSubscriptionItems, AllSubscriptions, Charges, CreditNotes, CustomerBalanceTransactions, Customers, FileLinks, Invoices, InvoiceItems, PaymentIntents, Persons, Plans, Prices, Quotes, SetupIntents, SKUs, SubscriptionItems, Subscriptions, SubscriptionSchedules, TaxRates, Top-ups, Transfers, and ValueLists objects.

DML Operations Support

Skyvia supports the following DML operations for Stripe objects.

Operation Object
INSERT, UPDATE, DELETE Accounts, AllSubscriptionItems, BankAccounts, Cards, Customers, ExternalAccounts_BankAccounts, ExternalAccounts_Cards, InvoiceItems, Locations, Persons, Plans, Products, Readers, Skus, SubscriptionItems, ValuesLists
INSERT, UPDATE AllSubscriptions, Charges, CreditNotes, CustomerBalanceTransactions, FileLinks, Invoices, PaymentIntents, Prices, Quotes, Subscriptions, TaxRates, Top-ups, Transfers, SubscriptionSchedules
INSERT, DELETE Coupons, CustomerTaxIds, ValueListItems
INSERT ApplicationFeeRefunds, PaymentMethods, Payouts, Refunds, Reports, SetupIntents, TransferReversals, UsageRecords
UPDATE Disputes

Supported Actions and Actions Specifics

Skyvia supports all the common actions for Stripe.

On This Page