Chargify
Chargify is a recurring billing and revenue management platform built specifically for B2B SaaS companies.
Chargify integration replicates data using the Chargify API.
See the Schema section for a list of objects available for replication.Zadania replikacji: Zastosuj zmiany Zapisz zmiany Umieszczanie danych w zadaniach jeziora danych: Przechwytywanie zmian danych (CDC) Wymagane. W ten sposób cel jest na bieżąco informowany o zmianach w źródle. W kwestii zadań replikacji zobacz Planowanie zadań W sprawie zadań umieszczania w jeziorze zobacz Harmonogram CDC dla zadań umieszczania w jeziorze Częściowa obsługa Tylko CDC, ponieważ pełne ładowanie jest nieodpowiednie dla tego łącznika.Cecha/możliwość Szczegóły obsługi Wspierane projekty Qlik Talend Data Integration Tylko projekty replikacji. Projekty potoków danych nie są obsługiwane. Ręczne tworzenie metadanych nie jest wymagane. Obsługiwana jest tylko operacja Zmień typ danych kolumny. Replikacja kolumn LOB (NCLOB, CLOB i BLOB) Brak obsługi. Zaplanowane CDC Powiadomienia Monitorowanie Automatyczne eliminowanie zagnieżdżeń zawartości kolumn JSON Brak obsługi. Ładunki kolumn JSON w źródłowych zestawach danych nie są automatycznie rozwijane w docelowych.
Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
Creating the connection
Więcej informacji zawiera temat Łączenie się z aplikacjami SaaS.
- Wprowadź wymagane właściwości połączenia.
Podaj nazwę połączenia w polu Nazwa połączenia.
Wybierz opcję Otwórz metadane połączenia, aby zdefiniować metadane połączenia po jegu utworzeniu.
Kliknij polecenie Utwórz.
| Setting | Description |
|---|---|
| Data gateway | Wybierz bramę Brama danych ruchu danych, jeżeli jest wymagana do danego zastosowania. Informacja To pole jest niedostępne w subskrypcji Qlik Talend Cloud Starter, ponieważ brama Brama danych ruchu danych jest w niej nieobsługiwana. Jeśli masz inny poziom subskrypcji i nie chcesz korzystać z bramy Brama danych ruchu danych, wybierz opcję Brak. Informacje o zaletach bramy Brama danych ruchu danych i o okolicznościach, w których jest wymagana, zawiera temat Brama danych Qlik — ruch danych. |
| Start Date | Wprowadź datę, w formacie |
| API Key | API key. |
| Subdomain | You can find your subdomain in the URL of your account homepage. If the URL is my-chargify-site.chargify.com, the subdomain is my-chargify-site. |
Schema
Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 1.
Depending on your destination, table and column names may not appear as they are outlined below.
components
The components table contains info about components associated with a product family in Chargify.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
| Join components with | on |
|---|---|
| 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 | 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 | components.id = statements.transactions.component_id components.prices.id = statements.transactions.component_id |
| transactions | components.id = transactions.component_id components.prices.id = transactions.component_id |
| coupons | components.product_family_id = coupons.product_family_id |
| product_families | components.product_family_id = product_families.id |
| products | components.product_family_id = products.product_family.id |
| subscriptions | components.product_family_id = subscriptions.product.product_family.id |
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:
|
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 | Full Table |
Primary Key | id |
| Useful links |
| Join coupons with | on |
|---|---|
| components | coupons.product_family_id = components.product_family_id |
| product_families | coupons.product_family_id = product_families.id |
| products | coupons.product_family_id = products.product_family.id |
| subscriptions | coupons.product_family_id = subscriptions.product.product_family.id |
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:
|
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 | Full Table |
Primary Key | id |
| Useful links |
| Join customers with | on |
|---|---|
| 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 | customers.id = statements.transactions.customer_id customers.parent_id = statements.transactions.customer_id |
| 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 | customers.id = transactions.customer_id customers.parent_id = transactions.customer_id |
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 | Full Table |
Primary Key | id |
| Useful links |
| Join events with | on |
|---|---|
| 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 | 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 | events.event_specific_data.product_id = products.id |
| 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 | 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 |
created_at DATE-TIME |
event_specific_data OBJECT This is a nested data structure:
|
id INTEGER |
key STRING |
message STRING |
subscription_id INTEGER |
invoices
The invoices table contains info about invoices in your Chargify instance.
Replication Method | CDC |
Primary Key | id |
| Useful links |
| Join invoices with | on |
|---|---|
| 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 | 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 | 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 | 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 | 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 | 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 | 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 | invoices.charges.product_id = products.id invoices.payments_and_credits.product_id = products.id |
amount_due_in_cents INTEGER |
charges ARRAY This is a nested data structure:
|
created_at DATE-TIME |
id INTEGER |
number STRING |
paid_at DATE-TIME |
payments_and_credits ARRAY This is a nested data structure:
|
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 | Full Table |
Primary Key | id |
| Useful links |
| Join price_points with | on |
|---|---|
| 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 | 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 | price_points.component_id = statements.transactions.component_id price_points.prices.component_id = statements.transactions.component_id |
| transactions | price_points.component_id = transactions.component_id price_points.prices.component_id = transactions.component_id |
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:
|
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 | Full Table |
Primary Key | id |
| Useful links |
| Join product_families with | on |
|---|---|
| components | product_families.id = components.product_family_id |
| coupons | product_families.id = coupons.product_family_id |
| products | product_families.id = products.product_family.id |
| subscriptions | product_families.id = subscriptions.product.product_family.id |
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 | Full Table |
Primary Key | id |
| Useful links |
| Join products with | on |
|---|---|
| components | products.product_family.id = components.product_family_id |
| coupons | products.product_family.id = coupons.product_family_id |
| product_families | products.product_family.id = product_families.id |
| subscriptions | products.product_family.id = subscriptions.product.product_family.id products.id = subscriptions.next_product_id products.id = subscriptions.product.id |
| events | products.id = events.event_specific_data.product_id |
| invoices | products.id = invoices.charges.product_id products.id = invoices.payments_and_credits.product_id |
| statements | products.id = statements.events.event.event_specific_data.product_id products.id = statements.transactions.product_id |
| transactions | products.id = transactions.product_id |
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:
|
public_signup_pages ARRAY This is a nested data structure:
|
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 | Full Table |
Primary Key | id |
| Useful links |
| Join statements with | on |
|---|---|
| components | statements.transactions.component_id = components.id statements.transactions.component_id = components.prices.id |
| 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 | statements.transactions.component_id = price_points.component_id statements.transactions.component_id = price_points.prices.component_id |
| 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 | statements.transactions.customer_id = customers.id statements.transactions.customer_id = customers.parent_id |
| 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 | 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 | statements.events.event.event_specific_data.product_id = products.id statements.transactions.product_id = products.id |
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:
|
future_payments ARRAY This is a nested data structure:
|
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:
|
updated_at DATE-TIME |
subscriptions
The subscriptions table contains info about the subscriptions in your Chargify instance.
Replication Method | Full Table |
Primary Key | id |
| Useful links |
| Join subscriptions with | on |
|---|---|
| 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 | 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 | 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 | 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 | subscriptions.product.product_family.id = components.product_family_id |
| coupons | subscriptions.product.product_family.id = coupons.product_family_id |
| product_families | subscriptions.product.product_family.id = product_families.id |
| products | subscriptions.product.product_family.id = products.product_family.id subscriptions.next_product_id = products.id subscriptions.product.id = products.id |
| 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 |
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:
|
current_period_ends_at DATE-TIME |
current_period_started_at DATE-TIME |
customer OBJECT This is a nested data structure:
|
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:
|
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 | CDC |
Loading Behavior | Append-Only |
Primary Key | id |
Replication Key | created_at |
| Useful links |
| Join transactions with | on |
|---|---|
| components | transactions.component_id = components.id transactions.component_id = components.prices.id |
| 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 | transactions.component_id = price_points.component_id transactions.component_id = price_points.prices.component_id |
| 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 | transactions.customer_id = customers.id transactions.customer_id = customers.parent_id |
| 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 | 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 | transactions.product_id = products.id |
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 |