Release Notes
November 2024
The following Lite connectors now support the Hybrid Deployment model:
Expand to see the full list
- 7shifts
- 360Learning
- Absorb LMS
- ActiveCampaign
- Ada
- Adobe Workfront
- Afterpay
- Aha!
- Akamai
- Akeneo
- Amazon Attribution
- Anvyl
- Appcues
- Appfigures
- Attio
- Aumni
- Auth0
- AvantLink
- Awin
- Backbone PLM
- BallotReady
- Bazaarvoice
- Bigin by Zoho CRM
- BillingPlatform
- Birdeye
- Bitly
- Bizzabo
- Boostr
- Brave Ads
- Brevo
- Brex
- Brightcove
- Buildium
- Buildkite
- Buzzsprout
- Calabrio
- Calendly
- CallRail
- Campaign Monitor
- Canny
- Canvas by Instructure
- Care Quality Commission
- Castor EDC
- Chameleon
- Chargebee Product Catalog 1.0
- Chargebee Product Catalog 2.0
- ChargeDesk
- ChartMogul
- Checkout.com
- Chorus
- Churnkey
- ChurnZero
- Cin7
- Cin7 Core
- CircleCI
- CJ Commission Detail
- Clari
- ClickUp
- Clockify
- Close
- Codefresh
- Collibra
- Column
- Concord
- Confluence
- Copper
- Criteo Retail Media
- Crossbeam
- crowd.dev
- Culture Amp
- Cvent
- Datadog
- dbt Cloud
- DCL Logistics
- Deputy
- Destini
- Dixa
- Docebo
- DoorLoop
- Drata
- Drift
- Drip
- Dropbox Sign
- DSV
- Duoplane
- EasyPost
- eBay
- Electronic Tenant Solutions
- Employment Hero
- Eventbrite
- Eventsforce
- Everhour
- ExpenseIn
- Expensify
- EZOfficeInventory
- Factbird
- Factorial
- Fillout
- FireHydrant
- Flexport
- Float
- Fone Dynamics
- Forj Community
- Fountain
- Freightview
- FreshBooks
- Freshchat
- Freshdesk Contact Center
- FreshTeam
- Friendbuy
- FullStory
- Gainsight Product Experience
- Gem
- Genesys
- GetFeedback
- GitLab
- Gladly
- GlobalMeet
- Gmail
- GoCardless
- Google Business Profile
- Google Calendar
- Gorgias
- GRIN
- Guru
- HappyFox
- Harvest
- Helpshift
- HiBob
- Hopin
- iLevel
- Incident.io
- Infobip
- Insightly
- Integral Ad Science
- Integrate
- Ironclad
- ironSource
- Ivanti
- Jira Align
- Jotform
- JustCall
- Kandji
- Katana
- Kevel
- KeyPay
- Khoros Care
- Kisi
- Kissmetrics
- Klarna
- Lattice
- LaunchDarkly
- LearnUpon
- Lemlist
- Lessonly
- Liftoff
- Linear
- LinkSquares
- LiveChat Partner
- Lob
- Looker
- Loop
- Loopio
- Luma
- Mailgun
- Mambu
- Matomo
- Maxio Chargify
- Maxio SaaSOptics
- Medallia Agile Research
- Megaphone
- Mention
- Microsoft Entra ID
- Missive
- Mixmax
- MNTN
- Mode
- Moloco
- Mux
- myosh
- Namely
- Navan
- Notion
- Okendo
- Ometria
- ON24
- OnceHub
- Open Data DC
- Open Exchange Rates
- Opsgenie
- Oracle Moat Analytics
- Orbit
- Ordway
- Ortto
- PagerDuty
- Papershift
- Partnerize
- PartnerStack Vendor
- Paychex
- Persona
- Personio
- Picqer
- Pingdom
- Pinpoint
- Pinterest Organic
- Pivotal Tracker
- Piwik PRO
- Planful
- Planhat
- Playvox
- Playvox Workforce Management
- Podio
- PostHog
- Postmark
- PowerReviews Enterprise
- Prive
- Procore
- Productboard
- Productive
- Proofpoint Security Awareness
- Qualaroo
- Quora Ads
- Rakuten Advertising
- Ramp
- Rarible
- ReBound Returns
- ReferralHero
- Resource Management by Smartsheet
- RetailNext
- Retently
- Revel Systems
- RevenueCat
- REVIEWS.io
- RevOps
- RevX
- Ricochet360
- Ringover
- Rippling
- Rithum
- Rocketlane
- Rollbar
- Rootly
- RTB House
- Ruddr
- SafetyCulture
- Salsify
- Samsara
- SCORM
- Security Journey
- ServiceTitan
- Sharetribe
- ShipHero
- ShipNetwork
- ShipStation
- Shopware
- Short.io
- Shortcut
- Sigma Computing
- Simplecast
- Simplesat
- SISTRIX
- Skilljar
- SkillsTX
- SkuVault
- Smadex
- SmartHR
- SmartRecruiters
- Smartwaiver
- Snyk
- SolarWinds Service Desk
- SonarQube
- SparkPost
- Splash
- Split
- Squarespace
- StackAdapt
- Standard Metrics
- StarRez
- Statuspage
- Stylight
- Subscript
- Survicate
- Swoogo
- Tableau
- Talkwalker
- Teads
- Teamtailor
- Teamwork
- Tempo
- TestRail
- Thinkific
- Ticket Tailor
- Toggl Track
- Transcend
- Trelica
- Trello
- Tremendous
- Triple Whale
- Trisolute
- Tymeshift
- Udemy Business
- UKG Pro
- Upland Software
- UpPromote
- Veeqo
- Vitally
- Vonage Contact Center
- VTS
- VWO
- Webconnex
- When I Work
- Wherefour
- WooCommerce
- WordPress
- Workable
- Workday Strategic Sourcing
- WorkRamp
- Wrike
- Xandr
- Xray
- Yahoo Search Ads on Yahoo Japan
- YouGov Sport
- Younium
- Zenefits
- Zingtree
- Zoho Books
- Zoho Campaigns
- Zoho Desk
- Zonka Feedback
- Zoom
June 2024
Effective June 6, 2024 we use a new June 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.
These schema changes are required to minimize the occurrence of long syncs.
97 total changes • 81 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
CATEGORY | |||||
| table | Discontinued Table | CATEGORY | Data now available in the OPPORTUNITY_CATEGORY, PROJECT_CATEGORY, and TASK_CATEGORY tables. | ||
CONTACT_DATE | |||||
| column | Discontinued Column | object_id 🔑 | No longer primary key. | ||
| column | Discontinued Column | object_name | |||
| column | Primary Key Change | contact_id 🔑 | New primary key. | ||
CONTACT_EMAIL | |||||
| table | Discontinued Table | CONTACT_EMAIL | Data now available in the CONTACT_LINK table. | ||
CONTACT_EVENT | |||||
| table | Discontinued Table | CONTACT_EVENT | Data now available in the CONTACT_LINK table. | ||
CONTACT_FILE_ATTACHMENT | |||||
| column | Discontinued Column | object_id | |||
| column | Discontinued Column | object_type | |||
| column | New Column | contact_id | |||
CONTACT_NOTE | |||||
| table | Discontinued Table | CONTACT_NOTE | Data now available in the CONTACT_LINK table. | ||
CONTACT_TAG | |||||
| column | Discontinued Column | object_id 🔑 | No longer primary key. | ||
| column | Discontinued Column | object_name | |||
| column | Primary Key Change | contact_id 🔑 | New primary key. | ||
CONTACT_TASK | |||||
| table | Discontinued Table | CONTACT_TASK | Data now available in the CONTACT_LINK table. | ||
CUSTOM_OBJECT_RECORD | |||||
| column | Discontinued Column | custom_object_name | |||
DATES | |||||
| table | Discontinued Table | DATES | Data now available in the CONTACT_DATE and ORGANISATION_DATE tables. | ||
EMAIL_FILE_ATTACHMENT | |||||
| column | Discontinued Column | object_id | |||
| column | Discontinued Column | object_type | |||
| column | New Column | email_id | |||
EMAIL_TAG | |||||
| column | Discontinued Column | object_id 🔑 | No longer primary key. | ||
| column | Discontinued Column | object_name | |||
| column | Primary Key Change | email_id 🔑 | New primary key. | ||
FILE_ATTACHMENT | |||||
| table | Discontinued Table | FILE_ATTACHMENT | Data now available in the ORGANISATION_FILE_ATTACHMENT, OPPORTUNITY_FILE_ATTACHMENT, LEAD_FILE_ATTACHMENT, CONTACT_FILE_ATTACHMENT, EMAIL_FILE_ATTACHMENT, and NOTE_FILE_ATTACHMENT tables. | ||
LEAD_EMAIL | |||||
| table | Discontinued Table | LEAD_EMAIL | Data now available in the LEAD_LINK table. | ||
LEAD_EVENT | |||||
| table | Discontinued Table | LEAD_EVENT | Data now available in the LEAD_LINK table. | ||
LEAD_FILE_ATTACHMENT | |||||
| column | Discontinued Column | object_id | |||
| column | Discontinued Column | object_type | |||
| column | New Column | lead_id | |||
LEAD_NOTE | |||||
| table | Discontinued Table | LEAD_NOTE | Data now available in the LEAD_LINK table. | ||
LEAD_SOURCE | |||||
| column | Discontinued Column | lead_source | |||
| column | New Column | name | |||
LEAD_STATUS | |||||
| column | Discontinued Column | lead_status | |||
| column | New Column | status | |||
LEAD_TAG | |||||
| column | Discontinued Column | object_id 🔑 | No longer primary key. | ||
| column | Discontinued Column | object_name | |||
| column | Primary Key Change | lead_id 🔑 | New primary key. | ||
LEAD_TASK | |||||
| table | Discontinued Table | LEAD_TASK | Data now available in the LEAD_LINK table. | ||
LINK | |||||
| table | Discontinued Table | LINK | Data now available in the ORGANISATION_LINK, EVENT_LINK, NOTE_LINK, PROJECT_LINK, TASK_LINK, OPPORTUNITY_LINK, EMAIL_LINK, LEAD_LINK, and CONTACT_LINK tables. | ||
NOTE_COMMENT | |||||
| column | Discontinued Column | id 🔑 | No longer primary key. | ||
| column | Primary Key Change | owner_user_id | owner_user_id 🔑 | Added to primary key. | |
| column | Primary Key Change | comment_id 🔑 | New primary key. | ||
NOTE_FILE_ATTACHMENT | |||||
| column | Discontinued Column | object_id | |||
| column | Discontinued Column | object_type | |||
| column | New Column | note_id | |||
OPPORTUNITY_CATEGORY | |||||
| column | Discontinued Column | category_name | |||
| column | Discontinued Column | object_name | |||
| column | New Column | name | |||
OPPORTUNITY_EMAIL | |||||
| table | Discontinued Table | OPPORTUNITY_EMAIL | Data now available in the OPPORTUNITY_LINK table. | ||
OPPORTUNITY_EVENT | |||||
| table | Discontinued Table | OPPORTUNITY_EVENT | Data now available in the OPPORTUNITY_LINK table. | ||
OPPORTUNITY_FILE_ATTACHMENT | |||||
| column | Discontinued Column | object_id | |||
| column | Discontinued Column | object_type | |||
| column | New Column | opportunity_id | |||
OPPORTUNITY_NOTE | |||||
| table | Discontinued Table | OPPORTUNITY_NOTE | Data now available in the OPPORTUNITY_LINK table. | ||
OPPORTUNITY_PRODUCT_ITEM | |||||
| table | Discontinued Table | OPPORTUNITY_PRODUCT_ITEM | Data now available in the OPPORTUNITY_ITEM table. | ||
OPPORTUNITY_STATE_REASON | |||||
| table | Discontinued Table | OPPORTUNITY_STATE_REASON | Data now available in the OPPORTUNITY_STATE_HISTORY table. | ||
OPPORTUNITY_TAG | |||||
| column | Discontinued Column | object_name | |||
OPPORTUNITY_TASK | |||||
| table | Discontinued Table | OPPORTUNITY_TASK | Data now available in the OPPORTUNITY_LINK table. | ||
ORGANISATION_DATE | |||||
| column | Discontinued Column | object_id 🔑 | No longer primary key. | ||
| column | Discontinued Column | object_name | |||
| column | Primary Key Change | organisation_id 🔑 | New primary key. | ||
ORGANISATION_EVENT | |||||
| table | Discontinued Table | ORGANISATION_EVENT | Data now available in the ORGANISATION_LINK table. | ||
ORGANISATION_FILE_ATTACHMENT | |||||
| column | Discontinued Column | object_id | |||
| column | Discontinued Column | object_type | |||
| column | New Column | organisation_id | |||
ORGANISATION_NOTE | |||||
| table | Discontinued Table | ORGANISATION_NOTE | Data now available in the ORGANISATION_LINK table. | ||
ORGANISATION_TAG | |||||
| column | Discontinued Column | object_id 🔑 | No longer primary key. | ||
| column | Discontinued Column | object_name | |||
| column | Primary Key Change | organisation_id 🔑 | New primary key. | ||
ORGANISATION_TASK | |||||
| table | Discontinued Table | ORGANISATION_TASK | Data now available in the ORGANISATION_LINK table. | ||
PIPELINE_STAGE | |||||
| column | Primary Key Change | pipeline_id 🔑 | pipeline_id | No longer primary key. | |
PRODUCT | |||||
| column | Discontinued Column | product_code | |||
| column | Discontinued Column | product_family | |||
| column | Discontinued Column | product_image_url | |||
| column | Discontinued Column | product_name | |||
| column | Discontinued Column | product_sku | |||
| column | New Column | code | |||
| column | New Column | family | |||
| column | New Column | image_url | |||
| column | New Column | name | |||
| column | New Column | sku | |||
PRODUCT_PRICE_BOOK_ENTRY | |||||
| table | Discontinued Table | PRODUCT_PRICE_BOOK_ENTRY | Data now available in the PRODUCT_LINK table. | ||
PROJECT_CATEGORY | |||||
| column | Discontinued Column | category_name | |||
| column | Discontinued Column | object_name | |||
| column | New Column | name | |||
PROJECT_TAG | |||||
| column | Discontinued Column | object_id 🔑 | No longer primary key. | ||
| column | Discontinued Column | object_name | |||
| column | Primary Key Change | project_id 🔑 | New primary key. | ||
PROSPECT_TAG | |||||
| column | Discontinued Column | object_id 🔑 | No longer primary key. | ||
| column | Discontinued Column | object_name | |||
| column | Primary Key Change | prospect_id 🔑 | New primary key. | ||
TAGS | |||||
| table | Discontinued Table | TAGS | Data now available in the ORGANISATION_TAG, PROJECT_TAG, OPPORTUNITY_TAG, EMAIL_TAG, LEAD_TAG, CONTACT_TAG, PROSPECT_TAG, and TICKET_TAG tables. | ||
TASK_CATEGORY | |||||
| column | Discontinued Column | category_name | |||
| column | Discontinued Column | object_name | |||
| column | New Column | name | |||
TICKET_TAG | |||||
| column | Discontinued Column | object_id 🔑 | No longer primary key. | ||
| column | Discontinued Column | object_name | |||
| column | Primary Key Change | ticket_id 🔑 | New primary key. | ||
May 2024
We now incrementally sync the following tables and their child tables:
CONTACTCONTACT_FILE_ATTACHMENTCUSTOM_OBJECT_RECORDEMAILEMAIL_FILE_ATTACHMENTEVENTFORUMFORUM_CATEGORYFORUM_COMMENTFORUM_POSTLEADLEAD_FILE_ATTACHMENTNOTENOTE_COMMENTNOTE_FILE_ATTACHMENTMILESTONEOPPORTUNITYOPPORTUNITY_FILE_ATTACHMENTOPPORTUNITY_ITEMORGANISATIONORGANISATION_FILE_ATTACHMENTPRICE_BOOKPRICE_BOOK_ENTRYPRODUCTPROJECTPROSPECTQUOTEQUOTE_ITEMTASKTICKETUSERS
October 2023
Lite connectors are now available for the following sources: