FreshBooks

Get started with the FreshBooks connector!

Description

FreshBooks is a software company that provides cloud-based accounting software for small and medium-sized businesses.

Connector Details

NameValue
PlatformFreshBooks
Auth TypeOAuth
DirectionRead

Supported Data

See the table below for the list of data you can read with the FreshBooks connector.

Table NameFields
accounts
business
bills
amount, attachment, bill_number, bill_payments, created_at, currency_code, due_date, due_offset_days, id, issue_date, language, lines, outstanding, overall_category, overall_description, paid, status, tax_amount, total_amount, updated_at, vis_state
business_id
business_id
clients
accounting_systemid, allow_email_include_pdf, allow_late_fees, allow_late_notifications, bus_phone, company_industry, company_size, currency_code, direct_link_token, email, exceeds_client_limit, fax, fname, has_retainer, home_phone, id, language, last_activity, last_login, level, lname, mob_phone, note, notified, num_logins, organization, p_city, p_code, p_country, p_province, p_street, p_street2, pref_email, pref_gmail, retainer_id, role, s_city, s_code, s_country, s_province, s_street, s_street2, signup_date, statement_token, subdomain, updated, userid, username, uuid, vat_name, vat_number, vis_state
expenses
account_name, accountid, accounting_systemid, amount, background_jobid, bank_name, bill_matches, billable, categoryid, clientid, compounded_tax, converse_projectid, date, expenseid, ext_accountid, ext_invoiceid, ext_systemid, from_bulk_import, has_receipt, id, include_receipt, invoiceid, is_cogs, isduplicate, markup_percent, modern_projectid, notes, potential_bill_payment, profileid, projectid, staffid, status, taxAmount1, taxAmount2, taxName1, taxName2, taxPercent1, taxPercent2, transactionid, updated, vendor, version, vis_state
invoices
accountid, accounting_systemid, address, amount, auto_bill, autobill_status, basecampid, city, code, country, create_date, created_at, currency_code, current_organization, customerid, date_paid, deposit_amount, deposit_percetage, deposit_status, description, discount_description, discount_total, discount_value, display_status, dispute_status, due_date, due_offset_days, estimateid, ext_archive, fname, fulfillment_date, generation_data, gmail, id, invoice_number, invoiceid, language, last_order_status, lname, net_paid_amount, notes, organization, outstanding, paid, ownerid, parent, payment_details, payment_status, po_number, province, return_uri, sentid, show_attachments, status, street, street2, template, terms, updated, uuid, v3_status, vat_name, vat_number, version, vis_state
journal_entries
account, accounting_systemid, balance, credit, debit, description, detail_type, detailid, entry, id, name, sub_account, user_entered_date
projects
id, title, description, due_date, client_id, internal, budget, fixed_price, rate, billing_method, project_type, project_manager_id, active, complete, sample, created_at, updated_at, logged_duration, services, billed_amount, billed_status, retainer_id, expense_markup, service_estimate_type, group_id
vendors
account_number, city, country, created_at, currency_code, is_1099, language, note, outstanding_balance, overdue_balance, phone, postal_code, primary_contact_email, primary_contact_first_name, primary_contact_last_name, province, street, street2, tax_defaults, updated_at, vendor_name, vendorid, vis_state, website