How to Download an Excel sheet from Microsoft Teams Files Location

[rohitk1609]

Hi Techies,

I need to download an excel sheet which is presented at Microsoft Teams Files location. There is an option which gives two paths

1. Microsoft Teams

https://teams.microsoft.com/l/file/A13BD6C7?tenantId=-81a1-9e8ae3459641&fileType=xlsx&objectUrl=http...

2. Sharepoint

https://apps.***.com/sites/****/_layouts/15/WopiFrame2.aspx?sourcedoc={70-0a120829ecae}&action=edit

One top right corner, there are three dots, when I click on it, it gives me two options of link which I stated above. Can you please guide me which connector works for this scenario. I have Nov 2017 Web connector too.

Thanks,

Rohit

[fosuzuki]

Hi Rohit,

As far as I know, the MS Teams files are stored in Sharepoint. So you can use the Qlik Office 365 Sharepoint connector.

[rohitk1609]

Hi Fosuzuki,

We don't have Office 365 Share point connector. Is there any other way we can do it?

Thanks,

Rohit

[chrisbrain]

Hi - Are you using the Qlik Web Connectors Nov 2017 release then? Can't you update to the latest version and try the Office 365 Sharepoint connector?

[male_carrasco]

Hi @fosuzuki ,

I have the Qlik Office 365 Sharepoint connector, however, I tried to set up to found the file and I can't.

Do you know how to obtain the file?

Thank you in advance. 

ps: Thank @rohitk1609 for your post.

[rohitk1609]

I can't update it because we are using MongoDB connector also which would be depreciated in latest release. 

[fosuzuki]

Hello @male_carrasco ,

I'd recommend you to use the ListFolders together with the ListFiles to look around for other folders/subfolders.

Are you using WebConnectors with QlikView or Qlik Sense?

[rohitk1609]

Can you please explain me in detail step wise "use the ListFolders together with the ListFiles"?

I am using Web connector Nov 2017 with Qlik Sense

[male_carrasco]

Thank @fosuzuki  for your reply!
I'm using Sense. I solved it! but now, I have a new challenge.
I found the files, but I'm trying to loading data from the files. Every month I will load a new file from the folder (Same format, fields).
If you know how to read the data from several files I will appreciate a clue.

Best Regards

[fosuzuki]

Nice!

Now you need to use the GetFile function, and input the UniqueId for the file you need.