Schema Information- Loop Subscription
Discover the key aspects of schema information and loop subscription strategies in this informative article, providing you with valuable insights on how to optimize your data organization and streamline your subscription processes.
Schema Information- Loop Subscription
Discover the key aspects of schema information and loop subscription strategies in this informative article, providing you with valuable insights on how to optimize your data organization and streamline your subscription processes.
Tables/APIs
The following tables are associated with the Loop Subscription connector:
Subscriptions
Manages and provides information about subscriptions within the Loop platform.
For more information see, Loop Subscription- Subscription.
Fields
| Field Name | Data Type |
|---|---|
| subscription_shopify_id | NUMERIC |
| origin_order_shopify_id | NUMERIC |
| customer | RECORD |
| created_at | TIMESTAMP |
| updated_at | TIMESTAMP |
| total_line_item_price | NUMERIC |
| total_line_item_discounted_price | NUMERIC |
| delivery_price | NUMERIC |
| currency_code | STRING |
| status | STRING |
| billing_attempt_success_count | NUMERIC |
| is_prepaid | NUMERIC |
| next_billing_date | TIMESTAMP |
| billing_interval | STRING |
| billing_interval_count | NUMERIC |
| delivery_interval | STRING |
| delivery_interval_count | NUMERIC |
| line_items | RECORD |
| custom_attributes | RECORD |
| will_auto_resume | BOOLEAN |
| shipping_lines_title | STRING |
| shipping_lines_code | STRING |
| has_custom_plan | BOOLEAN |
| has_bundle | BOOLEAN |
| customer_payment_method_graphql_id | STRING |
Orders
Handles and retrieves data related to orders placed on the Loop Subscription platform.
For more information see, Loop Subscriptions- Orders.
Fields
| Field Name | Data Type |
|---|---|
| loop_id | NUMERIC |
| subscription_shopify_id | NUMERIC |
| customer_shopify_id | NUMERIC |
| customer | RECORD |
| status | STRING |
| billing_date | TIMESTAMP |
| idempotency_key | STRING |
| is_origin_order | NUMERIC |
| created_at | TIMESTAMP |
| updated_at | TIMESTAMP |
Billing_Attempts
Manages and provides details about billing attempts for subscriptions.
Fields
| Field Name | Data Type |
|---|---|
| billing_attempt_shopify_id | NUMERIC |
| idempotency_key | STRING |
| subscription_shopify_id | NUMERIC |
| status | STRING |
| error_message | STRING |
| error_code | STRING |
| created_at | TIMESTAMP |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
Customers
Manages and retrieves information about customers using the Loop Subscription platform.
For more information see, Loop Subscriptions- Customers.
Fields
| Field Name | Data Type |
|---|---|
| customer_shopify_id | NUMERIC |
| first_name | STRING |
| last_name | STRING |
| phone | STRING |
| STRING | |
| contact_email | STRING |
| active_subscriptions_count | NUMERIC |
| all_subscriptions_count | NUMERIC |
Products
Manages and provides details about products available on the Loop Subscription platform.
For more information see, Loop Subscriptions- Products.
Fields
| Field Name | Data Type |
|---|---|
| shopifyId | NUMERIC |
| title | STRING |
| productVariants | RECORD |