Qlik Community

Ask a Question

Connectivity & Data Prep

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

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
rohitk1609
Specialist III
Specialist III

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
Partner

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
Specialist III
Specialist III
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?

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
Specialist III
Specialist III
Author

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

fosuzuki
Partner
Partner

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
Specialist III
Specialist III
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
Partner

Nice!

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