topic Re: check for file on sharepoint in QlikView

check for file on sharepoint

saumyashah90 — Wed, 09 Oct 2013 12:54:54 GMT

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 — Wed, 09 Oct 2013 13:09:55 GMT

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

saumyashah90 — Wed, 09 Oct 2013 13:13:40 GMT

can you explain about the static link in detail?

suniljain — Wed, 09 Oct 2013 13:14:54 GMT

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 — Thu, 10 Oct 2013 05:50:40 GMT

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

Thu, 10 Oct 2013 05:59:46 GMT

Try this ...

if isnull(filetime('filename')) then

....

.......

.....

endif;