Skip to main content
Solved

Using AARI to pass a file into a BOT

  • January 20, 2023
  • 7 replies
  • 452 views

Forum|alt.badge.img+8
  • Flight Specialist | Tier 4
  • 63 replies

I’m trying to create a simple process using a form to get three string inputs from a user AND a file. I’ve created a simple test bot that has the variables as inputs. Three string variables and one File variable.

On my form I have three text box inputs and a file selector input (all mandatory). I have all variables mapped to the variables in the BOT. The three text boxes are being passed in perfectly, but when I try to use the File variable in the test bot (for example, passing it in as the file variable for an Open Excel command) it does not work. I’ve checked the value of the File variable in a message box and it appears to be blank when I run this using AARI even though the other string variables are populated.

Note that it works fine when I just run the BOT and and am prompted for inputs including the file. What gives????

 

Best answer by JMarino

@Padmakumar Most of the documentation around files in AARI focuses on viewing the file (which I don’t need to do). So that was confusing to me. I had to really dig through and experiment with the BOT Action “AARI Web > Get Storage File” in order to use the file once it’s passed into a BOT. Not intuitive at all since the other variables come through once they are mapped. I was able to solve this using “Get Storage File”

View original
Did this topic help answer your question?

7 replies

Padmakumar
Forum|alt.badge.img+13
  • Navigator | Tier 3
  • 785 replies
  • January 23, 2023

Hi @JMarino ,

 

If I am correct, the file name is saving as a dictionary-type variable, where you need to use both the name and extension key values in order to specify one particular file. Have you tried like that?


Forum|alt.badge.img+8
  • Author
  • Flight Specialist | Tier 4
  • 63 replies
  • January 23, 2023

@Padmakumar I’ll try changing the variable in the test bot to a dictionary and use the name and extension when passing in from the form. We’ll see if that works!


Forum|alt.badge.img+8
  • Author
  • Flight Specialist | Tier 4
  • 63 replies
  • January 23, 2023

Doesn’t work. The dictionary variables comes in as null. When I do a message box using name and extension the value is ‘null.null’


Forum|alt.badge.img+8
  • Author
  • Flight Specialist | Tier 4
  • 63 replies
  • January 23, 2023

Clarification: my variable vReconciliationFile is a File type of variable in my BOT. I’m trying to pass in the value from the ‘Select File’ object on the form. Seems like a simple ask. There’s no documentation on how to do this properly.


Padmakumar
Forum|alt.badge.img+13
  • Navigator | Tier 3
  • 785 replies
  • January 29, 2023

Hi @JMarino ,

 

Please refer to this documentation on viewing files from an AARI Form through an AARI Process. Let me know whether it was helpful or not.


Forum|alt.badge.img+8
  • Author
  • Flight Specialist | Tier 4
  • 63 replies
  • Answer
  • January 31, 2023

@Padmakumar Most of the documentation around files in AARI focuses on viewing the file (which I don’t need to do). So that was confusing to me. I had to really dig through and experiment with the BOT Action “AARI Web > Get Storage File” in order to use the file once it’s passed into a BOT. Not intuitive at all since the other variables come through once they are mapped. I was able to solve this using “Get Storage File”


jshaji
Forum|alt.badge.img+2
  • Navigator | Tier 3
  • 10 replies
  • September 3, 2024
JMarino wrote:

@Padmakumar Most of the documentation around files in AARI focuses on viewing the file (which I don’t need to do). So that was confusing to me. I had to really dig through and experiment with the BOT Action “AARI Web > Get Storage File” in order to use the file once it’s passed into a BOT. Not intuitive at all since the other variables come through once they are mapped. I was able to solve this using “Get Storage File”

I guess you meant to say “Process Composer>Get Storage File”


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings