Connectors
Microsoft SQL
Connectors
Microsoft SQL
Description
Microsoft is a software corporation that develops, manufactures, licenses, supports, and sells a range of software products and services.
Connector Details
| Name | Value |
|---|---|
| Platform | Microsoft SQL |
| Auth Type | API Keys |
| Direction | Bidirectional |
Supported Data
See the table below for the list of data you can read with the Microsoft SQL connector.
| Table Name | Fields |
|---|---|
| dbo-appointments | id, summary, description, customer_id, created_at, updated_at, start_at, end_at, duration, location, ticket_id, appointment_location_type, start_at_label, all_day, ticket, customer, do_not_email |
| dbo-assets | id, name, customer_id, contact_id, created_at, updated_at, properties, asset_type, asset_serial, external_rmm_link, rmm_links, has_live_chat, snmp_enabled, device_info, rmm_store, address, customer |
| dbo-contacts | id, name, address1, address2, city, state, zip, email, phone, mobile, latitude, longitude, customer_id, account_id, notes, created_at, updated_at, vendor_id, opt_out, extension, processed_phone, processed_mobile, ticket_matching_emails, properties |
| dbo-contracts | id, account_id, customer_id, name, contract_amount, start_date, end_date, description, created_at, updated_at, status, likelihood, apply_to_all, primary_contact, sla_id |
| dbo-customers | id, firstname, lastname, fullname, business_name, email, phone, mobile, created_at, updated_at, pdf_url, address, address_2, city, state, zip, latitude, longitude, notes, get_sms, opt_out, disabled, no_email, location_name, location_id, online_profile_url, tax_rate_id, notification_email, invoice_cc_emails, invoice_term_id, referred_by, ref_customer_id, business_and_full_name, business_then_name, contacts, properties |
| dbo-estimates | id, customer_business_then_name, number, status, created_at, updated_at, customer_id, date, subtotal, total, tax, ticket_id, pdf_url, location_id, invoice_id, employee |
| dbo-items | id, requestedon, ticket_num, parturl, shipping, deststore, orderedby, orderedon, trackingnum, ticketnum, receivedon, price, description, account_id, destination_location_id, from_location_id, from_name, received_at, user_id, created_at, updated_at, due_at, ticket_id, logistic_state, product_id, quantity, round_trip, trip_leg, retail_cents, taxable, converted, notes, refurb_id, invoice_id |
| dbo-portal_users | account_id, portal_group_id, id, email, disabled, customer_id, contact_id, created_at, updated_at, second_factor_attempts_count, encrypted_otp_secret_key, otp_recovery_secret_key, encrypted_otp_secret_key_iv, encrypted_otp_secret_key_salt, direct_otp, direct_otp_sent_at, totp_timestamp, mobile, confirmed_mobile, second_factor_recovery_attempts_count, require_mfa |
| dbo-products | id, price_cost, price_retail, condition, description, maintain_stock, name, quantity, warranty, sort_order, reorder_at, disabled, taxable, product_category, category_path, upc_code, discount_percent, warranty_template_id, qb_item_id, desired_stock_level, price_wholesale, notes, tax_rate_id, physical_location, serialized, vendor_ids, long_description, location_quantities, photos |
| dbo-purchase_orders | id, account_subdomain, created_at, updated_at, expected_date, number, other, shipping, shipping_notes, status, total, user_id, vendor_id, location_id, due_date, paid_date, delivery_tracking, vendor, location, line_items |