Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
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
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

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 ?

Master II
Master II

I think you've missed something.

(see the attached image)