Connector Improvement: Add Support for Missing Intercom Tables and Fields
Answered
While using the Intercom connector, we noticed several important tables and columns are not currently supported. These fields are critical for conversation metadata, tags, admin info, contacts, ratings, statistics, and reporting, including both global and EU datasets.
Missing Table:
-
CONVERSATION_TAGS(TAG_NAME,TAG_LABELS)
Missing Columns:
-
Admins:
ODS_INTERCOM_ADMINS.TYPE,AWAY_MODE_REASSIGN,ODS_INTERCOM_EU_ADMINS.TYPE,AWAY_MODE_REASSIGN -
Contacts:
TYPE,TAGS_TYPE -
Conversations (Global & EU):
TYPE,SOURCE_AUTHOR_NAME,SOURCE_AUTHOR_EMAIL,SOURCE_REDACTED,SOURCE_ATTACHMENTS,CONTACTS_TYPE,CONTACTS_CONTACTS,ADMIN_ASSIGNEE_ID,TAGS_TYPE,TAGS_TAGS,SLA_APPLIED,STATISTICS_TYPE,CONVERSATION_RATING_RATING,CONVERSATION_RATING_CONTACT_TYPE,CONVERSATION_RATING_CONTACT_ID,CONVERSATION_RATING_TEAMMATE_TYPE,TEAMMATES_TYPE,TEAMMATES_ADMINS,TOPICS_TYPE,TOPICS_TOTAL_COUNT,EML_DOMAIN,HASHED_EMAIL,SOURCE_AUTHOR_HASHED_EMAIL -
Teams:
ODS_INTERCOM_TEAMS.ADMIN_IDS,ODS_INTERCOM_EU_TEAMS.ADMIN_IDS
Business Impact:
These missing tables and fields prevent complete reporting, conversation analytics, tag routing, SLA tracking, and EU/Global dataset parity.
Request:
Please add support for all missing tables and columns to ensure full Intercom data coverage.
-
Official comment
Hi Oz,
This connector improvement request is noted and added to our feature improvements backlog. It is valuable to highlight missing tables and fields for more complete Intercom coverage.
Updates and progress on this topic will be shared on this thread as we review and prioritize the improvements.
Thanks,
Unni -
We also require a few of these columns and are stuck without them. notably SLA_APPLIED and then Case Subject which i don't see listed.
Disappointed that we can't at least get the full JSON blob delivered and then we can parse it if needed.
Please sign in to leave a comment.
Comments
2 comments