Browse sources$ls -a sources
Logo of quickbooks
Quickbooks
Understand your customers' financials with Quickbooks
Sync your customers' dataFiber pulls data from your customers' Quickbooks accounts into your database or cloud storage. Skip months of integration work and begin syncing in minutes.
Logo of quickbooks
Logo of quickbooks
Logo of quickbooks
Logo of quickbooks
Logo of quickbooks
Logo of quickbooks
Logo of quickbooks
Logo of quickbooks
Logo of quickbooks
Logo of quickbooks
Fiber
postgres-prod
quickbooks_accounts
quickbooks_bill_payments
quickbooks_bills
Your customers' Quickbooks accounts
Your production database
Meet your new integration toolkit: SQLReplace calls to the Quickbooks API with an interface you already use. Access the data you need straight from your database.
-- Fetch all the Accounts belonging to the Quickbooks
-- account of a particular user.

SELECT *
FROM fiber.quickbooks_account
WHERE account_id = '{user.quickbooks_id}'
-- Fetch all the Accounts belonging to the Quickbooks
-- account of a particular user.

SELECT *
FROM fiber.quickbooks_account
WHERE account_id = '{user.quickbooks_id}'
Code
CREATE TABLE fiber.quickbooks_account (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
current_balance_with_sub_accounts TEXT,
acct_num TEXT,
account_sub_type TEXT,
classification TEXT,
currency_ref JSONB,
name TEXT,
description TEXT,
fully_qualified_name TEXT,
id TEXT,
account_type TEXT,
meta_data JSONB,
current_balance TEXT,
active BOOLEAN,
domain TEXT,
sub_account BOOLEAN,
parent_ref JSONB,
sync_token TEXT,
account_alias TEXT,
txn_location_type TEXT,
tax_code_ref JSONB
)
CREATE TABLE fiber.quickbooks_account (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
current_balance_with_sub_accounts TEXT,
acct_num TEXT,
account_sub_type TEXT,
classification TEXT,
currency_ref JSONB,
name TEXT,
description TEXT,
fully_qualified_name TEXT,
id TEXT,
account_type TEXT,
meta_data JSONB,
current_balance TEXT,
active BOOLEAN,
domain TEXT,
sub_account BOOLEAN,
parent_ref JSONB,
sync_token TEXT,
account_alias TEXT,
txn_location_type TEXT,
tax_code_ref JSONB
)
Model definition
About this source
Logo of Quickbooks
QuickbooksAccounting software package for small and medium-sized businesses.quickbooks.com  ↗
Available resources
Missing a resource? We will build it for you.
Similar sources
OAuth
Need help with OAuth for Quickbooks?Handshake ↗ is a Next.js app boilerplate that handles your OAuth with Quickbooks and over 200 other APIs. Setup and deploy within minutes.
Logo of quickbooksIntegrate Quickbooks using Fiber Fiber makes it easy to access third-party data from Quickbooks accounts. Get started in just a few minutes.