a

How to Connect Recharge to Knowi and Build a Subscription Analytics Dashboard

Share on facebook
Share on linkedin
Share on twitter
Share on email

Knowi has a native Recharge connector that authenticates via OAuth. Once connected, you can pull subscriptions, charges, customers, orders, and more from your Recharge account to build analytics dashboards. Recharge data can also be joined with Shopify, Stripe, and Klaviyo directly in Knowi.

Quick Summary (TL;DR)

  • Knowi connects to Recharge via OAuth through the Recharge admin. No API token to manage; access is revocable at any time.
  • A legacy API token method still works but is deprecated. OAuth is the recommended authentication method.
  • Available data types: Subscriptions, Customers, Orders, Charges, Products, Discounts, Addresses, One-Time Products, Store Info, and Custom Query.
  • Charge statuses tracked: success, error, queued, skipped, refunded, and partially_refunded.
  • Subscription fields include status, next_charge_scheduled_at, order_interval_frequency, and cancelled_at for tracking active and cancelled subscriptions.
  • Knowi handles cursor-based pagination automatically and retries on rate limit errors (40 burst calls, 2 calls per second sustained).
  • Recharge data can be joined natively with Shopify, Stripe, Klaviyo, MongoDB, PostgreSQL, and 30-plus additional sources.

Table of Contents

How to Connect Recharge to Knowi

The Recharge connector is available natively in Knowi and uses OAuth for authentication. You authorize the Knowi app directly from your Recharge admin.

  1. In Knowi, go to Queries and select New Data Source.
  2. Select the Recharge connector.
  3. Click Authorize and approve the Knowi app from your Recharge admin.
  4. OAuth handles the connection. No API token to copy or manage.
  5. Save and start querying.

Access can be revoked at any time through your Recharge admin, which immediately terminates the datasource connection. For full setup details, see the Recharge connector documentation.

What Data Can You Pull from Recharge?

CollectionKey FieldsUse Case
Subscriptionsid, customer_id, product_title, sku, price, quantity, status, order_interval_frequency, order_interval_unit, next_charge_scheduled_at, created_at, cancelled_atSubscription status tracking, upcoming renewals, cancellation analysis
Customersemail, status (ACTIVE/INACTIVE), subscription counts, lifetime totalsCustomer cohort tracking, active vs inactive customers
OrdersRecurring and one-time orders tied to subscriptionsRevenue tracking by order type
Chargesstatus (success/error/queued/skipped/refunded/partially_refunded), processed_at, transaction_idPayment success and failure tracking, dunning analysis
ProductsBilling frequency, discount settingsSubscription product catalog (Recharge-hosted products only)
Discountscode, usage counts, statusPromotion effectiveness tracking
AddressesShipping address linked to subscriptionsCustomer geography
One-Time ProductsAdd-on metadataUpsell tracking
Store InfoSingle store-level recordConstants for multi-store joins
Custom QueryAny Recharge 2021-11 API endpointAccess data types not covered by the pre-built collections

Technical Details

Rate Limits and Pagination

  • Recharge enforces rate limits of 40 burst calls and 2 calls per second sustained, per store.
  • Knowi handles cursor-based pagination automatically, fetching all pages without manual configuration.
  • When rate limits are hit, Knowi auto-retries using exponential backoff on 429 errors.

Date Tokens for Incremental Syncs

Use Knowi date tokens to filter Recharge data by date and run incremental syncs:

  • {$c9_today-30d:yyyy-MM-dd}T00:00:00Z: 30 days ago in ISO 8601 format
  • {$c9_lastrun:yyyy-MM-dd}T00:00:00Z: date of the last query run, for pulling only new records

Joining Recharge with Other Sources

Knowi supports cross-source joins natively. You can combine Recharge subscription data with Shopify orders, Stripe charges, Klaviyo campaigns, MongoDB, PostgreSQL, and 30-plus additional sources in a single query, without a data warehouse.

Frequently Asked Questions

How does Knowi authenticate with Recharge?

Knowi uses OAuth. In the datasource setup, you authorize the Knowi app from your Recharge admin. No API token to manage. A legacy API token method still works but is deprecated; OAuth is recommended.

What Recharge data can I pull into Knowi?

Subscriptions, Customers, Orders, Charges, Products, Discounts, Addresses, One-Time Products, and Store Info. The Custom Query option also lets you access any endpoint in the Recharge 2021-11 API.

What charge statuses can I track with the Recharge connector?

The Charges collection tracks six statuses: success, error, queued, skipped, refunded, and partially_refunded.

Can I track subscription cancellations with the Recharge connector?

Yes. The Subscriptions collection includes a cancelled_at field and a status field, so you can filter for active and cancelled subscriptions and see when each cancellation occurred.

Does Knowi handle Recharge rate limits?

Yes. Knowi auto-retries requests that hit the Recharge rate limit (40 burst calls, 2 calls per second sustained, per store) using exponential backoff. No manual handling is needed.

Can I join Recharge data with Shopify or Stripe in Knowi?

Yes. Knowi supports cross-source joins natively. You can join Recharge subscriptions with Shopify orders or Stripe charges directly in a query, without moving data to a warehouse first.

What is the Custom Query option in Recharge?

Custom Query lets you access any Recharge 2021-11 API endpoint not covered by the pre-built collections. Specify the endpoint path directly in the Query Builder.

Ready to connect your Recharge account to Knowi? Read the Recharge connector documentation to get started, or schedule a demo to see it in action with your subscription data.

Sanskriti Garg

Sanskriti Garg

Sanskriti Garg is the Marketing Manager at Knowi, where she leads all marketing initiatives for the company. She oversees positioning, messaging, go-to-market strategy, and campaigns that help Knowi reach businesses looking to unify, analyze, and act on their data with powerful AI analytics. Sanskriti brings over 10+ years of marketing experience, with a strong consumer-focused mindset and storytelling skills. Her expertise spans marketing, demand generation, AI, and analytics, and she’s passionate about making advanced analytics accessible and impactful for organizations of all sizes.

Want to See Knowi in Action?

Connect your databases, run cross-source joins, and ask questions in plain English. No warehouse required.

See Knowi in action
Connect your databases, query across sources, and run AI on-premises. No warehouse required.
Book a Demo