# Chargify (v1) Information note **Chargify is in beta** Chargify is currently in beta. The info in this guide is subject to change. Information note **Chargify is supported by the Singer community** This integration is powered by [Singer's](https://www.singer.io/) Chargify tap. For support, [visit the GitHub repo](https://github.com/singer-io/tap-chargify) or [join the Singer Slack](https://singer-slackin.herokuapp.com/). ## Chargify integration summary Stitch’s Chargify integration replicates data using the [Chargify API](https://reference.chargify.com/v1/basics/introduction). Refer to the [Schema](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#schema) section for a list of objects available for replication. ## Chargify feature snapshot A high-level look at Stitch's Chargify (v1) integration, including release status, useful links, and the features supported in Stitch. | **STITCH** | | | | | --- | --- | --- | --- | | **[Release status](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version)** | Beta | **Supported by**

the Info icon

Indicates if the integration is supported by Stitch or the Singer community. | [Singer Community](https://www.singer.io/) | | **Stitch plan**

the Info icon

The type of Stitch plan required to use the integration. | Standard | **[API availability](https://help.qlik.com/en-US/stitch/developers/stitch-connect/guides/source-destination-reference)**

the Info icon

Indicates if the integration is available as a source in Stitch Connect. | the Success icon

This version of the integration is available via the API.

Available | | **Singer GitHub repository** | [singer-io/tap-chargify](https://github.com/singer-io/tap-chargify) | | | | **REPLICATION SETTINGS** | | | | | **[Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)**

the Info icon

A type of replication scheduling where an integration's Replication Frequency is anchored to a time you select. | the Success icon

This feature is supported for this version of the integration.

Supported | **[Advanced Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling)**

the Info icon

A type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions. | the Success icon

This feature is supported for this version of the integration.

Supported | | **Table-level reset**

the Info icon

Indicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level. | the Remove icon

Table-level resets are not supported for this integration. Resets are only supported at the integration level.

Unsupported | **[Configurable Replication Methods](https://help.qlik.com/en-US/stitch/replication/replication-methods)**

the Info icon

Indicates if Replication Methods can be defined by you for tables in the integration. | the Remove icon

Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate.

Unsupported | | **DATA SELECTION** | | | | | **Table selection**

the Info icon

The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default. | the Success icon

This feature is supported for this version of the integration.

Supported | **Column selection**

the Info icon

The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. | the Success icon

This feature is supported for this version of the integration.

Supported | | **Select all**

the Info icon

Indicates if the integration supports selecting all available tables and columns. | the Success icon

Supported

Supported | | | | **TRANSPARENCY** | | | | | **[Extraction Logs](https://help.qlik.com/en-US/stitch/replication/extractions/integration-extraction-logs)**

the Info icon

Logs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur. | the Success icon

This feature is supported for this version of the integration.

Supported | **[Loading Reports](https://help.qlik.com/en-US/stitch/replication/integration-loading-reports)**

the Info icon

Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. | the Success icon

This feature is supported for this version of the integration.

Supported | ## Connecting Chargify ### Chargify setup requirements To set up Chargify in Stitch, you need: * **Owner or Admin access in Chargify**. A user with either [level of access](https://help.chargify.com/my-account/users.html#access-levels) is required to create an API key for Stitch. ### Step 1: Create a Chargify API key Information note **Note**: Completing this step requires Owner or Admin access in Chargify. 1. Sign into your Chargify account as a user with either Owner or Admin access. 2. Navigate to **Config > Integrations**. 3. Click **New API Key**. 4. Copy your API key somewhere secure. ### Step 2: Add Chargify as a Stitch data source 1. [Sign into your Stitch account](https://app.stitchdata.com/). 2. On the Stitch Dashboard page, click the **Add Integration** button. 3. Click the **Chargify** icon. 4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination. For example, the name “Stitch Chargify” would create a schema called `stitch_chargify` in the destination. **Note**: Schema names cannot be changed after you save the integration. 5. In the **API Key** field, paste the API key you created in [Step 1](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#create-api-key). 6. In the **Subdomain** field, enter your Chargify subdomain. For example: If the full URL of your Chargify site were `https://stitch.my-chargify-site.com`, this value would be `stitch`. ### Step 3: Define the historical replication start date The Sync Historical Data setting defines the starting date for your Chargify integration. This means that data **equal to or newer than this date** will be replicated to your data warehouse. Change this setting if you want to replicate data beyond Chargify’s default setting of **1 year**. For a detailed look at historical replication jobs, check out the [Syncing Historical SaaS Data](https://help.qlik.com/en-US/stitch/replication/syncing-historical-saas-data-resetting-replication-keys) guide. ### Step 4: Create a replication schedule Information note Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the [Replication Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling) documentation for more information. In the **Replication Frequency** section, you’ll create the integration’s [replication schedule](https://help.qlik.com/en-US/stitch/replication/replication-scheduling). An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins. Chargify integrations support the following replication scheduling methods: * [Replication Frequency](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/replication-frequency) * [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling) * [Advanced Scheduling using Cron](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling) (Advanced or Premium plans only) To keep your row usage low, consider setting the integration to replicate less frequently. See the [Understanding and Reducing Your Row Usage guide](https://help.qlik.com/en-US/stitch/getting-started/understanding-stitch-usage) for tips on reducing your usage. ### Step 5: Set objects to replicate Information note **Is an object missing or not replicating?** Verify that the object meets the requirements for [selection](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#selection-requirements) and [replication](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#replication-requirements). The last step is to select the tables and columns you want to replicate. [Learn about the available tables for this integration.](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#schema) **Note**: If a replication job is currently in progress, new selections won’t be used until the next job starts. * Selection options * Individual tables and columns * All tables and columns For Chargify integrations, you can select: 1. **Individual tables and columns** 2. **All tables and columns** Click the tabs to view instructions for each selection method. 1. In the integration’s **Tables to Replicate tab**, locate a table you want to replicate. 2. To track a table, click the **checkbox** next to the table’s name. A blue checkmark means the table is set to replicate. 3. To track a column, click the **checkbox** next to the column’s name. A blue checkmark means the column is set to replicate. 4. Repeat this process for all the tables and columns you want to replicate. 5. When finished, click the **Finalize Your Selections** button at the bottom of the screen to save your selections. Information note **Important**: Using the **Select All** feature will overwrite any previous selections. However, selections aren’t final until **Finalize Your Selections** is clicked. Clicking **Cancel** will restore your previous selections. Refer to the [Select All guide](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#set-all-data-to-replicate) for more info about this feature. 1. Click into the integration from the Stitch Dashboard page. 2. Click the **Tables to Replicate** tab. 3. In the list of tables, click the box next to the **Table Names** column. 4. In the menu that displays, click **Track all Tables and Fields**: ![The Track all Tables and Fields menu in the Tables to Replicate tab](https://help.qlik.com/en-US/stitch/images/replication/select-all-tables-menu.png)The Track all Tables and Fields menu in the Tables to Replicate tabThe Track all Tables and Fields menu in the Tables to Replicate tab 5. Click the **Finalize Your Selections** button at the bottom of the page to save your data selections. ### Initial and historical replication jobs After you finish setting up Chargify, its **Sync Status** may show as **Pending** on either the Stitch Dashboard or in the Integration Details page. For a new integration, a **Pending** status indicates that Stitch is in the process of scheduling the initial replication job for the integration. **This may take some time to complete.** Information note **Initial replication jobs with Anchor Scheduling** If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling#job-scheduling-and-anchor-times) documentation for more information. #### Free historical data loads The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota. Information note **Replication will continue after the seven days are over**. If you’re no longer interested in this source, be sure to **pause** or **delete** the integration to prevent unwanted usage. ## Chargify table reference Information note **Schemas and versioning** Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing. The schema and info displayed below is for **version 1** of this integration. This is the latest version of the Chargify integration. Information note **Table and column names in your destination** Depending on your destination, table and column names may not appear as they are outlined below. For example: Object names are lowercased in Redshift (`CusTomERs` > `customers`), while case is maintained in PostgreSQL destinations (`CusTomERs` > `CusTomERs`). Refer to the [Loading Guide](https://help.qlik.com/en-US/stitch/replication/loading/destination-guides) for your destination for more info. ### components The `components` table contains info about components associated with a product family in Chargify. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [components schema on GitHub](https://github.com/singer-io/tap-chargify/blob/master/tap_chargify/schemas/components.json "Opens in new tab: components schema on GitHub")

[Chargify API method](https://reference.chargify.com/v1/components/list-components-for-a-product-family "Opens in new tab: Chargify API method") | components table foreign keys | Join components with | on | | --- | --- | | [invoices](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#invoices) | ```
components.id = invoices.charges.component_id
```

```
components.prices.id = invoices.charges.component_id
```

```
components.id = invoices.payments_and_credits.component_id
```

```
components.prices.id = invoices.payments_and_credits.component_id
``` | | [price_points](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#price-points) | ```
components.id = price_points.component_id
```

```
components.prices.id = price_points.component_id
```

```
components.id = price_points.prices.component_id
```

```
components.prices.id = price_points.prices.component_id
```

```
components.default_price_point_id = price_points.id
```

```
components.prices.price_point_id = price_points.id
``` | | [statements](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#statements) | ```
components.id = statements.transactions.component_id
```

```
components.prices.id = statements.transactions.component_id
``` | | [transactions](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#transactions) | ```
components.id = transactions.component_id
```

```
components.prices.id = transactions.component_id
``` | | [coupons](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#coupons) | ```
components.product_family_id = coupons.product_family_id
``` | | [product_families](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#product-families) | ```
components.product_family_id = product_families.id
``` | | [products](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#products) | ```
components.product_family_id = products.product_family.id
``` | | [subscriptions](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#subscriptions) | ```
components.product_family_id = subscriptions.product.product_family.id
``` | components table schema | **archived**

BOOLEAN | | --- | | **created\_at**

DATE-TIME | | **default\_price\_point\_id**

NUMBER | | **default\_price\_point\_name**

STRING | | **description**

STRING | | **downgrade\_credit**

STRING | | **handle**

STRING | | **id**

INTEGER | | **kind**

STRING | | **name**

STRING | | **price\_per\_unit\_in\_cents**

INTEGER | | **price\_point\_count**

NUMBER | | **price\_points\_url**

STRING | | **prices**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand prices

component_id

INTEGER

ending_quantity

INTEGER

formatted_unit_price

STRING

INTEGER

price_point_id

INTEGER

starting_quantity

INTEGER

unit_price

STRING

| | **pricing\_scheme**

STRING | | **product\_family\_id**

INTEGER | | **product\_family\_name**

STRING | | **recurring**

BOOLEAN | | **tax\_code**

STRING | | **taxable**

BOOLEAN | | **unit\_name**

STRING | | **unit\_price**

STRING | | **upgrade\_charge**

STRING | ### coupons The `coupons` table contains info about coupons associated with a product family in Chargify. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [coupons schema on GitHub](https://github.com/singer-io/tap-chargify/blob/master/tap_chargify/schemas/coupons.json "Opens in new tab: coupons schema on GitHub")

[Chargify API method](https://reference.chargify.com/v1/coupons-editing/list-product-family-coupons "Opens in new tab: Chargify API method") | coupons table foreign keys | Join coupons with | on | | --- | --- | | [components](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#components) | ```
coupons.product_family_id = components.product_family_id
``` | | [product_families](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#product-families) | ```
coupons.product_family_id = product_families.id
``` | | [products](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#products) | ```
coupons.product_family_id = products.product_family.id
``` | | [subscriptions](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#subscriptions) | ```
coupons.product_family_id = subscriptions.product.product_family.id
``` | coupons table schema | **allow\_negative\_balance**

BOOLEAN | | --- | | **amount\_in\_cents**

INTEGER | | **archived\_at**

DATE-TIME | | **code**

STRING | | **compounding\_strategy**

STRING | | **conversion\_limit**

INTEGER | | **coupon\_restrictions**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand coupon\_restrictions

handle

STRING

INTEGER

item_id

INTEGER

item_type

STRING

name

STRING

| | **created\_at**

DATE-TIME | | **description**

STRING | | **duration\_interval**

INTEGER | | **duration\_interval\_unit**

STRING | | **duration\_period\_count**

NUMBER | | **end\_date**

DATE-TIME | | **id**

INTEGER | | **name**

STRING | | **percentage**

NUMBER | | **product\_family\_id**

INTEGER | | **recurring**

BOOLEAN | | **stackable**

BOOLEAN | | **start\_date**

DATE-TIME | | **updated\_at**

DATE-TIME | ### customers The `customers` table contains info about customers associated with your Chargify site. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [customers schema on GitHub](https://github.com/singer-io/tap-chargify/blob/master/tap_chargify/schemas/customers.json "Opens in new tab: customers schema on GitHub")

[Chargify API method](https://reference.chargify.com/v1/customers/list-customers-for-a-site "Opens in new tab: Chargify API method") | customers table foreign keys | Join customers with | on | | --- | --- | | [invoices](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#invoices) | ```
customers.id = invoices.charges.customer_id
```

```
customers.parent_id = invoices.charges.customer_id
```

```
customers.id = invoices.payments_and_credits.customer_id
```

```
customers.parent_id = invoices.payments_and_credits.customer_id
``` | | [statements](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#statements) | ```
customers.id = statements.transactions.customer_id
```

```
customers.parent_id = statements.transactions.customer_id
``` | | [subscriptions](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#subscriptions) | ```
customers.id = subscriptions.credit_card.customer_id
```

```
customers.parent_id = subscriptions.credit_card.customer_id
```

```
customers.id = subscriptions.customer.id
```

```
customers.parent_id = subscriptions.customer.id
``` | | [transactions](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#transactions) | ```
customers.id = transactions.customer_id
```

```
customers.parent_id = transactions.customer_id
``` | customers table schema | **address**

STRING | | --- | | **address\_2**

STRING | | **cc\_emails**

STRING | | **city**

STRING | | **country**

STRING | | **created\_at**

DATE-TIME | | **first\_name**

STRING | | **id**

INTEGER | | **last\_name**

STRING | | **organization**

STRING | | **parent\_id**

INTEGER | | **phone**

STRING | | **portal\_customer\_created\_at**

DATE-TIME | | **portal\_invite\_last\_accepted\_at**

DATE-TIME | | **portal\_invite\_last\_sent\_at**

DATE-TIME | | **reference**

STRING | | **state**

STRING | | **tax\_exempt**

BOOLEAN | | **updated\_at**

DATE-TIME | | **vat\_number**

STRING | | **verified**

BOOLEAN | | **zip**

STRING | ### events The `events` table contains info about activity on your Chargify site. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [events schema on GitHub](https://github.com/singer-io/tap-chargify/blob/master/tap_chargify/schemas/events.json "Opens in new tab: events schema on GitHub")

[Chargify API method](https://reference.chargify.com/v1/events/list-events-for-a-site "Opens in new tab: Chargify API method") | events table foreign keys | Join events with | on | | --- | --- | | [statements](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#statements) | ```
events.id = statements.events.event.id
```

```
events.event_specific_data.product_id = statements.events.event.event_specific_data.product_id
```

```
events.event_specific_data.product_id = statements.transactions.product_id
```

```
events.subscription_id = statements.events.event.subscription_id
```

```
events.subscription_id = statements.subscription_id
```

```
events.subscription_id = statements.transactions.subscription_id
```

```
events.event_specific_data.account_transaction_id = statements.transactions.id
``` | | [invoices](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#invoices) | ```
events.event_specific_data.product_id = invoices.charges.product_id
```

```
events.event_specific_data.product_id = invoices.payments_and_credits.product_id
```

```
events.subscription_id = invoices.charges.subscription_id
```

```
events.subscription_id = invoices.payments_and_credits.subscription_id
```

```
events.subscription_id = invoices.subscription_id
```

```
events.event_specific_data.account_transaction_id = invoices.charges.payment_id
```

```
events.event_specific_data.account_transaction_id = invoices.payments_and_credits.payment_id
``` | | [products](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#products) | ```
events.event_specific_data.product_id = products.id
``` | | [subscriptions](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#subscriptions) | ```
events.event_specific_data.product_id = subscriptions.next_product_id
```

```
events.event_specific_data.product_id = subscriptions.product.id
```

```
events.subscription_id = subscriptions.id
```

```
events.event_specific_data.account_transaction_id = subscriptions.signup_payment_id
```

```
events.event_specific_data.account_transaction_id = subscriptions.stored_credential_transaction_id
``` | | [transactions](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#transactions) | ```
events.event_specific_data.product_id = transactions.product_id
```

```
events.subscription_id = transactions.subscription_id
```

```
events.event_specific_data.account_transaction_id = transactions.id
```

```
events.event_specific_data.account_transaction_id = transactions.parent_id
```

```
events.event_specific_data.account_transaction_id = transactions.payment_id
``` | events table schema | **created\_at**

DATE-TIME | | --- | | **event\_specific\_data**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand event\_specific\_data

account_transaction_id

INTEGER

current_step

OBJECT

action

STRING

day_threshold

INTEGER

email_body

STRING

email_subject

STRING

send_bcc_email

BOOLEAN

send_email

BOOLEAN

send_sms

BOOLEAN

sms_body

STRING

dunner

OBJECT

attempts

INTEGER

created_at

STRING

last_attempted_at

STRING

revenue_at_risk_in_cents

INTEGER

state

STRING

subscription_id

INTEGER

new_product_id

INTEGER

new_subscription_state

STRING

next_step

OBJECT

action

STRING

day_threshold

INTEGER

email_body

STRING

email_subject

STRING

send_bcc_email

BOOLEAN

send_email

BOOLEAN

send_sms

BOOLEAN

sms_body

STRING

previous_product_id

INTEGER

previous_subscription_state

STRING

product_id

INTEGER

| | **id**

INTEGER | | **key**

STRING | | **message**

STRING | | **subscription\_id**

INTEGER | ### invoices The `invoices` table contains info about invoices in your Chargify instance. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [invoices schema on GitHub](https://github.com/singer-io/tap-chargify/blob/master/tap_chargify/schemas/invoices.json "Opens in new tab: invoices schema on GitHub")

[Chargify API method](https://reference.chargify.com/v1/invoices-legacy/list-all-invoices-by-subscription "Opens in new tab: Chargify API method") | invoices table foreign keys | Join invoices with | on | | --- | --- | | [components](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#components) | ```
invoices.charges.component_id = components.id
```

```
invoices.payments_and_credits.component_id = components.id
```

```
invoices.charges.component_id = components.prices.id
```

```
invoices.payments_and_credits.component_id = components.prices.id
``` | | [price_points](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#price-points) | ```
invoices.charges.component_id = price_points.component_id
```

```
invoices.payments_and_credits.component_id = price_points.component_id
```

```
invoices.charges.component_id = price_points.prices.component_id
```

```
invoices.payments_and_credits.component_id = price_points.prices.component_id
``` | | [statements](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#statements) | ```
invoices.charges.component_id = statements.transactions.component_id
```

```
invoices.payments_and_credits.component_id = statements.transactions.component_id
```

```
invoices.charges.customer_id = statements.transactions.customer_id
```

```
invoices.payments_and_credits.customer_id = statements.transactions.customer_id
```

```
invoices.charges.product_id = statements.events.event.event_specific_data.product_id
```

```
invoices.payments_and_credits.product_id = statements.events.event.event_specific_data.product_id
```

```
invoices.charges.product_id = statements.transactions.product_id
```

```
invoices.payments_and_credits.product_id = statements.transactions.product_id
```

```
invoices.statement_id = statements.id
```

```
invoices.statement_id = statements.transactions.statement_id
```

```
invoices.charges.subscription_id = statements.events.event.subscription_id
```

```
invoices.payments_and_credits.subscription_id = statements.events.event.subscription_id
```

```
invoices.subscription_id = statements.events.event.subscription_id
```

```
invoices.charges.subscription_id = statements.subscription_id
```

```
invoices.payments_and_credits.subscription_id = statements.subscription_id
```

```
invoices.subscription_id = statements.subscription_id
```

```
invoices.charges.subscription_id = statements.transactions.subscription_id
```

```
invoices.payments_and_credits.subscription_id = statements.transactions.subscription_id
```

```
invoices.subscription_id = statements.transactions.subscription_id
```

```
invoices.charges.payment_id = statements.transactions.id
```

```
invoices.payments_and_credits.payment_id = statements.transactions.id
``` | | [transactions](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#transactions) | ```
invoices.charges.component_id = transactions.component_id
```

```
invoices.payments_and_credits.component_id = transactions.component_id
```

```
invoices.charges.customer_id = transactions.customer_id
```

```
invoices.payments_and_credits.customer_id = transactions.customer_id
```

```
invoices.charges.product_id = transactions.product_id
```

```
invoices.payments_and_credits.product_id = transactions.product_id
```

```
invoices.statement_id = transactions.statement_id
```

```
invoices.charges.subscription_id = transactions.subscription_id
```

```
invoices.payments_and_credits.subscription_id = transactions.subscription_id
```

```
invoices.subscription_id = transactions.subscription_id
```

```
invoices.charges.payment_id = transactions.id
```

```
invoices.payments_and_credits.payment_id = transactions.id
```

```
invoices.charges.payment_id = transactions.parent_id
```

```
invoices.payments_and_credits.payment_id = transactions.parent_id
```

```
invoices.charges.payment_id = transactions.payment_id
```

```
invoices.payments_and_credits.payment_id = transactions.payment_id
``` | | [customers](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#customers) | ```
invoices.charges.customer_id = customers.id
```

```
invoices.payments_and_credits.customer_id = customers.id
```

```
invoices.charges.customer_id = customers.parent_id
```

```
invoices.payments_and_credits.customer_id = customers.parent_id
``` | | [subscriptions](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#subscriptions) | ```
invoices.charges.customer_id = subscriptions.credit_card.customer_id
```

```
invoices.payments_and_credits.customer_id = subscriptions.credit_card.customer_id
```

```
invoices.charges.customer_id = subscriptions.customer.id
```

```
invoices.payments_and_credits.customer_id = subscriptions.customer.id
```

```
invoices.charges.product_id = subscriptions.next_product_id
```

```
invoices.payments_and_credits.product_id = subscriptions.next_product_id
```

```
invoices.charges.product_id = subscriptions.product.id
```

```
invoices.payments_and_credits.product_id = subscriptions.product.id
```

```
invoices.charges.subscription_id = subscriptions.id
```

```
invoices.payments_and_credits.subscription_id = subscriptions.id
```

```
invoices.subscription_id = subscriptions.id
```

```
invoices.charges.payment_id = subscriptions.signup_payment_id
```

```
invoices.payments_and_credits.payment_id = subscriptions.signup_payment_id
```

```
invoices.charges.payment_id = subscriptions.stored_credential_transaction_id
```

```
invoices.payments_and_credits.payment_id = subscriptions.stored_credential_transaction_id
``` | | [events](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#events) | ```
invoices.charges.product_id = events.event_specific_data.product_id
```

```
invoices.payments_and_credits.product_id = events.event_specific_data.product_id
```

```
invoices.charges.subscription_id = events.subscription_id
```

```
invoices.payments_and_credits.subscription_id = events.subscription_id
```

```
invoices.subscription_id = events.subscription_id
```

```
invoices.charges.payment_id = events.event_specific_data.account_transaction_id
```

```
invoices.payments_and_credits.payment_id = events.event_specific_data.account_transaction_id
``` | | [products](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#products) | ```
invoices.charges.product_id = products.id
```

```
invoices.payments_and_credits.product_id = products.id
``` | invoices table schema | **amount\_due\_in\_cents**

INTEGER | | --- | | **charges**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand charges

amount_in_cents

INTEGER

component_id

INTEGER

created_at

DATE-TIME

customer_id

INTEGER

ending_balance_in_cents

INTEGER

gateway_order_id

STRING

gateway_transaction_id

STRING

INTEGER

kind

STRING

memo

STRING

payment_id

INTEGER

product_id

INTEGER

starting_balance_in_cents

INTEGER

subscription_id

INTEGER

success

BOOLEAN

tax_id

INTEGER

transaction_type

STRING

type

STRING

| | **created\_at**

DATE-TIME | | **id**

INTEGER | | **number**

STRING | | **paid\_at**

DATE-TIME | | **payments\_and\_credits**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand payments\_and\_credits

amount_in_cents

INTEGER

card_expiration

STRING

card_number

STRING

card_type

STRING

component_id

INTEGER

created_at

DATE-TIME

customer_id

INTEGER

ending_balance_in_cents

INTEGER

gateway_order_id

STRING

gateway_transaction_id

STRING

INTEGER

kind

STRING

memo

STRING

payment_id

INTEGER

product_id

INTEGER

starting_balance_in_cents

INTEGER

subscription_id

INTEGER

success

BOOLEAN

tax_id

INTEGER

transaction_type

STRING

type

STRING

| | **site\_id**

INTEGER | | **state**

STRING | | **statement\_id**

INTEGER | | **subscription\_id**

INTEGER | | **total\_amount\_in\_cents**

INTEGER | | **updated\_at**

DATE-TIME | ### price\_points The `price_points` table contains info about product price points in your Chargify instance. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [price_points schema on GitHub](https://github.com/singer-io/tap-chargify/blob/master/tap_chargify/schemas/price_points.json "Opens in new tab: price_points schema on GitHub")

[Chargify API method](https://reference.chargify.com/v1/products-price-points/read-product-price-points "Opens in new tab: Chargify API method") | price\_points table foreign keys | Join price\_points with | on | | --- | --- | | [components](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#components) | ```
price_points.component_id = components.id
```

```
price_points.prices.component_id = components.id
```

```
price_points.component_id = components.prices.id
```

```
price_points.prices.component_id = components.prices.id
```

```
price_points.id = components.default_price_point_id
```

```
price_points.id = components.prices.price_point_id
``` | | [invoices](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#invoices) | ```
price_points.component_id = invoices.charges.component_id
```

```
price_points.prices.component_id = invoices.charges.component_id
```

```
price_points.component_id = invoices.payments_and_credits.component_id
```

```
price_points.prices.component_id = invoices.payments_and_credits.component_id
``` | | [statements](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#statements) | ```
price_points.component_id = statements.transactions.component_id
```

```
price_points.prices.component_id = statements.transactions.component_id
``` | | [transactions](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#transactions) | ```
price_points.component_id = transactions.component_id
```

```
price_points.prices.component_id = transactions.component_id
``` | price\_points table schema | **archived\_at**

DATE-TIME | | --- | | **component\_id**

INTEGER | | **created\_at**

DATE-TIME | | **default**

BOOLEAN | | **handle**

STRING | | **id**

INTEGER | | **name**

STRING | | **prices**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand prices

component_id

INTEGER

ending_quantity

INTEGER

starting_quantity

INTEGER

unit_price

STRING

| | **pricing\_scheme**

STRING | | **updated\_at**

DATE-TIME | ### product\_families The `product_families` table contains info about product families in your Chargify instance. Product families house your products, components, and coupons and are used to categorize products, product levels, or service offerings to your subscribers. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [product_families schema on GitHub](https://github.com/singer-io/tap-chargify/blob/master/tap_chargify/schemas/product_families.json "Opens in new tab: product_families schema on GitHub")

[Chargify API method](https://reference.chargify.com/v1/product-families/list-product-family-via-site "Opens in new tab: Chargify API method") | product\_families table foreign keys | Join product\_families with | on | | --- | --- | | [components](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#components) | ```
product_families.id = components.product_family_id
``` | | [coupons](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#coupons) | ```
product_families.id = coupons.product_family_id
``` | | [products](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#products) | ```
product_families.id = products.product_family.id
``` | | [subscriptions](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#subscriptions) | ```
product_families.id = subscriptions.product.product_family.id
``` | product\_families table schema | **accounting\_code**

STRING | | --- | | **description**

STRING | | **handle**

STRING | | **id**

INTEGER | | **name**

STRING | ### products The `products` table contains info about the prodcts in your Chargify instance. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [products schema on GitHub](https://github.com/singer-io/tap-chargify/blob/master/tap_chargify/schemas/products.json "Opens in new tab: products schema on GitHub")

[Chargify API method](https://reference.chargify.com/v1/products/list-products "Opens in new tab: Chargify API method") | products table foreign keys | Join products with | on | | --- | --- | | [components](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#components) | ```
products.product_family.id = components.product_family_id
``` | | [coupons](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#coupons) | ```
products.product_family.id = coupons.product_family_id
``` | | [product_families](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#product-families) | ```
products.product_family.id = product_families.id
``` | | [subscriptions](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#subscriptions) | ```
products.product_family.id = subscriptions.product.product_family.id
```

```
products.id = subscriptions.next_product_id
```

```
products.id = subscriptions.product.id
``` | | [events](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#events) | ```
products.id = events.event_specific_data.product_id
``` | | [invoices](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#invoices) | ```
products.id = invoices.charges.product_id
```

```
products.id = invoices.payments_and_credits.product_id
``` | | [statements](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#statements) | ```
products.id = statements.events.event.event_specific_data.product_id
```

```
products.id = statements.transactions.product_id
``` | | [transactions](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#transactions) | ```
products.id = transactions.product_id
``` | products table schema | **accounting\_code**

STRING | | --- | | **archived\_at**

DATE-TIME | | **created\_at**

DATE-TIME | | **description**

STRING | | **expiration\_interval**

STRING | | **expiration\_interval\_unit**

STRING | | **handle**

STRING | | **id**

INTEGER | | **initial\_charge\_after\_trial**

BOOLEAN | | **initial\_charge\_in\_cents**

INTEGER | | **interval**

INTEGER | | **interval\_unit**

STRING | | **name**

STRING | | **price\_in\_cents**

INTEGER | | **product\_family**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand product\_family

accounting_code

STRING

description

STRING

handle

STRING

INTEGER

name

STRING

| | **public\_signup\_pages**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand public\_signup\_pages

INTEGER

return_params

STRING

return_url

STRING

url

STRING

| | **request\_credit\_card**

BOOLEAN | | **require\_credit\_card**

BOOLEAN | | **return\_params**

STRING | | **tax\_code**

STRING | | **taxable**

BOOLEAN | | **trial\_interval**

INTEGER | | **trial\_interval\_unit**

STRING | | **trial\_price\_in\_cents**

INTEGER | | **update\_return\_params**

STRING | | **update\_return\_url**

STRING | | **updated\_at**

DATE-TIME | | **version\_number**

INTEGER | ### statements The `statements` table contains info about the statements in your Chargify instance. Statements show all account activity for a specific usage period and are similar to invoices, as they can be marked as currently paid or unpaid. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [statements schema on GitHub](https://github.com/singer-io/tap-chargify/blob/master/tap_chargify/schemas/statements.json "Opens in new tab: statements schema on GitHub")

[Chargify API method](https://reference.chargify.com/v1/statements/list-statements-for-a-site "Opens in new tab: Chargify API method") | statements table foreign keys | Join statements with | on | | --- | --- | | [components](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#components) | ```
statements.transactions.component_id = components.id
```

```
statements.transactions.component_id = components.prices.id
``` | | [invoices](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#invoices) | ```
statements.transactions.component_id = invoices.charges.component_id
```

```
statements.transactions.component_id = invoices.payments_and_credits.component_id
```

```
statements.transactions.customer_id = invoices.charges.customer_id
```

```
statements.transactions.customer_id = invoices.payments_and_credits.customer_id
```

```
statements.events.event.event_specific_data.product_id = invoices.charges.product_id
```

```
statements.transactions.product_id = invoices.charges.product_id
```

```
statements.events.event.event_specific_data.product_id = invoices.payments_and_credits.product_id
```

```
statements.transactions.product_id = invoices.payments_and_credits.product_id
```

```
statements.id = invoices.statement_id
```

```
statements.transactions.statement_id = invoices.statement_id
```

```
statements.events.event.subscription_id = invoices.charges.subscription_id
```

```
statements.subscription_id = invoices.charges.subscription_id
```

```
statements.transactions.subscription_id = invoices.charges.subscription_id
```

```
statements.events.event.subscription_id = invoices.payments_and_credits.subscription_id
```

```
statements.subscription_id = invoices.payments_and_credits.subscription_id
```

```
statements.transactions.subscription_id = invoices.payments_and_credits.subscription_id
```

```
statements.events.event.subscription_id = invoices.subscription_id
```

```
statements.subscription_id = invoices.subscription_id
```

```
statements.transactions.subscription_id = invoices.subscription_id
```

```
statements.transactions.id = invoices.charges.payment_id
```

```
statements.transactions.id = invoices.payments_and_credits.payment_id
``` | | [price_points](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#price-points) | ```
statements.transactions.component_id = price_points.component_id
```

```
statements.transactions.component_id = price_points.prices.component_id
``` | | [transactions](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#transactions) | ```
statements.transactions.component_id = transactions.component_id
```

```
statements.transactions.customer_id = transactions.customer_id
```

```
statements.events.event.event_specific_data.product_id = transactions.product_id
```

```
statements.transactions.product_id = transactions.product_id
```

```
statements.id = transactions.statement_id
```

```
statements.transactions.statement_id = transactions.statement_id
```

```
statements.events.event.subscription_id = transactions.subscription_id
```

```
statements.subscription_id = transactions.subscription_id
```

```
statements.transactions.subscription_id = transactions.subscription_id
```

```
statements.transactions.id = transactions.id
```

```
statements.transactions.id = transactions.parent_id
```

```
statements.transactions.id = transactions.payment_id
``` | | [customers](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#customers) | ```
statements.transactions.customer_id = customers.id
```

```
statements.transactions.customer_id = customers.parent_id
``` | | [subscriptions](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#subscriptions) | ```
statements.transactions.customer_id = subscriptions.credit_card.customer_id
```

```
statements.transactions.customer_id = subscriptions.customer.id
```

```
statements.events.event.event_specific_data.product_id = subscriptions.next_product_id
```

```
statements.transactions.product_id = subscriptions.next_product_id
```

```
statements.events.event.event_specific_data.product_id = subscriptions.product.id
```

```
statements.transactions.product_id = subscriptions.product.id
```

```
statements.events.event.subscription_id = subscriptions.id
```

```
statements.subscription_id = subscriptions.id
```

```
statements.transactions.subscription_id = subscriptions.id
```

```
statements.transactions.id = subscriptions.signup_payment_id
```

```
statements.transactions.id = subscriptions.stored_credential_transaction_id
``` | | [events](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#events) | ```
statements.events.event.id = events.id
```

```
statements.events.event.event_specific_data.product_id = events.event_specific_data.product_id
```

```
statements.transactions.product_id = events.event_specific_data.product_id
```

```
statements.events.event.subscription_id = events.subscription_id
```

```
statements.subscription_id = events.subscription_id
```

```
statements.transactions.subscription_id = events.subscription_id
```

```
statements.transactions.id = events.event_specific_data.account_transaction_id
``` | | [products](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#products) | ```
statements.events.event.event_specific_data.product_id = products.id
```

```
statements.transactions.product_id = products.id
``` | statements table schema | **basic\_html\_view**

STRING | | --- | | **closed\_at**

DATE-TIME | | **created\_at**

DATE-TIME | | **customer\_billing\_address**

STRING | | **customer\_billing\_address\_2**

STRING | | **customer\_billing\_city**

STRING | | **customer\_billing\_country**

STRING | | **customer\_billing\_state**

STRING | | **customer\_billing\_zip**

STRING | | **customer\_first\_name**

STRING | | **customer\_last\_name**

STRING | | **customer\_organization**

STRING | | **customer\_shipping\_address**

STRING | | **customer\_shipping\_address\_2**

STRING | | **customer\_shipping\_city**

STRING | | **customer\_shipping\_country**

STRING | | **customer\_shipping\_state**

STRING | | **customer\_shipping\_zip**

STRING | | **ending\_balance\_in\_cents**

INTEGER | | **events**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand events

event

OBJECT

created_at

DATE-TIME

event_specific_data

OBJECT

account_transaction_id

INTEGER

current_step

OBJECT

action

STRING

day_threshold

INTEGER

email_body

STRING

email_subject

STRING

send_bcc_email

BOOLEAN

send_email

BOOLEAN

send_sms

BOOLEAN

sms_body

STRING

dunner

OBJECT

attempts

INTEGER

created_at

STRING

last_attempted_at

STRING

revenue_at_risk_in_cents

INTEGER

state

STRING

subscription_id

INTEGER

new_product_id

INTEGER

new_subscription_state

STRING

next_step

OBJECT

action

STRING

day_threshold

INTEGER

email_body

STRING

email_subject

STRING

send_bcc_email

BOOLEAN

send_email

BOOLEAN

send_sms

BOOLEAN

sms_body

STRING

previous_product_id

INTEGER

previous_subscription_state

STRING

product_id

INTEGER

key

STRING

message

STRING

subscription_id

INTEGER

| | **future\_payments**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand future\_payments

INTEGER

| | **html\_view**

STRING | | **id**

INTEGER | | **memo**

STRING | | **opened\_at**

DATE-TIME | | **settled\_at**

DATE-TIME | | **starting\_balance\_in\_cents**

INTEGER | | **subscription\_id**

INTEGER | | **text\_view**

STRING | | **total\_in\_cents**

INTEGER | | **transactions**

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand transactions

amount_in_cents

INTEGER

component_id

INTEGER

created_at

DATE-TIME

customer_id

INTEGER

discount_amount_in_cents

INTEGER

ending_balance_in_cents

INTEGER

gateway_order_id

STRING

gateway_transaction_id

STRING

gateway_used

STRING

INTEGER

item_name

STRING

kind

STRING

memo

STRING

original_amount_in_cents

INTEGER

payment_id

INTEGER

product_id

INTEGER

starting_balance_in_cents

INTEGER

statement_id

INTEGER

subscription_id

INTEGER

success

BOOLEAN

tax_id

INTEGER

taxable_amount_in_cents

INTEGER

taxations

ARRAY

INTEGER

transaction_type

STRING

type

STRING

| | **updated\_at**

DATE-TIME | ### subscriptions The `subscriptions` table contains info about the subscriptions in your Chargify instance. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [subscriptions schema on GitHub](https://github.com/singer-io/tap-chargify/blob/master/tap_chargify/schemas/subscriptions.json "Opens in new tab: subscriptions schema on GitHub")

[Chargify API method](https://reference.chargify.com/v1/subscriptions/list-subscriptions "Opens in new tab: Chargify API method") | subscriptions table foreign keys | Join subscriptions with | on | | --- | --- | | [customers](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#customers) | ```
subscriptions.credit_card.customer_id = customers.id
```

```
subscriptions.customer.id = customers.id
```

```
subscriptions.credit_card.customer_id = customers.parent_id
```

```
subscriptions.customer.id = customers.parent_id
``` | | [invoices](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#invoices) | ```
subscriptions.credit_card.customer_id = invoices.charges.customer_id
```

```
subscriptions.customer.id = invoices.charges.customer_id
```

```
subscriptions.credit_card.customer_id = invoices.payments_and_credits.customer_id
```

```
subscriptions.customer.id = invoices.payments_and_credits.customer_id
```

```
subscriptions.next_product_id = invoices.charges.product_id
```

```
subscriptions.product.id = invoices.charges.product_id
```

```
subscriptions.next_product_id = invoices.payments_and_credits.product_id
```

```
subscriptions.product.id = invoices.payments_and_credits.product_id
```

```
subscriptions.id = invoices.charges.subscription_id
```

```
subscriptions.id = invoices.payments_and_credits.subscription_id
```

```
subscriptions.id = invoices.subscription_id
```

```
subscriptions.signup_payment_id = invoices.charges.payment_id
```

```
subscriptions.stored_credential_transaction_id = invoices.charges.payment_id
```

```
subscriptions.signup_payment_id = invoices.payments_and_credits.payment_id
```

```
subscriptions.stored_credential_transaction_id = invoices.payments_and_credits.payment_id
``` | | [statements](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#statements) | ```
subscriptions.credit_card.customer_id = statements.transactions.customer_id
```

```
subscriptions.customer.id = statements.transactions.customer_id
```

```
subscriptions.next_product_id = statements.events.event.event_specific_data.product_id
```

```
subscriptions.product.id = statements.events.event.event_specific_data.product_id
```

```
subscriptions.next_product_id = statements.transactions.product_id
```

```
subscriptions.product.id = statements.transactions.product_id
```

```
subscriptions.id = statements.events.event.subscription_id
```

```
subscriptions.id = statements.subscription_id
```

```
subscriptions.id = statements.transactions.subscription_id
```

```
subscriptions.signup_payment_id = statements.transactions.id
```

```
subscriptions.stored_credential_transaction_id = statements.transactions.id
``` | | [transactions](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#transactions) | ```
subscriptions.credit_card.customer_id = transactions.customer_id
```

```
subscriptions.customer.id = transactions.customer_id
```

```
subscriptions.next_product_id = transactions.product_id
```

```
subscriptions.product.id = transactions.product_id
```

```
subscriptions.id = transactions.subscription_id
```

```
subscriptions.signup_payment_id = transactions.id
```

```
subscriptions.stored_credential_transaction_id = transactions.id
```

```
subscriptions.signup_payment_id = transactions.parent_id
```

```
subscriptions.stored_credential_transaction_id = transactions.parent_id
```

```
subscriptions.signup_payment_id = transactions.payment_id
```

```
subscriptions.stored_credential_transaction_id = transactions.payment_id
``` | | [components](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#components) | ```
subscriptions.product.product_family.id = components.product_family_id
``` | | [coupons](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#coupons) | ```
subscriptions.product.product_family.id = coupons.product_family_id
``` | | [product_families](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#product-families) | ```
subscriptions.product.product_family.id = product_families.id
``` | | [products](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#products) | ```
subscriptions.product.product_family.id = products.product_family.id
```

```
subscriptions.next_product_id = products.id
```

```
subscriptions.product.id = products.id
``` | | [events](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#events) | ```
subscriptions.next_product_id = events.event_specific_data.product_id
```

```
subscriptions.product.id = events.event_specific_data.product_id
```

```
subscriptions.id = events.subscription_id
```

```
subscriptions.signup_payment_id = events.event_specific_data.account_transaction_id
```

```
subscriptions.stored_credential_transaction_id = events.event_specific_data.account_transaction_id
``` | subscriptions table schema | **activated\_at**

DATE-TIME | | --- | | **balance\_in\_cents**

INTEGER | | **cancel\_at\_end\_of\_period**

BOOLEAN | | **canceled\_at**

DATE-TIME | | **cancellation\_message**

STRING | | **cancellation\_method**

STRING | | **coupon\_codes**

STRING | | **created\_at**

DATE-TIME | | **credit\_card**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand credit\_card

billing_address

STRING

billing_address_2

STRING

billing_city

STRING

billing_country

STRING

billing_state

STRING

billing_zip

STRING

card_type

STRING

current_vault

STRING

customer_id

INTEGER

customer_vault_token

STRING

expiration_month

NUMBER

expiration_year

NUMBER

first_name

STRING

INTEGER

last_name

STRING

masked_card_number

STRING

payment_type

STRING

vault_token

STRING

| | **current\_period\_ends\_at**

DATE-TIME | | **current\_period\_started\_at**

DATE-TIME | | **customer**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand customer

address

STRING

address_2

STRING

cc_emails

STRING

city

STRING

country

STRING

created_at

DATE-TIME

email

STRING

first_name

STRING

INTEGER

last_name

STRING

organization

STRING

phone

STRING

portal_customer_created_at

DATE-TIME

portal_invite_last_accepted_at

DATE-TIME

portal_invite_last_sent_at

DATE-TIME

reference

STRING

state

STRING

tax_exempt

BOOLEAN

updated_at

DATE-TIME

vat_number

STRING

verified

BOOLEAN

zip

STRING

| | **delayed\_cancel\_at**

DATE-TIME | | **expires\_at**

DATE-TIME | | **id**

INTEGER | | **net\_terms**

INTEGER | | **next\_assessment\_at**

DATE-TIME | | **next\_product\_id**

INTEGER | | **payment\_collection\_method**

STRING | | **payment\_type**

STRING | | **previous\_state**

STRING | | **product**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand product

accounting_code

STRING

archived_at

DATE-TIME

created_at

DATE-TIME

description

STRING

expiration_interval

INTEGER

expiration_interval_unit

STRING

handle

STRING

INTEGER

initial_charge_after_trial

BOOLEAN

initial_charge_in_cents

INTEGER

interval

INTEGER

interval_unit

STRING

name

STRING

price_in_cents

INTEGER

product_family

OBJECT

accounting_code

STRING

description

STRING

handle

STRING

INTEGER

name

STRING

public_signup_pages

ARRAY

INTEGER

url

STRING

request_credit_card

BOOLEAN

require_credit_card

BOOLEAN

return_params

STRING

taxable

BOOLEAN

trial_interval

INTEGER

trial_interval_unit

STRING

trial_price_in_cents

INTEGER

update_return_params

STRING

update_return_url

STRING

updated_at

DATE-TIME

version_number

NUMBER

| | **product\_price\_in\_cents**

INTEGER | | **product\_version\_number**

INTEGER | | **reason\_code**

STRING | | **receives\_invoice\_emails**

BOOLEAN | | **referral\_code**

STRING | | **signup\_payment\_id**

NUMBER | | **signup\_revenue**

STRING | | **snap\_day**

STRING | | **state**

STRING | | **stored\_credential\_transaction\_id**

INTEGER | | **total\_revenue\_in\_cents**

INTEGER | | **trial\_ended\_at**

DATE-TIME | | **trial\_started\_at**

DATE-TIME | | **updated\_at**

DATE-TIME | ### transactions The `transactions` table contains info about the transactions for your Chargify site. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Loading Behavior [](https://help.qlik.com/en-US/stitch/replication/loading/understanding-loading-behavior)[the Info icon](https://help.qlik.com/en-US/stitch/replication/loading/understanding-loading-behavior)[](https://help.qlik.com/en-US/stitch/replication/loading/understanding-loading-behavior)** | Append-Only | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | created\_at | | **Useful links** | [transactions schema on GitHub](https://github.com/singer-io/tap-chargify/blob/master/tap_chargify/schemas/transactions.json "Opens in new tab: transactions schema on GitHub")

[Chargify API method](https://reference.chargify.com/v1/transactions/list-transactions-for-the-site "Opens in new tab: Chargify API method") | transactions table foreign keys | Join transactions with | on | | --- | --- | | [components](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#components) | ```
transactions.component_id = components.id
```

```
transactions.component_id = components.prices.id
``` | | [invoices](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#invoices) | ```
transactions.component_id = invoices.charges.component_id
```

```
transactions.component_id = invoices.payments_and_credits.component_id
```

```
transactions.customer_id = invoices.charges.customer_id
```

```
transactions.customer_id = invoices.payments_and_credits.customer_id
```

```
transactions.product_id = invoices.charges.product_id
```

```
transactions.product_id = invoices.payments_and_credits.product_id
```

```
transactions.statement_id = invoices.statement_id
```

```
transactions.subscription_id = invoices.charges.subscription_id
```

```
transactions.subscription_id = invoices.payments_and_credits.subscription_id
```

```
transactions.subscription_id = invoices.subscription_id
```

```
transactions.id = invoices.charges.payment_id
```

```
transactions.parent_id = invoices.charges.payment_id
```

```
transactions.payment_id = invoices.charges.payment_id
```

```
transactions.id = invoices.payments_and_credits.payment_id
```

```
transactions.parent_id = invoices.payments_and_credits.payment_id
```

```
transactions.payment_id = invoices.payments_and_credits.payment_id
``` | | [price_points](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#price-points) | ```
transactions.component_id = price_points.component_id
```

```
transactions.component_id = price_points.prices.component_id
``` | | [statements](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#statements) | ```
transactions.component_id = statements.transactions.component_id
```

```
transactions.customer_id = statements.transactions.customer_id
```

```
transactions.product_id = statements.events.event.event_specific_data.product_id
```

```
transactions.product_id = statements.transactions.product_id
```

```
transactions.statement_id = statements.id
```

```
transactions.statement_id = statements.transactions.statement_id
```

```
transactions.subscription_id = statements.events.event.subscription_id
```

```
transactions.subscription_id = statements.subscription_id
```

```
transactions.subscription_id = statements.transactions.subscription_id
```

```
transactions.id = statements.transactions.id
```

```
transactions.parent_id = statements.transactions.id
```

```
transactions.payment_id = statements.transactions.id
``` | | [customers](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#customers) | ```
transactions.customer_id = customers.id
```

```
transactions.customer_id = customers.parent_id
``` | | [subscriptions](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#subscriptions) | ```
transactions.customer_id = subscriptions.credit_card.customer_id
```

```
transactions.customer_id = subscriptions.customer.id
```

```
transactions.product_id = subscriptions.next_product_id
```

```
transactions.product_id = subscriptions.product.id
```

```
transactions.subscription_id = subscriptions.id
```

```
transactions.id = subscriptions.signup_payment_id
```

```
transactions.parent_id = subscriptions.signup_payment_id
```

```
transactions.payment_id = subscriptions.signup_payment_id
```

```
transactions.id = subscriptions.stored_credential_transaction_id
```

```
transactions.parent_id = subscriptions.stored_credential_transaction_id
```

```
transactions.payment_id = subscriptions.stored_credential_transaction_id
``` | | [events](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#events) | ```
transactions.product_id = events.event_specific_data.product_id
```

```
transactions.subscription_id = events.subscription_id
```

```
transactions.id = events.event_specific_data.account_transaction_id
```

```
transactions.parent_id = events.event_specific_data.account_transaction_id
```

```
transactions.payment_id = events.event_specific_data.account_transaction_id
``` | | [products](https://help.qlik.com/en-US/stitch/integrations/saas/chargify#products) | ```
transactions.product_id = products.id
``` | transactions table schema | **amount\_in\_cents**

INTEGER | | --- | | **card\_expiration**

STRING | | **card\_number**

STRING | | **card\_type**

STRING | | **component\_handle**

STRING | | **component\_id**

INTEGER | | **component\_price\_point\_handle**

STRING | | **component\_price\_point\_id**

INTEGER | | **created\_at**

DATE-TIME | | **customer\_id**

INTEGER | | **ending\_balance\_in\_cents**

INTEGER | | **gateway\_order\_id**

NUMBER | | **gateway\_transaction\_id**

STRING | | **gateway\_used**

STRING | | **id**

INTEGER | | **item\_name**

STRING | | **kind**

STRING | | **memo**

STRING | | **parent\_id**

INTEGER | | **payment\_id**

INTEGER | | **period\_range\_end**

STRING | | **period\_range\_start**

STRING | | **price\_point\_handle**

STRING | | **price\_point\_id**

INTEGER | | **product\_id**

INTEGER | | **refunded\_amount\_in\_cents**

INTEGER | | **role**

STRING | | **starting\_balance\_in\_cents**

INTEGER | | **statement\_id**

INTEGER | | **subscription\_id**

INTEGER | | **success**

BOOLEAN | | **tax\_id**

INTEGER | | **transaction\_type**

STRING | | **type**

STRING |