Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
surya_30
Partner - Contributor
Partner - Contributor

Qlik Web connector to one Drive V2

Hi I have an excel file and a .qvs file in One drive. I am trying to use qlik web connector to connect to them , I am not sure what parameters to pass in the below picture.

Has anyone done it before with a sample format.

1111.JPG

Labels (1)
1 Solution

Accepted Solutions
Francisco_Fernandez

Hello @surya_30 ,

(This is just an example. There are multiple way to retrieve the information that you are looking for)

You should run the "Items" table empty first.

Francisco_Fernandez_0-1648222982846.png


This will retrieve the Folder ID, in my case i'm going to use the "id" for folder named "test".

Francisco_Fernandez_2-1648223261660.png

This will retrieve the ID for the file, and now you can use the file ID either with " GetRawFileAsBinary" or "GetRawFileAsText".

Francisco_Fernandez_4-1648223440522.png

 

Hopefully this helps.
Best regards,

Francisco

View solution in original post

1 Reply
Francisco_Fernandez

Hello @surya_30 ,

(This is just an example. There are multiple way to retrieve the information that you are looking for)

You should run the "Items" table empty first.

Francisco_Fernandez_0-1648222982846.png


This will retrieve the Folder ID, in my case i'm going to use the "id" for folder named "test".

Francisco_Fernandez_2-1648223261660.png

This will retrieve the ID for the file, and now you can use the file ID either with " GetRawFileAsBinary" or "GetRawFileAsText".

Francisco_Fernandez_4-1648223440522.png

 

Hopefully this helps.
Best regards,

Francisco