Is it possible to pass a array of string to UIpath Sql Parameter(Collection)

Help
2

I built something recently where I need to build a Query with a list of invoices.
Here is a snapshot:
image
I did not use any arguments and just concatenated the Query string with variables that I was providing it such as the column name and a comma-delimitted list of invoices.

If you have an array you can use .Select() and String.Join() on it to quickly manipulate it with 's and ,s
Here is an example:

String.Join(",",arrayvar.Select(Function(x) "'"+x+"'"))

Hopefully any of this is helpful.

Regards.

2 Likes