Has anyone used this tap? <https://github.com/sing...
# singer-taps
j
Mainly interested in collecting files from teams
v
Looked at it yesterday, I was just interested in Users and Groups.
Haven't actually used it as I"m waiting on approval from the azuread team 😕 , looked at the code and it looks alright though
j
Similar wait for me. Need an application id. Trying to solve the problem of getting files from the “business” and teams groups are ubiquitous. Not sure the best solution but eventually needs to go to blob or internal stage to go to Snowflake.
v
yeah it looks right to me, as even though it's called ms-teams it's just hooking to the graph api
Most AzureAD setups you can actually create the application as a regular user, and just send the extra approvals for access up to an admin
Give it a shot! only issue is that I scared our AzureAD admin a bit when I was able to create the app myself
a
+1
on feeling the pain of needing an Application Principal 🤦‍♂️ In case it's helpful, "we" (translation: almost entirely @John Timeus (Slalom Consulting)) created a similar AzureAD auth workflow for the Power BI Metadata tap. In case it's helpful, here's that tap: https://github.com/dataops-tk/tap-powerbi-metadata
Also, fyi @John Timeus (Slalom Consulting) 👆 in case you are interested in tapping MS Teams at some point 🤔
v
Just got access 10 minutes ago, giving this a shot now!
Wish me luck
I can tell you I'm getting data from Users and Groups through the tap. So that does work, not quite getting the fields I want yet though employeeID isn't there for some reason, but it works!
For users it looks like there isn't support for $select in the tap at the moment, fairly simple add for a manual hard code, but is a bit more in depth with Discovery
j
@aaronsteers @John Timeus (Slalom Consulting) Related to the PowerBI tap, any idea how to develop using Premium Capacity just on a test basis (do not have premium capacity yet but feel it will be soon but would like to explore the capabilities)? This is definitely one of the areas MSFT falls short of CRM on making dev platforms easy to gets started and test (e.g. Salesforce development org, Tableau pre-release and tableau online sites).
j
We had premium capacity set up already so didn't have to solve for that. There is Premium Per User that you might be able to turn on for your login and test
Depending on what you are trying to understand
v
Diving in a bit deeper someone decided to camel case and decamel case so that all columns come over in the records in snake case...... /rant over