LogoLogo
ProductsPricingGlossary Launch Acho
  • 🎉Welcome
  • Introduction
  • What is Acho?
  • How does Acho work?
    • Proof of Concept (PoC)
  • App Builder
    • Get Started
    • Core Concepts
    • Overview
    • App construction
      • App Configuration
      • Pages
      • Interactions
        • Add an interaction
        • Add conditions to interactions
        • Event payload
        • Ordering interactions with action flow
        • Transformer
        • Actions
          • Navigation
          • Element
          • Data Source
          • App
          • Page
          • API Service
          • Database
          • Media Service
      • Table
      • Metric
      • Query
      • Data Store
      • Elements
        • Table & Chart
          • Searchable Table
          • Table
          • Chart
          • Score Card
        • Form Elements
          • Form
          • Search Bar
          • Checkbox
          • Date Picker
          • Custom Form
          • Input
          • Multiselect
          • Radio Button
          • Radio List
          • Rich Text Editor
          • Select
          • Switch
          • Textarea
          • Upload
        • Web Elements
          • Badge
          • Button
          • Clickable
          • Collapse Menu
          • Divider
          • Icon
          • Image
          • Link
          • Message
          • Modal
          • Notification
          • Pagination
          • Popover
          • Rate
          • Rich Text
          • Tabs
          • Text
        • Layout Elements
          • Container
          • List
        • Advanced elements
          • Code Block
          • Condition
          • Print
        • CSS Styles
          • General techniques
          • Layout
          • Spacing
          • Size
          • Position
          • Typography
          • Background
          • Border
          • Effect
        • Form Check
        • Tooltip
      • Accessors
      • Plugin Store
    • Popular Use Cases
      • Build a chart from Table Nodes
      • Create a table
      • Create a list
      • Create a filter
      • Create a search bar
      • Use Custom Form Container to collect user inputs
      • Drill down on a table
      • Download file from query node
      • Set loading animations
      • Modify a database
      • Navigate to a different page
      • Set up dynamic routing
      • Update app data using accessors
      • Create a Chart with Code Block and D3 Library
      • Rich text and rich text editor
      • Send an Email via Mailjet Plugin
    • Preview
    • Publish
      • Embed published app on website
    • Version Control
    • App User Management
      • Onboarding Page
      • Sign in page
      • Guest Isolation and Private Session
    • Theme
    • FAQ
  • Acho Studio
    • Quick Start
    • Resources
      • Add a resource
      • Supported data sources
        • Airtable
        • Amazon Ads
        • Amplitude
        • Amazon Seller Partner
        • Apify Dataset
        • Appstore
        • Asana
        • API Connector
        • API Template
        • AWS CloudTrail
        • Azure Table Storage
        • Batch Files
        • Bamboo HR
        • BigCommerce
        • BigQuery
        • Bing Ads
        • Braintree
        • Cart.com
        • Chargebee
        • Chargify
        • Chartmogul
        • Clickhouse
        • Close.com
        • CockroachDB
        • Confluence
        • Customer.io
        • Delighted
        • Dixa
        • Drift
        • Facebook Marketing
        • Freshdesk
        • Freshsales
        • Freshservice
        • GitHub
        • GitLab
        • Google Ads
        • Google Analytics
        • Google Sheets
        • Google Search Console
        • Greenhouse
        • Harness
        • Harvest
        • HubSpot
        • IBM Db2
        • Instagram
        • Intercom
        • Iterable
        • Jenkins
        • Jira
        • Kafka
        • Klaviyo
        • Kustomer
        • Lemlist
        • Lever Hiring
        • LinkedIn Ads
        • Linnworks
        • Mailchimp
        • Marketo
        • Microsoft Teams
        • Mixpanel
        • Monday
        • MongoDB
        • MySQL
        • My Hours
        • NetSuite
        • Notion
        • Okta
        • OneDrive
        • OneSignal
        • Oracle DB
        • Outreach
        • PagerDuty
        • Paypal Transaction
        • Paystack
        • Pipedrive
        • PersistIq
        • Pinterest
        • Plaid
        • PostgreSQL
        • PostHog
        • PrestaShop
        • Qualaroo
        • QuickBooks
        • Recharge
        • Recurly
        • Remote File
        • S3
        • Salesforce
        • Salesloft
        • SearchMetrics
        • Sendgrid
        • Sentry
        • Short.io
        • Shopify
        • Single File
        • Slack
        • Smartsheets
        • Snapchat Marketing
        • Snowflake
        • SQL Server
        • Square
        • Stripe
        • SurveyMonkey
        • Tempo
        • TikTok Marketing
        • Trello
        • Twilio
        • Typeform
        • VictorOps
        • WooCommerce
        • YouTube Analytics
        • Zendesk Chat
        • Zendesk Sunshine
        • Zendesk Talk
        • Zendesk Support
        • Zenloop
        • Zoho CRM
        • Zoom
        • Zuora
    • Data Prep (Projects)
      • Create a Data Prep Project
        • Create a table tab
        • Copy a table tab
        • Hide a table tab
      • Apply an action
        • View
          • Hide Columns
          • Filter
          • Sort
          • Cut
          • Rename
          • Move Column
        • Combine Tables
          • Join
          • Union
        • Transformation
          • Pivot Table
          • Unpivot
        • Data Cleaning
          • Cleanse
          • Replace
          • Change Type
          • Deduplicate
          • Split
          • Flatten
        • Tools
          • Formula
          • SQL Editor
            • SQL Editor Queries
            • All functions in Formula/SQL
              • Mathematical Functions
              • String Functions
              • Date Functions
              • Datetime Functions
              • Time Functions
              • Timestamp Functions
              • Conditional Functions
              • Type Conversion
              • Other Functions
        • Reserved Keywords
      • Pipeline
      • Edit your pipelines
      • Generate column summary for inspection
      • Use URL to access and share your project
      • Write a description for your project
      • Delete a resources/project/tab
    • Data Flow
      • Export data
        • Download CSV files
        • Excel Connector
        • Google Sheets Connector
        • Embed a table on your website
          • Data Usage Agreement
        • Apache Superset
        • Chartio
        • Looker
        • Metabase
        • Power BI
        • Qlik
        • Tableau
        • MongoDB
        • MySQL
        • MSSQL
        • Snowflake
        • PostgreSQL
        • BigQuery
    • Set up Data Sync
    • FAQ
  • Organization
    • Get started
    • Create an organization
    • Invite people to your organization
    • Share your resources
    • Share your projects
    • Share your apps
    • Change payment method on file
  • FAQ
    • I can't find data after uploading a big CSV file
Powered by GitBook
On this page
  • Connect to Microsoft Teams
  • Supported table
  • Authentication

Was this helpful?

  1. Acho Studio
  2. Resources
  3. Supported data sources

Microsoft Teams

PreviousMarketoNextMixpanel

Last updated 2 years ago

Was this helpful?

Connect to Microsoft Teams

1. Go to the Resources page and click the button.

2. Select Microsoft Teams.

3. Enter your account credentials and click Connect.

4. Choose tables to import and click Finish Setup.

5. You will see a icon next to your resource. It may take a few minutes to several hours depending on the data size and the number of your tables. Once your data is ready, you will receive a notification email.

Supported table

Authentication

The Microsoft Graph API uses OAuth for authentication. Microsoft Graph exposes granular permissions that control the access that apps have to resources, like users, groups, and mail. When a user signs in to your app they, or, in some cases, an administrator, are given a chance to consent to these permissions. If the user consents, your app is given access to the resources and APIs that it has requested. For apps that don't take a signed-in user, permissions can be pre-consented to by an administrator when the app is installed.

Microsoft Graph has two types of permissions:

  • Delegated permissions are used by apps that have a signed-in user present. For these apps, either the user or an administrator consents to the permissions that the app requests, and the app can act as the signed-in user when making calls to Microsoft Graph. Some delegated permissions can be consented by non-administrative users, but some higher-privileged permissions require administrator consent.

  • Application permissions are used by apps that run without a signed-in user present; for example, apps that run as background services or daemons. Application permissions can only be consented by an administrator.

  1. Click upper-left menu icon and select Azure Active Directory

  2. Select App Registrations

  3. Click New registration

  4. Register an application

    1. Name:

    2. Supported account types: Accounts in this organizational directory only

    3. Register (button)

  5. Record the client_id, tenant_id, and which will be used by the tap for authentication and API integration.

  6. Select Certificates & secrets

  7. Provide Description and Expires

    1. Description: tap-microsoft-teams client secret

    2. Expires: 1-year

    3. Add

  8. Copy the client secret value, this will be the client_secret

  9. Select API permissions

    1. Click Add a permission

  10. Select Microsoft Graph

  11. Select Application permissions

  12. Select the following permissions:

    1. Users

      • User.Read.All

      • User.ReadWrite.All

      • Directory.Read.All

      • Directory.ReadWrite.All

    2. Groups

      • GroupMember.Read.All

      • Group.Read.All

      • Directory.Read.All

      • Group.ReadWrite.All

      • Directory.ReadWrite.All

    3. Group members

      • GroupMember.Read.All

      • Group.Read.All

      • Directory.Read.All

    4. Group owners

      • Group.Read.All

      • User.Read.All

      • Group.Read.All

      • User.ReadWrite.All

      • Group.Read.All

      • User.Read.All

      • Application.Read.All

    5. Channels

      • ChannelSettings.Read.Group

      • ChannelSettings.ReadWrite.Group

      • Channel.ReadBasic.All

      • ChannelSettings.Read.All

      • ChannelSettings.ReadWrite.All

      • Group.Read.All

      • Group.ReadWrite.All

      • Directory.Read.All

      • Directory.ReadWrite.All

    6. Channel members

      • ChannelMember.Read.All

      • ChannelMember.ReadWrite.All

    7. Channel tabs

      • TeamsTab.Read.Group

      • TeamsTab.ReadWrite.Group

      • TeamsTab.Read.All

      • TeamsTab.ReadWriteForTeam.All

      • TeamsTab.ReadWrite.All

      • Group.Read.All

      • Group.ReadWrite.All

      • Directory.Read.All

      • Directory.ReadWrite.All

    8. Conversations

      • Group.Read.All

      • Group.ReadWrite.All

    9. Conversation threads

      • Group.Read.All

      • Group.ReadWrite.All

    10. Conversation posts

      • Group.Read.All

      • Group.ReadWrite.All

    11. Team drives

      • Files.Read.All

      • Files.ReadWrite.All

      • Sites.Read.All

      • Sites.ReadWrite.All

    12. Team device usage report

      • Reports.Read.All

  13. Click Add permissions

This source requires Application permissions. Follow these for creating an app in the Azure portal. This process will produce the client_id, client_secret, and tenant_id needed for the tap configuration file.

Login to

Token acquiring implemented by the confidential client application with a client secret and AcquireTokenForClient from

instructions
Azure Portal
instantiate
calling
Microsoft Authentication Library (MSAL) for Python
users
groups
group_members
group_owners
channels
channel_members
channel_tabs
conversations
conversation_threads
conversation_posts
team_drives
team_device_usage_report