1. Addresses
Purpose: To view all the addresses of your customers.
Replication: Incremental
Replication Key: updated_at
Fields
Name
Datatype
id
INTEGER
payment_method_id
INTEGER
address1
STRING
address2
STRING
city
STRING
company
STRING
country_code
STRING
created_at
DATETIME
customer_id
INTEGER
discounts
RECORD
first_name
STRING
last_name
STRING
order_attributes
RECORD
order_note
STRING
phone
STRING
province
STRING
shipping_lines_override
RECORD
updated_at
DATETIME
zip
STRING
2. Charges
Purpose: To get a list of charges (transactions) on your store.
Replication: Incremental
Replication Key: updated_at
Fields
Name
Datatype
id
INTEGER
address_id
INTEGER
analytics_data
RECORD
billing_address
RECORD
client_details
RECORD
created_at
TIMESTAMP
currency
STRING
customer
RECORD
discounts
RECORD
external_order_id
RECORD
external_transaction_id
RECORD
has_uncommitted_changes
BOOLEAN
line_items
RECORD
note
STRING
order_attributes
RECORD
orders_count
INTEGER
payment_processor
STRING
processed_at
TIMESTAMP
retry_date
DATE
3. Customers
Purpose: To get all the information about your customers.
Replication: Incremental
Replication Key: updated_at
Fields
Name
Datatype
id
INTEGER
analytics_data
RECORD
created_at
DATETIME
email
STRING
external_customer_id
RECORD
first_charge_processed_at
DATETIME
first_name
STRING
has_payment_method_in_dunning
BOOLEAN
has_valid_payment_method
BOOLEAN
hash
STRING
last_name
STRING
subscriptions_active_count
INTEGER
subscriptions_total_count
INTEGER
updated_at
DATETIME
4. Discounts
Purpose: To get information about all the applicable/previously applicable discounts on your store.
Replication: Incremental
Replication Key: updated_at
Fields
Name
Datatype
id
INTEGER
applies_to
RECORD
channel_settings
RECORD
code
STRING
created_at
TIMESTAMP
status
STRING
updated_at
TIMESTAMP
usage_limits
RECORD
value
STRING
value_type
STRING
5. Onetimes
Purpose: To get a list of all the products bought when added to an ongoing subscription.
Replication: Incremental
Replication Key: updated_at
Fields
Name
Datatype
id
INTEGER
address_id
INTEGER
created_at
TIMESTAMP
customer_id
INTEGER
external_product_id
RECORD
external_variant_id
RECORD
next_charge_scheduled_at
TIMESTAMP
price
STRING
product_title
STRING
properties
RECORD
quantity
INTEGER
sku
STRING
sku_override
BOOLEAN
updated_at
TIMESTAMP
variant_title
STRING
next_charge_scheduled_at_dt
DATE
6. Orders
Purpose: To get list of all the orders from your store.
Replication: Incremental
Replication Key: updated_at
Fields
Name
Datatype
id
INTEGER
address_id
INTEGER
billing_address
RECORD
charge
RECORD
client_details
RECORD
created_at
DATETIME
currency
STRING
customer
RECORD
discounts
RECORD
external_cart_token
STRING
external_order_id
RECORD
external_order_number
RECORD
is_prepaid
BOOLEAN
line_items
RECORD
note
STRING
order_attributes
RECORD
processed_at
DATETIME
scheduled_at
DATETIME
shipping_address
RECORD
7. Plans
Purpose: To get a list of all the plans on your store.
Replication: Incremental
Replication Key: updated_at
Fields
Name
Datatype
id
INTEGER
channel_settings
RECORD
created_at
TIMESTAMP
external_product_id
RECORD
sort_order
INTEGER
subscription_preferences
RECORD
title
STRING
type
STRING
updated_at
TIMESTAMP
8. Products
Purpose: To get a list of all the products in your catalogue.
Replication:
Replication Key: external_product_ids
Fields
Name
Datatype
id
INTEGER
collection_id
INTEGER
created_at
DATETIME
discount_amount
INTEGER
discount_type
STRING
handle
STRING
images
RECORD
product_id
INTEGER
shopify_product_id
INTEGER
subscription_defaults
RECORD
title
STRING
updated_at
DATETIME
discount_amount_nu
NUMERIC
product_id_nu
NUMERIC
shopify_product_id_nu
NUMERIC
9. Subscriptions
Purpose: To get information about all the subscriptions.
Replication: Incremental
Replication Key: updated_at
Fields