check for file on sharepoint

[saumyashah90]

if i want to check whether the file is present on sharepoint or not from Qlikview is it possible?

Suppose there are 5 excel file uploaded on sharepoint.

file1

file2,

file3,

file4,

file5

and i want to check whether there is file6 present on sharepoint or not, is there any way?

[suniljain]

you can create static link to check it . I think ,there is no dynamic way available to do it.

[saumyashah90]

can you explain about the static link in detail?

[suniljain]

e.g

let say at one URL your file 4 is available so you can use same URL to check file 5 by replacing it by file 5 name in URL.

[saumyashah90]

yeah sunil can you show can we do that with an expression?

[#6]

Try this ...

if  isnull(filetime('filename')) then

....

.......

.....

endif;