Are there any taps for extracting data from Office...
# singer-tap-development
s
Are there any taps for extracting data from Office 365 cloud hosted Excel workbooks? Use case is I want to load data from a workbook that a client will be periodically adding rows to. I saw this tap https://github.com/ets/tap-spreadsheets-anywhere but if I'm understanding it correctly it extracts excel files from a directory/folder structure. I'm looking for something similar to the google sheets extractor https://github.com/Matatika/tap-google-sheets
Circling back this, thanks everyone for the input! I think tap-sharepoint is the way to go for us. @Henning Holgersen I'm trying to set this up for a client. For authentication, am I understanding correctly that they have to create a user assigned managed identity in Azure and then grab the client_id from that identity to input into the tap config?
h
@steven_wang roughly true. At its core, whatever runs your tap needs to be able to authenticate either using DefaultAzureCredential or ManagedIdentityCredential. If you specify a managed identity, it will use that managed identity in particular. So you can do this using a service principal as long as the correct environment variables are set then DefaultAzureCredential will work. The tricky part is to grant sharepoint access to the identity/sp, Iā€™m lucky to have dedicated Microsoft identity people to do that, but this blog post by one of my colleagues is instructive: https://learningbydoing.cloud/blog/connecting-to-sharepoint-online-using-managed-identity-with-granular-access-permissions/
šŸ‘€ 1
šŸ‘ 1