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.

Need help with something?

Talk to data expert

Tables/APIs

The following is the list of tables or APIs associated with the SKIO connector:

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