Microsoft teams

Tables in the Microsoft teams connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	conversation_posts	12
2	group_members	11
3	channel	6
4	groups	32				API Reference
5	conversations	7				API Reference
6	group_owners	12
7	team_device_usage_report	12
8	users	11				API Reference
9	channel_messages	20
10	channel_tabs	8
11	channel_message_replies	20
12	channels	5				API Reference
13	channel_members	6
14	conversation_threads	9
15	team_drives	8

Table: conversation_posts

No	Column Name	Type	Notes
1	created_date_time	VARCHAR
2	thread_id	VARCHAR
3	change_key	VARCHAR
4	has_attachments	BOOLEAN
5	sender	VARCHAR
6	conversation_id	VARCHAR
7	received_date_time	VARCHAR
8	from	VARCHAR
9	id	VARCHAR
10	categories	VARCHAR
11	body	VARCHAR
12	last_modified_date_time	VARCHAR

Table: group_members

No	Column Name	Type	Notes
1	business_phones	VARCHAR
2	user_principal_name	VARCHAR
3	mail	VARCHAR
4	mobile_phone	VARCHAR
5	surname	VARCHAR
6	office_location	VARCHAR
7	id	VARCHAR
8	display_name	VARCHAR
9	given_name	VARCHAR
10	job_title	VARCHAR
11	preferred_language	VARCHAR

Table: channel

No	Column Name	Type	Notes
1	web_url	VARCHAR
2	roles	VARCHAR
3	description	VARCHAR
4	id	VARCHAR
5	display_name	VARCHAR
6	email	VARCHAR

Table: groups

No	Column Name	Type	Notes
1	proxy_addresses	VARCHAR
2	onPremises_domain_name	VARCHAR
3	mail	VARCHAR
4	membership_rule_processing_state	VARCHAR
5	group_types	VARCHAR
6	mail_nickname	VARCHAR
7	description	VARCHAR
8	on_premises_net_bios_name	VARCHAR
9	on_premises_sam_account_name	VARCHAR
10	preferred_data_location	VARCHAR
11	created_date_time	VARCHAR
12	mail_enabled	BOOLEAN
13	renewed_date_time	VARCHAR
14	resource_behavior_options	VARCHAR
15	on_premises_last_sync_date_time	VARCHAR
16	creation_options	VARCHAR
17	membership_rule	VARCHAR
18	on_premises_security_identifier	VARCHAR
19	theme	VARCHAR
20	id	VARCHAR
21	is_assignable_to_role	BOOLEAN
22	preferred_language	VARCHAR
23	on_premises_sync_enabled	BOOLEAN
24	security_enabled	BOOLEAN
25	visibility	VARCHAR
26	on_premises_provisioning_errors	VARCHAR
27	classification	VARCHAR
28	display_name	VARCHAR
29	expiration_date_time	VARCHAR
30	deleted_date_time	VARCHAR
31	security_edentifier	VARCHAR
32	resource_provisioning_options	VARCHAR

Table: conversations

No	Column Name	Type	Notes
1	preview	VARCHAR
2	has_attachments	BOOLEAN
3	group_id	VARCHAR
4	last_delivered_date_time	VARCHAR
5	topic	VARCHAR
6	id	VARCHAR
7	unique_senders	VARCHAR

Table: group_owners

No	Column Name	Type	Notes
1	business_phones	VARCHAR
2	user_principal_name	VARCHAR
3	mail	VARCHAR
4	group_id	VARCHAR
5	mobile_phone	VARCHAR
6	surname	VARCHAR
7	office_location	VARCHAR
8	id	VARCHAR
9	display_name	VARCHAR
10	given_name	VARCHAR
11	job_title	VARCHAR
12	preferred_language	VARCHAR

Table: team_device_usage_report

No	Column Name	Type	Notes
1	used_mac	VARCHAR
2	used_windows	VARCHAR
3	user_principal_name	VARCHAR
4	used_windows_phone	VARCHAR
5	used_android_phone	VARCHAR
6	deleted_date	VARCHAR
7	is_deleted	VARCHAR
8	report_refresh_date	VARCHAR
9	report_period	VARCHAR
10	last_activity_date	VARCHAR
11	used_web	VARCHAR
12	used_i_os	VARCHAR

Table: users

No	Column Name	Type	Notes
1	business_phones	VARCHAR
2	user_principal_name	VARCHAR
3	mail	VARCHAR
4	mobile_phone	VARCHAR
5	surname	VARCHAR
6	office_location	VARCHAR
7	id	VARCHAR
8	display_name	VARCHAR
9	given_name	VARCHAR
10	job_title	VARCHAR
11	preferred_language	VARCHAR

Table: channel_messages

No	Column Name	Type	Notes
1	summary	VARCHAR
2	channel_identity	VARCHAR
3	lastModified_date_time	VARCHAR
4	attachments	VARCHAR
5	subject	VARCHAR
6	importance	VARCHAR
7	message_type	VARCHAR
8	locale	VARCHAR
9	body	VARCHAR
10	reply_to_id	VARCHAR
11	chat_id	VARCHAR
12	created_date_time	VARCHAR
13	web_url	VARCHAR
14	deleted_date_time	VARCHAR
15	mentions	VARCHAR
16	etag	VARCHAR
17	policy_violation	VARCHAR
18	from	VARCHAR
19	reactions	VARCHAR
20	id	VARCHAR

Table: channel_tabs

No	Column Name	Type	Notes
1	web_url	VARCHAR
2	group_id	VARCHAR
3	configuration	VARCHAR
4	sort_order_index	VARCHAR
5	id	VARCHAR
6	display_name	VARCHAR
7	channel_id	VARCHAR
8	teams_app	VARCHAR

Table: channel_message_replies

No	Column Name	Type	Notes
1	summary	VARCHAR
2	channel_identity	VARCHAR
3	attachments	VARCHAR
4	subject	VARCHAR
5	importance	VARCHAR
6	message_type	VARCHAR
7	locale	VARCHAR
8	body	VARCHAR
9	reply_to_id	VARCHAR
10	chat_id	VARCHAR
11	created_date_time	VARCHAR
12	web_url	VARCHAR
13	deleted_date_time	VARCHAR
14	mentions	VARCHAR
15	etag	VARCHAR
16	policy_violation	VARCHAR
17	from	VARCHAR
18	reactions	VARCHAR
19	id	VARCHAR
20	last_modified_date_time	VARCHAR

Table: channels

No	Column Name	Type	Notes
1	web_url	VARCHAR
2	description	VARCHAR
3	id	VARCHAR
4	display_name	VARCHAR
5	email	VARCHAR

Table: channel_members

No	Column Name	Type	Notes
1	user_id	VARCHAR
2	roles	VARCHAR
3	id	VARCHAR
4	display_name	VARCHAR
5	channel_id	VARCHAR
6	email	VARCHAR

Table: conversation_threads

No	Column Name	Type	Notes
1	preview	VARCHAR
2	is_locked	BOOLEAN
3	has_attachments	BOOLEAN
4	group_id	VARCHAR
5	conversation_id	VARCHAR
6	last_delivered_date_time	VARCHAR
7	topic	VARCHAR
8	id	VARCHAR
9	unique_senders	VARCHAR

Table: team_drives

No	Column Name	Type	Notes
1	drive_type	VARCHAR
2	owner	VARCHAR
3	web_url	VARCHAR
4	quota	VARCHAR
5	name	VARCHAR
6	id	VARCHAR
7	created_by	VARCHAR
8	last_modified_date_time	VARCHAR

External Resources

• Microsoft Teams
• Microsoft Graph Rest Apis
• Api V1.0
• Group_members
• Group_owners
• Channel_members
• Channel_tabs
• Conversation_threads
• Conversation_posts
• Team_drives
• Team_device_usage_report
• Requests Limitation
• Instructions
• Azure Portal
• Instantiate
• Calling

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.