Storing SQL Queries as assets in UIPath Orchestrator

[Mike_Palmer]

I have a SQL Query with some functions that I want to store as an asset, so I can pass it to a SQL Server for execution. The idea is that it can be edited by a user from time to time, so storing it as an asset is a good way to allow this.

The problem seems to be that Orchestrator assets cannot store SQL Code with functions like CONVERT(), CAST, CONCAT() and so on as the TEXT asset is checked at time of save.

Is there a workaround for this?

Thanks in advance…

Mike Palmer.

[Srini84 (Srinivas Kadamati)]

@Mike_Palmer

CAST

@Mike_Palmer

Welcome to forums

Create a Text assets and paste your query

It might be the character limitation also

Check below for your reference

Orchestrator Text Asset Length

Do we still have character limit as 4000 for Text Asset? if not please specify what’s the current limit to that

It should create, can you share a screenshot if you are getting any error?

Hope this will help you

Thanks

[Mike_Palmer]

Thanks @Srini84 for the suggestion - I have amended my query, and CONVERT() works!

Kind regards,

Mike.