1"use strict";(self.webpackChunkerpl_docusaurus=self.webpackChunkerpl_docusaurus||[]).push([[8994],{28453:(e,a,n)=>{n.d(a,{R:()=>o,x:()=>c});var t=n(96540);const s={},r=t.createContext(s);function o(e){const a=t.useContext(r);return t.useMemo(function(){return"function"==typeof e?e(a):{...a,...e}},[a,e])}function c(e){let a;return a=e.disableParentContext?"function"==typeof e.components?e.components(s):e.components||s:o(e.components),t.createElement(r.Provider,{value:a},e.children)}},34881:(e,a,n)=>{n.r(a),n.d(a,{assets:()=>i,contentTitle:()=>c,default:()=>d,frontMatter:()=>o,metadata:()=>t,toc:()=>m});const t=JSON.parse('{"id":"erpl-odata/m365/teams","title":"Microsoft Teams","description":"Query teams, channels, members, and channel messages from DuckDB via Microsoft Graph.","source":"@site/docs/erpl-odata/m365/teams.md","sourceDirName":"erpl-odata/m365","slug":"/erpl-odata/m365/teams","permalink":"/docs/erpl-odata/m365/teams","draft":false,"unlisted":false,"editUrl":"https://github.com/datazoode/erpl-landingpage/tree/main/docs/erpl-odata/m365/teams.md","tags":[],"version":"current","sidebarPosition":4,"frontMatter":{"sidebar_position":4,"title":"Microsoft Teams","description":"Query teams, channels, members, and channel messages from DuckDB via Microsoft Graph.","keywords":["erpl-odata","microsoft teams","graph","duckdb"]},"sidebar":"docs","previous":{"title":"Excel Workbooks","permalink":"/docs/erpl-odata/m365/excel"},"next":{"title":"Outlook \u2014 Mail, Calendar, Contacts","permalink":"/docs/erpl-odata/m365/outlook"}}');var s=n(74848),r=n(28453);const o={sidebar_position:4,title:"Microsoft Teams",description:"Query teams, channels, members, and channel messages from DuckDB via Microsoft Graph.",keywords:["erpl-odata","microsoft teams","graph","duckdb"]},c="Microsoft Teams",i={},m=[];function l(e){const a={code:"code",h1:"h1",header:"header",p:"p",pre:"pre",...(0,r.R)(),...e.components};return(0,s.jsxs)(s.Fragment,{children:[(0,s.jsx)(a.header,{children:(0,s.jsx)(a.h1,{id:"microsoft-teams",children:"Microsoft Teams"})}),"\n",(0,s.jsx)(a.p,{children:"Read your Teams data \u2014 teams, channels, members, and channel messages \u2014 by human-readable names rather than GUIDs."}),"\n",(0,s.jsx)(a.pre,{children:(0,s.jsx)(a.code,{className:"language-sql",children:"-- Teams you belong to\nSELECT * FROM graph_my_teams();\n\n-- Channels in a specific team\nSELECT * FROM graph_team_channels(team => 'Sales EU');\n\n-- Members of a channel\nSELECT * FROM graph_team_members(team => 'Sales EU', channel => 'General');\n\n-- Recent channel messages\nSELECT createdDateTime, \"from\", body\nFROM graph_channel_messages(\n team => 'Sales EU',\n channel => 'Announcements'\n)\nWHERE createdDateTime > now() - INTERVAL '7 days';\n"})}),"\n",(0,s.jsx)(a.p,{children:"Useful for collaboration analytics, audit trails, and lightweight reporting on team activity."})]})}function d(e={}){const{wrapper:a}={...(0,r.R)(),...e.components};return a?(0,s.jsx)(a,{...e,children:(0,s.jsx)(l,{...e})}):l(e)}}}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.