The JSON Manipulation Activity Package uses C# to manipulate and filter JSON text data. Since many API requests return responses in JSON text format this package offers a set of activities to either search through or filter an input JSON text data item. It also allows turning a serialized JSON string into a data table as well as enables direct indexing and filtering of JArray and JObjects strings.
Code samples demonstrating the usage of each activity are available as a C# and VB UiPath Project within the .docx guide.
This activity checks to see if the JSON text is an Array or an object. If neither, an exception is thrown.
This activity counts the number of entries within a JSON array.
Converts to Datatable into JSON text
Filter JSON Array Entries
This activity filters rows of a JSON Array text based on the input field/value collection.
This activity filters JSON text to include/exclude keys with names in the input Datatable.
This activity gets the value of a specific entry of a JArray given its index.
This activity converts JSON text to a Datatable.
JSON to Datatable (Skipping JArray)
This activity converts JSON text to a Datatable. Array entry data from the JSON will not be contained inside Datable.
For a JSON Object, this activity returns a CSV of all the properties in the Object and the number of entries. For a JSON Array, this activity returns a CSV of all the properties from all the rows in the Array and the number of entries.