A consulting, implementation and managed services firm, passionate about the ‘Future of Work’.

We help enterprises leverage the latest Robotic Process Automation, Intelligent Automation and innovative resourcing solutions.

The Symphony team is an experienced group of practitioners known for being champions of innovation and the implementers of change. We are recognized and respected experts in the technologies and approaches that represent the ‘Future of Work’.

We are recognized as a leading automation service provider. Our extensive experience, process-first approach, and background in consulting and outsourcing services, allows us to create clear value and rapid ROI for our clients around the world.

d797799d-f55b-4ca4-9bd2-4c6301e27e44.jpg

439aca74-bd9a-4547-89fd-f21525dba87f.jpg

Head of UiPath

d127f6b6-db56-4c7a-a6c6-142bda35d6af.nupkg

7a70dee7-d03d-4f2c-a5e0-2b472c257690.png

The UiPath JSON Manipulation Activity Package uses C# to manipulate and filter JSON text data. This package offers a set of activities to either search through or filter an input JSON text data item. You can also turn serialized JSON string into a datatable.

  

Many API requests return responses in JSON text format. This package makes efficient C# JSON manipulation facilities available which would otherwise require conversions and looping in UiPath. With this package you can directly index and filter JArray and JObjects strings.

  

Code samples demonstrating the usage of each activity are available as a C# and VB UiPath Project within in the .docx guide.

This UiPath JSON Manipulation Package provides activities to manipulate and filter JSON text data.

419bb022-289d-4f39-a16f-33da33226f9b.png

Visual Basic

17b6d452-ca3d-46eb-8857-2bf16329894c.docx

a14aae29-85eb-4f43-ab21-398f249b38b2.zip

74f1cd9a-7d4b-456b-8051-6ec0c83ce439.nupkg

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.

  

**Check if Array or Object**

This activity checks to see if the JSON text is an Array or an object. If neither, an exception is thrown.

**Count Entries In Array (**[**Demo Video**](https://youtu.be/P-nF2guYHB8)**)**

This activity counts the number of entries within a JSON array.

**Datatable to JSON**

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.

**Filter JSON Keys**

This activity filters JSON text to include/exclude keys with names in the input Datatable.

**Get Entry by Index (**[**Demo Video**](https://youtu.be/CjqxVtPMvts)**)**

This activity gets the value of a specific entry of a JArray given its index.

**JSON to Datatable**

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.

**List Properties (**[**Demo Video**](https://youtu.be/Jx4a9UbhWdw)**)**

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.

This JSON Manipulation Package provides activities to manipulate and filter JSON text data.

Version	Release Date
1.0.3	January 21, 2022
Package metadata update No functionality changes have been made.
1.0.2	December 20, 2021
Package metadata update No functionality changes have been made.
1.0.1	November 25, 2021
Improved User Experience through activity icons, and informative input and output arguments. Video demos have been uploaded with installation and activities guidelines. No functionality changes have been made.
1.0	November 3, 2021
Initial release.

SDS - JSON Manipulation