Browse sources$ls -a sources
Logo of netsuite
NetSuite
Elevate financial operations with your customers’ NetSuite data
Sync your customers' dataFiber pulls data from your customers' NetSuite accounts into your database or cloud storage. Skip months of integration work and begin syncing in minutes.
Logo of netsuite
Logo of netsuite
Logo of netsuite
Logo of netsuite
Logo of netsuite
Logo of netsuite
Logo of netsuite
Logo of netsuite
Logo of netsuite
Logo of netsuite
Fiber
postgres-prod
netsuite_accounts
netsuite_charges
netsuite_customers
Your customers' NetSuite accounts
Your production database
Meet your new integration toolkit: SQLReplace calls to the NetSuite API with an interface you already use. Access the data you need straight from your database.
-- Fetch all the Invoices belonging to the NetSuite
-- store of a particular user.

SELECT *
FROM fiber.netsuite_invoice
WHERE store_id = '{user.store_id}'
-- Fetch all the Invoices belonging to the NetSuite
-- store of a particular user.

SELECT *
FROM fiber.netsuite_invoice
WHERE store_id = '{user.store_id}'
Code
CREATE TABLE fiber.netsuite_invoice (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
store_id TEXT,
account JSONB,
accounting_book_detail JSONB,
amount_paid DOUBLE PRECISION,
amount_remaining DOUBLE PRECISION,
amount_unbilled DOUBLE PRECISION,
amount_remaining_total_box DOUBLE PRECISION,
approval_status JSONB,
bill_address TEXT,
bill_override TEXT,
bill_phone TEXT,
bill_state TEXT,
bill_zip TEXT,
billing_account JSONB,
department JSONB,
discount_amount DOUBLE PRECISION,
discount_total DOUBLE PRECISION,
discount_rate DOUBLE PRECISION,
email TEXT,
end_date TEXT,
estimate INT,
exchange_rate DOUBLE PRECISION,
installment JSONB,
item JSONB,
item_cost DOUBLE PRECISION,
last_modified_date TEXT,
partner JSONB,
posting_period JSONB,
prev_date TEXT,
prev_partner JSONB,
sales_channel JSONB,
ship_address TEXT,
ship_date TEXT,
start_date TEXT,
status TEXT
)
CREATE TABLE fiber.netsuite_invoice (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
store_id TEXT,
account JSONB,
accounting_book_detail JSONB,
amount_paid DOUBLE PRECISION,
amount_remaining DOUBLE PRECISION,
amount_unbilled DOUBLE PRECISION,
amount_remaining_total_box DOUBLE PRECISION,
approval_status JSONB,
bill_address TEXT,
bill_override TEXT,
bill_phone TEXT,
bill_state TEXT,
bill_zip TEXT,
billing_account JSONB,
department JSONB,
discount_amount DOUBLE PRECISION,
discount_total DOUBLE PRECISION,
discount_rate DOUBLE PRECISION,
email TEXT,
end_date TEXT,
estimate INT,
exchange_rate DOUBLE PRECISION,
installment JSONB,
item JSONB,
item_cost DOUBLE PRECISION,
last_modified_date TEXT,
partner JSONB,
posting_period JSONB,
prev_date TEXT,
prev_partner JSONB,
sales_channel JSONB,
ship_address TEXT,
ship_date TEXT,
start_date TEXT,
status TEXT
)
Model definition
About this source
Logo of netsuite
NetSuiteIntegrated cloud business software suite, including business accounting and ERP.netsuite.com  ↗
Available resources
    Accounts
    Charges
    Customers
    Deposits
    Employees
    Estimates
    Invoices
    Jobs
    Price Plans
    Purchases
    Subscriptions
    Usages
    Vendors
Missing a resource? We will build it for you.
Similar integrations
OAuth
Need help with OAuth for NetSuite?Handshake ↗ is a Next.js app boilerplate that handles your OAuth with NetSuite and over 200 other APIs. Setup and deploy within minutes.
Logo of netsuiteIntegrate NetSuite using Fiber Fiber makes it easy to access third-party data from NetSuite accounts. Get started in just a few minutes.