Skip to main content

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rohitk1609
Master
Master

How to Download an Excel sheet from Microsoft Teams Files Location

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

teams.png

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

16 Replies
fosuzuki
Partner - Specialist III
Partner - Specialist III

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
Master
Master
Author

Hi Fosuzuki,

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

 

Thanks,

Rohit

chrisbrain
Specialist II
Specialist II

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?

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
male_carrasco
Creator
Creator

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. 

sharepoint.PNG

 

ps: Thank @rohitk1609 for your post.

rohitk1609
Master
Master
Author

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

fosuzuki
Partner - Specialist III
Partner - Specialist III

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
Master
Master
Author

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
Creator
Creator

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.

Capture2.PNG


Best Regards

fosuzuki
Partner - Specialist III
Partner - Specialist III

Nice!

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