topic RE: Passing argument to Blue Prism - Script Execution VBO in Product Forum

Passing argument to Blue Prism - Script Execution VBO

_Amlansahoo — Wed, 12 May 2021 08:09:00 GMT

Hi All,

I am trying to pa arguments to Blue Prism - Script Execution VBO but unable to do the same,
Please anyone guide me on the same.

I am just trying below simple code,

Output is appearing blank.
------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------

RE: Passing argument to Blue Prism - Script Execution VBO

_Amlansahoo — Wed, 12 May 2021 08:09:00 GMT

Hi @ewilson Please help me on that.

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------

RE: Passing argument to Blue Prism - Script Execution VBO

EmersonF — Wed, 12 May 2021 12:15:00 GMT

Hi Amlan, i hope you're well, I could give you more information, what kind of error, details.. oh! you could replace \\ with just \.

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
+55081988869544
------------------------------

RE: Passing argument to Blue Prism - Script Execution VBO

_Amlansahoo — Wed, 12 May 2021 12:20:00 GMT

Hi @EmersonF thanks for your response.
I am not getting any error but not getting the required script out put. The result should return 11 but it's returning empty values.
Could you please check if it is working for you or not.

an for python we should give with \\ double back slash not single.

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------

RE: Passing argument to Blue Prism - Script Execution VBO

EmersonF — Wed, 12 May 2021 12:53:00 GMT

I found this information in the VBO documentation, see if it helps you in any way while testing if it works for me

"The output will be all resulting text that your script will have produced from its invocation. It may be necessary to modify the script so that output is delimited in such a way that required results can be easily accessed through string manipulation.
Alternatively, your script could write results to a file and then read those results into Blue Prism with a file access action."

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
+55081988869544
------------------------------

RE: Passing argument to Blue Prism - Script Execution VBO

_Amlansahoo — Wed, 12 May 2021 12:59:00 GMT

Hi @EmersonF I too went through the document. Please give a snap of ur code and how you are passing arguments.

See I am not getting output if I am passing arguments from blue prism otherwise it used give out put. Please let me know how you did it.

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------

RE: Passing argument to Blue Prism - Script Execution VBO

_Amlansahoo — Wed, 12 May 2021 13:07:00 GMT

Hi @ashish.easow @Bruce LiuCould you please help me on this it's bit urgent

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------

RE: Passing argument to Blue Prism - Script Execution VBO

ewilson — Wed, 12 May 2021 13:54:00 GMT

Hi @_Amlansahoo,

Are you testing the VBO from your own process or from the test process that ships with it? If you haven't already, can you try using the test process that comes with it. I just ran it with a simple Hello World! script and it worked fine for me. Below is the script I tested with.

# This program prints Hello, world!

print('Hello, world!')

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

RE: Passing argument to Blue Prism - Script Execution VBO

_Amlansahoo — Wed, 12 May 2021 13:58:00 GMT

Hi @ewilson please give one example where I can pass arguments as I mentioned above.
Please see my example in the post.
I am trying to pass arguments from blue prism to python script but it's not working.
------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------

RE: Passing argument to Blue Prism - Script Execution VBO

ewilson — Wed, 12 May 2021 14:02:00 GMT

There is one oddity I noticed when testing. If I hardcode the values for ScriptEngineFilePath, ScriptFilePath, and ScriptNameAndArguments (as you have in your screenshot) I receive an Access Denied! when trying to execute the script. However, if I place the values in Text data items and pass the data items into the call to Execute Script on the VBO, everything works as expected.

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

RE: Passing argument to Blue Prism - Script Execution VBO

_Amlansahoo — Wed, 12 May 2021 14:09:00 GMT

Hi @ewilson still no luck PFA for that,

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------

RE: Passing argument to Blue Prism - Script Execution VBO

ewilson — Wed, 12 May 2021 14:20:00 GMT

I'm no Python programmer, but this seems to work. In the future, if you have a specific use case it would be easier for you to simply post your script for others to test with then to ask someone to recreate your specific use case from a screen shot.

import sys

def add(a, b):
	result = int(a) + int(b);
	return result;
	     
# Addition of numbers
Sum = 0

Sum = add(sys.argv[1], sys.argv[2]);     
print(Sum);

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

RE: Passing argument to Blue Prism - Script Execution VBO

ewilson — Wed, 12 May 2021 14:29:00 GMT

See my post above. FWIW - The script that you've pictured above will not add the two numbers together as an addition action. It will concatenate them as strings. In other words, the output will be "ab" instead of the value of a + b.

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

RE: Passing argument to Blue Prism - Script Execution VBO

_Amlansahoo — Wed, 12 May 2021 14:29:00 GMT

Hi Eric,
Thanks for that I have copied the same code what you have provided but still no luck.
import sys

def add(a, b):
result = int(a) + int(b);
return result;

# Addition of numbers
Sum = 0

Sum = add(sys.argv[1], sys.argv[2]);
print(Sum);

Could you please show me how youa re passing the arguments if I am trying to pass then there is no result.
This is how I am passed ,

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------

RE: Passing argument to Blue Prism - Script Execution VBO

_Amlansahoo — Wed, 12 May 2021 14:33:00 GMT

Sill no luck Eric. Hope I can get some help.

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------

RE: Passing argument to Blue Prism - Script Execution VBO

ewilson — Wed, 12 May 2021 14:36:00 GMT

Basically the same thing as you have shown. Only difference is that I'm using Python 3.8, as a dedicated install vs Visual Studio.

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

RE: Passing argument to Blue Prism - Script Execution VBO

ewilson — Wed, 12 May 2021 14:40:00 GMT

Remove the trailing "\\" from your ScriptFilePath so the value is C:\\Users\\asahoo\Desktop\\Python

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

RE: Passing argument to Blue Prism - Script Execution VBO

ewilson — Wed, 12 May 2021 14:56:00 GMT

Did you try removing the trailing "\\" from your ScriptFilePath as I mentioned above?

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

RE: Passing argument to Blue Prism - Script Execution VBO

_Amlansahoo — Wed, 12 May 2021 14:57:00 GMT

Thanks a lot Eirc it worked.
But one question do we need to pass argument always as mentioned below,
Or is there any other way?
I am just curious to know.

Sum = add(sys.argv[1], sys.argv[2])

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------

RE: Passing argument to Blue Prism - Script Execution VBO

ewilson — Wed, 12 May 2021 15:01:00 GMT

That's just a quick-and-dirty way of capturing two command line arguments. There are much better and more fault tolerant ways of doing it, but it's up to you to handle that in your Python development. You can use a statement like what I've shown below to get the total number of command line arguments that have been passed in and then work through a loop to load them into other variables or whatever you want to do with them.

n = len(sys.argv)

# Addition of numbers
Sum = 0
# Using argparse module
for i in range(1, n):
    Sum += int(sys.argv)

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------