I’ve spent an anomalous amount of time trying to configure a near-trivial one-liner to take a DataTable and convert it into JSON by means of “$dataTable | select $dataTable.Columns.ColumnName | ConvertTo-Json” commandlet chain.
- the activity configuration is documented, of course, but there are no examples.
- Frank Schikora recorded a tutorial and wrote a blog post for the cases of single commandlet and a script, string variables are used there in building one-liners on the fly, but not other types.
- I couldn’t find how to interoperate between PowerShell $var syntax and UiPath VB variables.
- It takes a non-trivial effort to troubleshoot type conversions in the output: I need a string, but what’s the syntax to output ONE string where a collection is expected?
Any comments will be appreciated.