Browse sources$ls -a sources
Logo of seal
Seal
Subscription management tool for seamless customer experiences.
Sync your customers' dataFiber pulls data from your customers' Seal accounts into your database or cloud storage. Skip months of integration work and begin syncing in minutes.
Logo of seal
Logo of seal
Logo of seal
Logo of seal
Logo of seal
Logo of seal
Logo of seal
Logo of seal
Logo of seal
Logo of seal
Fiber
postgres-prod
seal_subscriptions
Your customers' Seal accounts
Your production database
Meet your new integration toolkit: SQLReplace calls to the Seal API with an interface you already use. Access the data you need straight from your database.
-- Fetch all the Subscriptions belonging to the Seal
-- account of a particular user.

SELECT *
FROM fiber.seal_subscription
WHERE account_id = '{user.seal_id}'
-- Fetch all the Subscriptions belonging to the Seal
-- account of a particular user.

SELECT *
FROM fiber.seal_subscription
WHERE account_id = '{user.seal_id}'
Code
CREATE TABLE fiber.seal_subscription (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
order_placed TEXT,
order_id TEXT,
status TEXT,
internal_id TEXT,
delivery_interval TEXT,
billing_interval TEXT,
email TEXT,
currency TEXT,
first_name TEXT,
last_name TEXT,
s_first_name TEXT,
s_last_name TEXT,
s_address_1 TEXT,
s_address_2 TEXT,
s_phone TEXT,
s_city TEXT,
s_zip TEXT,
s_province TEXT,
s_country TEXT,
s_country_code TEXT,
s_province_code TEXT,
b_first_name TEXT,
b_last_name TEXT,
b_address_1 TEXT,
b_address_2 TEXT,
b_phone TEXT,
b_city TEXT,
b_zip TEXT,
b_province TEXT,
b_country TEXT,
b_company TEXT,
b_country_code TEXT,
b_province_code TEXT,
total_value DOUBLE PRECISION,
admin_note TEXT,
subscription_type DOUBLE PRECISION,
cancellation_reason TEXT,
edit_url TEXT,
items JSONB
)
CREATE TABLE fiber.seal_subscription (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
order_placed TEXT,
order_id TEXT,
status TEXT,
internal_id TEXT,
delivery_interval TEXT,
billing_interval TEXT,
email TEXT,
currency TEXT,
first_name TEXT,
last_name TEXT,
s_first_name TEXT,
s_last_name TEXT,
s_address_1 TEXT,
s_address_2 TEXT,
s_phone TEXT,
s_city TEXT,
s_zip TEXT,
s_province TEXT,
s_country TEXT,
s_country_code TEXT,
s_province_code TEXT,
b_first_name TEXT,
b_last_name TEXT,
b_address_1 TEXT,
b_address_2 TEXT,
b_phone TEXT,
b_city TEXT,
b_zip TEXT,
b_province TEXT,
b_country TEXT,
b_company TEXT,
b_country_code TEXT,
b_province_code TEXT,
total_value DOUBLE PRECISION,
admin_note TEXT,
subscription_type DOUBLE PRECISION,
cancellation_reason TEXT,
edit_url TEXT,
items JSONB
)
Model definition
About this source
Logo of Seal
SealSubscription management tool for seamless customer experiences.sealsubscriptions.com  ↗
Available resources
    Subscriptions
Missing a resource? We will build it for you.
Similar sources
OAuth
Need help with OAuth for Seal?Handshake ↗ is a Next.js app boilerplate that handles your OAuth with Seal and over 200 other APIs. Setup and deploy within minutes.
Logo of sealIntegrate Seal using Fiber Fiber makes it easy to access third-party data from Seal accounts. Get started in just a few minutes.