Connectors
Bexio
Connectors
Bexio
Description
Bexio offers cloud-based business and accounting software solutions to manage their customers, write quotes and invoices, and more.
Connector Details
| Name | Value |
|---|---|
| Platform | Bexio |
| Auth Type | OAuth |
| Direction | Bidirectional |
Supported Data
See the table below for the list of data you can read with the Bexio connector.
| Table Name | Fields |
|---|---|
| contacts | id, nr, contact_type_id, name_1, name_2, salutation_id, salutation_form, title_id, birthday, address, postcode, city, country_id, mail, mail_second, phone_fixed, phone_fixed_second, phone_mobile, fax, url, skype_name, remarks, language_id, is_lead, contact_group_ids, contact_branch_ids, user_id, owner_id, updated_at |
| currencies | id, name, round_factor |
| invoice | id, document_nr, title, contact_id, contact_sub_id, user_id, project_id, logopaper_id, language_id, bank_account_id, currency_id, payment_type_id, header, footer, total_gross, total_net, total_taxes, total_received_payments, total_credit_vouchers, total_remaining_payments, total, total_rounding_difference, mwst_type, mwst_is_net, show_position_taxes, is_valid_from, is_valid_to, contact_address, kb_item_status_id, reference, api_reference, viewed_by_client_at, updated_at, esr_id, qr_invoice_id, template_slug, taxes, network_link |
| item_positions | id, order_id, type, amount, unit_id, account_id, unit_name, tax_id, tax_value, text, unit_price, discount_in_percent, position_total, pos, internal_pos, parent_id, is_optional, article_id |
| items | id, user_id, article_type_id, contact_id, deliverer_code, deliverer_name, deliverer_description, intern_code, intern_name, intern_description, purchase_price, sale_price, purchase_total, sale_total, currency_id, tax_income_id, tax_id, tax_expense_id, unit_id, is_stock, stock_id, stock_place_id, stock_nr, stock_min_nr, stock_reserved_nr, stock_available_nr, stock_picked_nr, stock_disposed_nr, stock_ordered_nr, width, height, weight, volume, html_text, remarks, delivery_price, article_group_id |
| orders | id, document_nr, title, contact_id, contact_sub_id, user_id, project_id, logopaper_id, language_id, bank_account_id, currency_id, payment_type_id, header, footer, total_gross, total_net, total_taxes, total, total_rounding_difference, mwst_type, mwst_is_net, show_position_taxes, is_valid_from, contact_address, delivery_address_type, delivery_address, kb_item_status_id, is_recurring, api_reference, viewed_by_client_at, updated_at, template_slug, taxes, network_link |
| purchase_orders | id, document_nr, kb_payment_template_id, payment_type_id, title, contact_id, contact_sub_id, template_slug, user_id, project_id, logopaper_id, language, language_id, bank_account_id, currency, currency_id, header, footer, total_rounding_difference, mwst_type, mwst_is_net, is_compact_view, show_position_taxes, salesman_user_id, is_valid_from, is_valid_to, delivery_address_type, contact_address_manual, delivery_address_manual, nb_decimals_amount, nb_decimals_price, kb_item_status_id, terms_of_payment_text, reference, api_reference, mail, viewed_by_client_at, is_valid_until, created_at, updated_at, custom_translations, date_format |
| stock_locations | id, name |