I am trying to call a SQL which has a IN Clause. in this in clause i want to pass dynamically the list of id which are comma delimited string values. i get issue while doing this where message is typically that String array cannot be cast to object. Now if i change the in type to String in Paramater then i can pass the string but then i need to manually build the string like ‘123’,‘345’
Is this a UIPath constraints of not able to pass the array to the Sql query, or is there some other way to achieve this. ?
For now we are relying to create the entire SQL in the assign variable and then pass the SQL as a string. Any guidance here is highly appreciated.