How to convert UiPath execution log file to Json or XML format

@Neha_Kumari1

just find some introductions to the main building blocks.

Filtering / Preprocessing the log lines:
grafik

with regex we do find the JSON part
Let jo = … we do parse a string into a JObject
also did some demonstrations on retrieval, filterings, and orderings

there are some jobs that do not have an end log. So it is suggested to group the lines on the job id:
grafik

finally, we demonstrate on a prototype level on how a report data table can be populated including handling the missing endlines:

Result:
grafik

Kindly note: No of Transaction Info is not in the logs:

  • can be added e.g. with a custom log field
  • ORC API
  • ensure Namespaces are imported: Newtonssoft.Json,Newtonssoft.Json.Linq, System.Text.RegularExpressions

find starter help here:
ExecLogExtractor_Demo1.xaml (13.1 KB)

further info on LINQ and Regex

1 Like