I get an excel file with the process model and store it in "pv!copyTemplateExcel". I specify it in "Open or create workbook(License not required)". But I get an error saying "[Document:10814]" cannot be opened because it does not exist. Could you please tell me the solution?
Discussion posts and replies are publicly visible
I think you will have to first download the file from Appian to the robotic host,
https://docs.appian.com/suite/help/24.1/rpa-9.9/actions-appian-services.html#download-document
Thank you for your reply.
Does this mean that RPA cannot retrieve documents stored within Appian apps?
(Does this mean that RPA can only retrieve documents located on the host computer?)
No, and no. It is just that you need to download the file from the Appian platform first.
Does that mean I have to include a download step in the "Settings" section?
"Download Document" is a separate robotic action that you need to run before trying to open the Excel.
Is it something like this?I'm trying this form, but it's not going well, so I'm doing trial and error.
I already posted the link to the documentation above.
I've been looking at those links as well, but it's not working, so I'll think about it some more.
thank you very much.
Hi misak0001 So basically what "Open or create workbook (License not required)” action does is open an excel workbook which is present in the host system where the agent is active. Since the excel you are trying to open is a file you have on your Appian cloud, the parameter you are passing will fail, The input you need to provide is the file path in your host system.So as Stefan said, you need to make sure the excel you are receiving should be downloaded into a file path of your choice before your use "Open or create workbook (License not required)” action.Hope this helps!!