We were founded in 2005 in a tiny apartment in Bucharest, Romania as DeskOver.

Fittingly, it was a customer who, in 2012, first saw the immense possibilities for us in the fledgling RPA market. Our desktop automation product launched in 2013. In 2015, we introduced our enterprise platform along with our new name.

Today, UiPath is the fastest-growing enterprise software company in history with scores of offices, thousands of employees, partnerships with the world’s best consulting and BPO firms, a 500,000-strong developer community, and 5MM+ robots at work in over 5,000 global enterprises.

Our mission is to deliver the leading Robotic Process Automation platform to our clients for an automation first mindset.

We build software robots that automate repetitive processes. Our software robots take on the tedious, mind-numbing work and free people to do the more stimulating, creative work worth doing.

But no matter how much we’ve grown, one thing hasn’t changed. We’re still building a company we love to work for

<p>The Custom activity package can perform the following tasks using some drag-and-drop activities:</p><p>&nbsp;This Package contains the following activities:</p><ul><li>Convert Datatable to JSON</li><li>Convert JSON to CSV</li><li>Convert JSON to XML</li><li>Convert XML to JSON</li><li>Validate JSON without Schema (Checks format of the JSON is correct)</li><li>Validate JSON with Schema (Compares JSON with the given Schema)</li><li>Validate XML&nbsp;</li></ul>

The Custom Activity package can perform the tasks related to JSON operations, which can be readily used to perform actions like converting JSON to XML, JSON to CSV, etc

Product Consultant

I am able to use other activities doing similar things, but this activity doesn't work from this package with the test JSON I have. Error messsage posted below.

Source: Doesn't work  Convert JSON to CSV

Message: Unexpected JSON token when reading DataTable. Expected StartArray, got StartObject. Path '', line 1, position 1.

Exception Type: Newtonsoft.Json.JsonSerializationException

RemoteException wrapping Newtonsoft.Json.JsonSerializationException: Unexpected JSON token when reading DataTable. Expected StartArray, got StartObject. Path '', line 1, position 1. 

   at Newtonsoft.Json.Converters.DataTableConverter.ReadJson(JsonReader reader, Type objectType, Object existingValue, JsonSerializer serializer)

   at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.DeserializeConvertable(JsonConverter converter, JsonReader reader, Type objectType, Object existingValue)

   at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)

   at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)

   at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)

   at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings)

   at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value)

   at UiPathTeam.JSONUtilities.ConvertJSONToCSV.Execute(CodeActivityContext context)

   at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)

   at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

   at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

Here is the JSON I tried to convert to CSV.

  "isTheUserPresentedWithAnErrorMessage": "yes",

  "isThisActionHubWorkflowRelated": "yes",

  "whichActionHubWorkflowApplicationIsImpactedKb126189": {

    "clientComplaintAgainstComplexBrMgr": true,

  "actionHubWorkflowAccountImpactedInContext": "23452345",

  "isInternetExplorerCurrentlyOpen": "yes",

  "closeAndRestartIeDidThatResolveTheIssue": "no",

  "closeAndRestartDidThatResolveTheIssue": "no",

  "agentActionResolved6": "Send form data."

I have tried this package, didn't work for my usecase.

Convert JSON to CSV: Unexpected JSON token when reading DataTable. Expected StartArray, got StartObject. Path '', line 1, position 1.

1. Make API call to download LinkedIn learning report

2. Convert received JSON file to CSV file

Hi Tuhin. This works great for simple DataTable to JSON. But how can we created nested JSON? 

{"name":"John",
  "age":30,
  "cars": {"car1":"Ford",
      "car2":"BMW",
      "car3":"Fiat}

JSON Utilities

JSON Utilities

Help

How To