Schema Information of SKIO
This subtopic provides a structured reference to assist you in working with Daton's SKIO connector and the associated fields and tables.
Schema Information of SKIO
This subtopic provides a structured reference to assist you in working with Daton's SKIO connector and the associated fields and tables.
Tables/APIs
Orders
Retrieves information related to orders made on the SKIO platform.
For more information, see SKIO- Orders.
FIELDS
| Field Name | Data Type |
|---|---|
| OrderLineItems | RECORD |
| ShippingLines | RECORD |
| StorefrontUser | RECORD |
| createdAt | TIMESTAMP |
| deliveredAt | TIMESTAMP |
| id | STRING |
| platformId | STRING |
| platformNumber | STRING |
| storefrontUserId | STRING |
| updatedAt | DATETIME |
Subscriptions
Retrieves data pertaining to customer subscriptions on the SKIO platform.
For more information, see SKIO- Subscriptions.
FIELDS
| Field Name | Data Type |
|---|---|
| AuditLogs | RECORD |
| BillingPolicy | RECORD |
| CancelFlowV2Sessions | RECORD |
| DeliveryPolicy | RECORD |
| NotificationLogs | RECORD |
| PaymentMethod | RECORD |
| ShippingAddress | RECORD |
| Site | RECORD |
| StorefrontUser | RECORD |
| SubscriptionLines | RECORD |
| billingPolicyId | STRING |
| cancelledAt | TIMESTAMP |
| createdAt | TIMESTAMP |
| currencyCode | STRING |
| cyclesCompleted | NUMERIC |
| deliveryPolicyId | STRING |
| deliveryPrice | NUMERIC |
| id | STRING |
| platformId | STRING |
| shippingAddressId | STRING |
| siteId | STRING |
| status | STRING |
| storefrontUserId | STRING |
| updatedAt | TIMESTAMP |
Subscription_lineitems
Provides details about line items within subscriptions, offering insights into specific subscription-related products.
For more information, see SKIO- Subscription_lineitems.
FIELDS
| Field Name | Data Type |
|---|---|
| Group | RECORD |
| OrderLineItems | RECORD |
| ProductVariant | RECORD |
| Subscription | RECORD |
| createdAt | TIMESTAMP |
| customAttributes | RECORD |
| groupId | STRING |
| id | STRING |
| platformId | STRING |
| priceWithoutDiscount | NUMERIC |
| productVariantId | STRING |
| quantity | NUMERIC |
| subscriptionId | STRING |
| taxable | BOOLEAN |
| updatedAt | TIMESTAMP |
Addresses
Retrieves information regarding customer addresses associated with SKIO subscriptions.
For more information, see SKIO- Addresses
FIELDS
| Field Name | Data Type |
|---|---|
| StorefrontUser | RECORD |
| Subscriptions | RECORD |
| address1 | STRING |
| address2 | STRING |
| city | STRING |
| company | STRING |
| country | STRING |
| createdAt | TIMESTAMP |
| firstName | STRING |
| id | STRING |
| lastName | STRING |
| province | STRING |
| storefrontUserId | STRING |
| updatedAt | TIMESTAMP |
| zip | STRING |
Products
Fetches data related to products available on the SKIO platform.
For more information, see SKIO- Products.
FIELDS
| Field Name | Data Type |
|---|---|
| ProductVariants | RECORD |
| Site | RECORD |
| createdAt | TIMESTAMP |
| id | STRING |
| imageSrc | STRING |
| platformId | STRING |
| siteId | STRING |
| slug | STRING |
| status | STRING |
| title | STRING |
| updatedAt | TIMESTAMP |
Product_variant
Retrieves information about specific variants of products available on SKIO.
For more information, see SKIO- Product_variant.
FIELDS
| Field Name | Data Type |
|---|---|
| OrderLineItems | RECORD |
| Product | RECORD |
| createdAt | TIMESTAMP |
| id | STRING |
| platformId | STRING |
| price | NUMERIC |
| productId | STRING |
| sku | STRING |
| title | STRING |
| updatedAt | TIMESTAMP |