Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

How to check File exist on the web (Share point folder)

Hi Folks, Generally we can use FILESIZE or FILETIME functions in the script to verify weather file exist on the specified folder. But these functions are not worked for Web files example share point sites.

ISNULL(FILETIME('http://myteamsusa/sites/Shared%20Documents/2013/WW38/GCRI_TDR_WW38.xlsx'))

How to check weather file exist or not on Share point web site folders ?

Thanks

Tags (1)
3 Replies
whiteline
Honored Contributor II

Re: How to check File exist on the web (Share point folder)

Hi.

If you want to read from these files then you could use loads with error handling. Just check that the resulting table is not empty. 

Error Handling in qlikview

Not applicable

Re: How to check File exist on the web (Share point folder)

Thanks Whiteline. I tried this way also. But I am not sure I didn't get any values for ScriptError , ScriptErrorDetails & ScriptErrorCount  in the TRACE statemement. I am using QV11.2 SR2. I need to turn on any seetings ?

whiteline
Honored Contributor II

Re: Re: How to check File exist on the web (Share point folder)

I think you've missed something.

(see the attached image)