Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
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