Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

I need to insert a record into a table if my tS3List component does not find the file.

Hi, and thanks for looking!

I need to insert a record into an existing table when my tS3List component does not find the file I am looking for.  I have to insert, file_name I was looking for and the datetime, "insert into job_status_table (file_name, job_time) values (<S3_key_prefix>, getcurrentdate). Is this possible?    Thanks, in advance.

Labels (2)
1 Reply
vapukov
Master II
Master II

Hi,

 

generally - not,

 

list component - return all files matched with pattern (for example in folder), but it does not know anything about missed files

if you know full - you could check error code 

((String)globalMap.get("tS3List_1_ERROR_MESSAGE"))

but need to test -what it is return if no files found

 

as a variant - use command-line client for check file

https://unix.stackexchange.com/questions/339650/check-if-file-exists-in-s3-bucket