Connectors
Operations Applications
Microsoft Teams
3min
microsoft teams is a messaging app for your organizations, providing a workspace for real time collaboration and communication, meetings, file and app sharing, all in one place, all in the open, and accessible to everyone dlh io provides this integration in order for organizations to leverage analytically basic concepts such as who, what, when users scheduled or participated in meetings and events to help align these data points with other relevant business domain kpis such as for sales, recruiting, product demonstrations, etc setup instructions remember datalakehouse io securely connects to your teams account instance by redirecting you to the microsoft teams authorization screen for you to sign in and authenticate your account datalakehouse io does not capture or store your password/credentials using the form please complete the following basic steps enter a name or alias for this connection, in the ' name/alias ' field, that is unique from other connectors enter in the ' target schema prefix ' field, a name that will be unique in your data cloud destination where you wish to land the data click the authorize your account button which will transport you to the application login, where you will login with your account credentials once your credentials are accepted and you allow datalakehouse io to access your data, you will be automatically redirected back to this datalakehouse io portal and you should be able to see a successful connection helpful troubleshooting information the following scenarios we've discussed with users of this connector which may help to understand how microsoft teams allows customer access to metadata and data access in general can a user see meetings or meeting details if they did not create the meeting? in this document from microsoft, https //learn microsoft com/en us/microsoftteams/teams analytics and reports/meeting attendance report https //learn microsoft com/en us/microsoftteams/teams analytics and reports/meeting attendance report , we can see that access to meetings not created by the user authorized in the dlh io teams connector will only be able to see meetings not created by them for 24 hours any meetings outside of this window may result in information not captured or possibily warnings thrown in the dlh io logs teams attendance report note one option would be to create a connector for each user and only select certain entities for retrieval please contact dlh io support regarding this approach first what permissions are required for teams access? the user creating the dlh io teams connector should have the teams administrator permission where do microsoft teams go to update privileges and settings for granular access and control over the teams application? as an administrator of your organization's microsoft teams application, the admin area seems to be located here, https //admin teams microsoft com/ https //admin teams microsoft com/ warning messaging on various entities the following messages indciate that while a meeting was scheduled nobody attended the meeting error occured while fetching attendance report { "action" "done", "actiontype" "retrieve", "bridgename" "sync teams", "bridgeguid" "2ba1bc573fe3415bb27719fee0a42482", "data" { "entity type" "microsoft teams entity", "entity name" " attendance report ", "entity step description" "error occurred while fetching attendanse report" }, "created ts" { "seconds" 1696951020, "nanos" 0 }, "created dts" "tue, 10 oct 2023 15 17 00 pm", "custommessage" "{\\"error\\" {\\"code\\" \\"general\\",\\"message\\" \\"user id in token(6e338409 8a41 4bf4 8b04 22f036fad5d8) is not the organizer of the queried meeting \\",\\"innererror\\" {\\"request id\\" \\"8d5d4016 ea87 41df aeb1 0dc8a7acd132\\",\\"date\\" \\"2023 10 10t15 17 00\\",\\"client request id\\" \\"8d5d4016 ea87 41df aeb1 0dc8a7acd132\\"}}}", "loglevel" "warning" } error occured while fetching online meeting { "action" "done", "actiontype" "retrieve", "bridgename" "sync teams", "bridgeguid" "2ba1bc573fe3415bb27719fee0a42482", "data" { "entity type" "microsoft teams entity", "entity name" " online meeting ", "entity step description" "error occurred while fetching online meeting" }, "created ts" { "seconds" 1696951012, "nanos" 0 }, "created dts" "tue, 10 oct 2023 15 16 52 pm", "custommessage" "{\\"error\\" {\\"code\\" \\"notfound\\",\\"message\\" \\"an error has occurred \\",\\"innererror\\" {\\"request id\\" \\"af647ad8 ebd3 4b77 bbab f4221d982631\\",\\"date\\" \\"2023 10 10t15 16 52\\",\\"client request id\\" \\"af647ad8 ebd3 4b77 bbab f4221d982631\\"}}} meeting url https //graph microsoft com/v1 0/me/onlinemeetings?$filter=joinweburl%20eq%20'https%3a%2f%2fteams microsoft com%2fl%2fmeetup join%2f19%253ameeting m2rlzmzjmjqtmgy0oc00zgvhlwjkmtetmtrkymm1y2u0n2y0%2540thread v2%2f0%3fcontext%3d%257b%2522tid%2522%253a%2522dad8ba0a d2e4 4f58 a9e5 02b54650c85e%2522%252c%2522oid%2522%253a%25226e338409 8a41 4bf4 8b04 22f036fad5d8%2522%257d'", "loglevel" "warning" } error occrued while fetching event { "action" "done", "actiontype" "retrieve", "bridgename" "sync teams", "bridgeguid" "993eb42e57c4441e99f61257346259c9", "data" { "entity type" "microsoft teams entity", "entity name" " event ", "entity step description" "error occurred while fetching event" }, "created ts" { "seconds" 1685112931, "nanos" 0 }, "created dts" "fri, 26 may 2023 14 55 31 pm", "custommessage" "{\\"error\\" {\\"code\\" \\"resourcenotfound\\",\\"message\\" \\"resource could not be discovered \\",\\"innererror\\" {\\"date\\" \\"2023 05 26t14 55 31\\",\\"request id\\" \\"2c5fcfdc 43bb 4558 96e5 42422d6c3241\\",\\"client request id\\" \\"2c5fcfdc 43bb 4558 96e5 42422d6c3241\\"}}}", "loglevel" "warning" } the following error message indicates that the person who authorized the teams source connector did so using a personal account updated to a work or school account in microsoft teams error occured while fetching channel "action" "done", "actiontype" "retrieve", "bridgename" "sync teams", "bridgeguid" "993eb42e57c4441e99f61257346259c9", "data" { "entity type" "microsoft teams entity", "entity name" " channel ", "entity step description" "error occurred while fetching channel" }, "created ts" { "seconds" 1685112940, "nanos" 0 }, "created dts" "fri, 26 may 2023 14 55 40 pm", "custommessage" "{\\"error\\" {\\"code\\" \\"authenticationerror\\",\\"message\\" \\"error authenticating with resource\\",\\"innererror\\" {\\"date\\" \\"2023 05 26t14 55 40\\",\\"request id\\" \\"40901727 e1b3 4982 af39 6ad8d957aaa5\\",\\"client request id\\" \\"40901727 e1b3 4982 af39 6ad8d957aaa5\\"}}}", "loglevel" "warning" } error occured while fetching team { "action" "done", "actiontype" "retrieve", "bridgename" "sync teams", "bridgeguid" "993eb42e57c4441e99f61257346259c9", "data" { "entity type" "microsoft teams entity", "entity name" " team ", "entity step description" "error occurred while fetching team" }, "created ts" { "seconds" 1685112939, "nanos" 0 }, "created dts" "fri, 26 may 2023 14 55 39 pm", "custommessage" "{\\"error\\" {\\"code\\" \\"authenticationerror\\",\\"message\\" \\"error authenticating with resource\\",\\"innererror\\" {\\"date\\" \\"2023 05 26t14 55 39\\",\\"request id\\" \\"1c9d392f 7840 46eb 886d 6b123197f2af\\",\\"client request id\\" \\"1c9d392f 7840 46eb 886d 6b123197f2af\\"}}}", "loglevel" "warning" } issue handling if any issues occur with the authorization simply return to the sources page in datalakehouse io, edit the source details and click the save & test or authorize your account or re authorize account button to confirm connectivity if any issues persist please contact our support team via the datalakehouse io support portal https //datalakehouse zendesk com