Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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

3 Replies
whiteline
Master II
Master II

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
Author

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
Master II
Master II

I think you've missed something.

(see the attached image)