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 |
|---|---|
| id | NUMERIC |
| shopifyId | NUMERIC |
| originOrderShopifyId | NUMERIC |
| 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 |
| cancellationReason | STRING |
| cancellationComment | STRING |
| completedOrdersCount | NUMERIC |
| cancelledAt | TIMESTAMP |
| isPrepaid | BOOLEAN |
| lastPaymentStatus | STRING |
| delivery_interval_count | NUMERIC |
| deliveryMethod | RECORD |
| billingPolicy | RECORD |
| deliveryPolicy | RECORD |
| shippingAddress | RECORD |
| lines | RECORD |
| customer | RECORD |
| customerPaymentMethodId | NUMERIC |
| discounts | RECORD |
| pausedAt | TIMESTAMP |
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 |
|---|---|
| id | NUMERIC |
| status | STRING |
| billingDateEpoch | NUMERIC |
| currencyCode | STRING |
| totalPriceUsd | STRING |
| totalDiscount | STRING |
| totalLineItemsPrice | STRING |
| totalShippingPrice | STRING |
| totalPrice | STRING |
| totalTax | STRING |
| customer | RECORD |
| subscription | RECORD |
| lines | RECORD |
| updatedAt | TIMESTAMP |
| isCheckoutOrder | BOOLEAN |
| shopifyId | NUMERIC |
| financialStatus | STRING |
| shopifyCreatedAt | TIMESTAMP |
| shopifyProcessedAt | TIMESTAMP |
| shopifyUpdatedAt | TIMESTAMP |
| shopifyOrderNumber | NUMERIC |
| shippingAddress | RECORD |
| fulfillmentStatus | STRING |
Billing_Attempts
Manages and provides details about billing attempts for subscriptions.
For More Information see, Read all billing attempts
Fields
| Field Name | Data Type |
|---|---|
| shopifyId | NUMERIC |
| errorCode | STRING |
| errorMessage | STRING |
| orderId | NUMERIC |
| idempotencyKey | STRING |
| subscriptionShopifyId | NUMERIC |
| created_at | TIMESTAMP |
| status | STRING |
| orderShopifyId | 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 |
|---|---|
| id | NUMERIC |
| first_name | STRING |
| last_name | STRING |
| STRING | |
| shopifyId | NUMERIC |
| phone | STRING |
| activeSubscriptionsCount | NUMERIC |
| pausedSubscriptionsCount | NUMERIC |
| cancelledSubscriptionsCount | NUMERIC |
| expiredSubscriptionsCount | NUMERIC |
| allSubscriptionsCount | 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 |
| product Variants | RECORD |
Activity Logs
Manages and provide details about Activity Logs with associated Id & subscription ID.
For more information see, List Activity Logs
Fields
| Field Name | Data Type |
|---|---|
| id | NUMERIC |
| subscriptionId | NUMERIC |
| key | STRING |
| entity | STRING |
| source | STRING |
| created At | TIMESTAMP |