Open file as Read-Only

Question

Hi Folks, Can someone pelae help me to import excel fiel as read only becasue while using dynamic tool to import last creation file but it giving me an error becasue someone is using it. I can not set file as ready only becasue team use it and update it. Is there any tool or logic we can import file despite someone already opened file..

gawa · Accepted Answer

In my understanding, this was doable until version 2021.X but it's not been doable any more since 2022.X.

Workaround is:

1) Read the file by Blob Input tool *In my environment, Blob Input threw no error even if the file is locked by other process.

2) Save that blob file at temporary folder

3) Read the file saved in step 2) by Input Tool

By doing the above steps, you can indirectly read the target file. These steps might involve temporary folder and the Control Container that would require the advanced skill to implement correctly.