JSON Utilities

SchemaValidation: Can not convert Array to Boolean.

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

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

Like this:

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

}

Hi Tuhin,

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

Got below error:

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

Objective:

1. Make API call to download LinkedIn learning report

2. Convert received JSON file to CSV file

Hello, Tuhin, 

Can you test the Convert JSON to CSV?

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.

20.4.1

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\

   at Newtonsoft.Json.JsonConvert.DeserializeObject\

   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.

{

  "ticketNumber": "test",

  "WorkstationID": "2345234",

  "DetailedDescription": "23452345",

  "ErrorReproduce": "yes",

  "menuNavigationalSteps": "23452345",

  "isTheUserPresentedWithAnErrorMessage": "yes",

  "takeScreenshot": false,

  "Accountselection": "specificAccount",

  "Version": "523452",

  "isThisActionHubWorkflowRelated": "yes",

  "selectTroubleshootingType": "Basic",

  "submit": true,

  "errorMessage": "23452345",

  "account": "2345234",

  "isActionHubWorkflowLoading": "yes",

  "whichActionHubWorkflowApplicationIsImpactedKb126189": {

    "acctMaintenanceAddressChg": false,

    "acatsDtccDrs": false,

    "checkRequest": true,

    "clientComplaintAgainstComplexBrMgr": true,

    "acatTransfer": true,

    "notListed": false

  },

  "actionHubWorkflowAccountImpactedInContext": "23452345",

  "isInternetExplorerCurrentlyOpen": "yes",

  "closeAndRestartIeDidThatResolveTheIssue": "no",

  "isCurrentlyOpen": "yes",

  "closeAndRestartDidThatResolveTheIssue": "no",

  "agentActionResolved6": "Send form data."

}