a6e5b969-be6e-4756-ae53-47d3cb899ca4.png

317ce761-8bf1-4c4f-9bed-cb67f005209e.PNG

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}

SchemaValidation: Can not convert Array to Boolean.

I'm getting this issue  while using "Validate JSON with JSON schema"

600429b7-88d7-4fdb-ba5c-b463e5612b19.nupkg

<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

JSON Utilities

JSON Utilities

XML Conversion Activities…