Solved

Using AARI to pass a file into a BOT

  • 20 January 2023
  • 6 replies
  • 288 views
J
Userlevel 2
Badge +8

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????

 

icon

Best answer by JMarino 31 January 2023, 21:16

View original

6 replies

Padmakumar
Userlevel 7
Badge +13

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?

Padmakumar
J
Userlevel 2
Badge +8

@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!

J
Userlevel 2
Badge +8

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’

J
Userlevel 2
Badge +8

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
Userlevel 7
Badge +13

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.

Padmakumar
J
Userlevel 2
Badge +8

@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”

Reply


Terms & ConditionsCookie settings