Integrate Maxio using Fiber

Sync your customers' dataFiber pulls data from your customers' Maxio accounts into your database or cloud storage. Skip months of integration work and begin syncing in minutes.

→

Fiber

→

postgres-prod

maxio_subscriptions

maxio_customers

maxio_products

Your customers' Maxio accounts

Your production database

Meet your new integration toolkit: SQLReplace calls to the Maxio API with an interface you already use. Access the data you need straight from your database.

-- Fetch all the Subscriptions belonging to the Maxio 
-- account of a particular user. 

SELECT *
FROM fiber.maxio_subscription
WHERE account_id = '{user.maxio_id}'

-- Fetch all the Subscriptions belonging to the Maxio 
-- account of a particular user. 

SELECT *
FROM fiber.maxio_subscription
WHERE account_id = '{user.maxio_id}'

Code

CREATE TABLE fiber.maxio_subscription (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  state TEXT,
  balance_in_cents INT,
  total_revenue_in_cents INT,
  product_price_in_cents INT,
  product_version_number INT,
  current_period_ends_at TIMESTAMP WITH TIME ZONE,
  next_assessment_at TIMESTAMP WITH TIME ZONE,
  trial_started_at TIMESTAMP WITH TIME ZONE,
  trial_ended_at TIMESTAMP WITH TIME ZONE,
  activated_at TIMESTAMP WITH TIME ZONE,
  expires_at TIMESTAMP WITH TIME ZONE,
  cancellation_message TEXT,
  cancellation_method TEXT,
  cancel_at_end_of_period BOOLEAN,
  canceled_at TIMESTAMP WITH TIME ZONE,
  current_period_started_at TIMESTAMP WITH TIME ZONE,
  previous_state TEXT,
  signup_payment_id TEXT,
  signup_revenue TEXT,
  delayed_cancel_at TIMESTAMP WITH TIME ZONE,
  coupon_code TEXT,
  snap_day TEXT,
  payment_collection_method TEXT,
  customer JSONB,
  product JSONB,
  credit_card JSONB,
  group JSONB,
  bank_account JSONB,
  payment_type TEXT,
  referral_code TEXT,
  next_product_id TEXT,
  next_product_handle TEXT,
  coupon_use_count INT,
  coupon_uses_allowed INT,
  reason_code TEXT,
  automatically_resume_at TIMESTAMP WITH TIME ZONE,
  coupon_codes TEXT[],
  offer_id TEXT,
  payer_id TEXT,
  current_billing_amount_in_cents INT,
  product_price_point_id TEXT,
  product_price_point_type TEXT,
  next_product_price_point_id TEXT,
  net_terms INT,
  stored_credential_transaction_id TEXT,
  reference TEXT,
  on_hold_at TIMESTAMP WITH TIME ZONE,
  prepaid_dunning BOOLEAN,
  coupons JSONB,
  dunning_communication_delay_enabled BOOLEAN,
  dunning_communication_delay_time_zone TEXT,
  receives_invoice_emails BOOLEAN,
  locale TEXT,
  currency TEXT,
  scheduled_cancellation_at TIMESTAMP WITH TIME ZONE,
  credit_balance_in_cents INT,
  prepayment_balance_in_cents INT,
  prepaid_configuration JSONB,
  self_service_page_token TEXT
)

CREATE TABLE fiber.maxio_subscription (
  id TEXT NOT NULL,
  created_at TIMESTAMP WITH TIME ZONE,
  updated_at TIMESTAMP WITH TIME ZONE,
  account_id TEXT,
  state TEXT,
  balance_in_cents INT,
  total_revenue_in_cents INT,
  product_price_in_cents INT,
  product_version_number INT,
  current_period_ends_at TIMESTAMP WITH TIME ZONE,
  next_assessment_at TIMESTAMP WITH TIME ZONE,
  trial_started_at TIMESTAMP WITH TIME ZONE,
  trial_ended_at TIMESTAMP WITH TIME ZONE,
  activated_at TIMESTAMP WITH TIME ZONE,
  expires_at TIMESTAMP WITH TIME ZONE,
  cancellation_message TEXT,
  cancellation_method TEXT,
  cancel_at_end_of_period BOOLEAN,
  canceled_at TIMESTAMP WITH TIME ZONE,
  current_period_started_at TIMESTAMP WITH TIME ZONE,
  previous_state TEXT,
  signup_payment_id TEXT,
  signup_revenue TEXT,
  delayed_cancel_at TIMESTAMP WITH TIME ZONE,
  coupon_code TEXT,
  snap_day TEXT,
  payment_collection_method TEXT,
  customer JSONB,
  product JSONB,
  credit_card JSONB,
  group JSONB,
  bank_account JSONB,
  payment_type TEXT,
  referral_code TEXT,
  next_product_id TEXT,
  next_product_handle TEXT,
  coupon_use_count INT,
  coupon_uses_allowed INT,
  reason_code TEXT,
  automatically_resume_at TIMESTAMP WITH TIME ZONE,
  coupon_codes TEXT[],
  offer_id TEXT,
  payer_id TEXT,
  current_billing_amount_in_cents INT,
  product_price_point_id TEXT,
  product_price_point_type TEXT,
  next_product_price_point_id TEXT,
  net_terms INT,
  stored_credential_transaction_id TEXT,
  reference TEXT,
  on_hold_at TIMESTAMP WITH TIME ZONE,
  prepaid_dunning BOOLEAN,
  coupons JSONB,
  dunning_communication_delay_enabled BOOLEAN,
  dunning_communication_delay_time_zone TEXT,
  receives_invoice_emails BOOLEAN,
  locale TEXT,
  currency TEXT,
  scheduled_cancellation_at TIMESTAMP WITH TIME ZONE,
  credit_balance_in_cents INT,
  prepayment_balance_in_cents INT,
  prepaid_configuration JSONB,
  self_service_page_token TEXT
)