MarketplaceStudioActivitySDS - JSON Manipulation

Create your first automation in just a few minutes.Try Studio Web

SDS - JSON Manipulation

SDS - JSON Manipulation

by Sitel Group

StarStarStarStarStarStarStarStarStarStar

0

Activity

Downloads

116

back button
back button
next button
next button

Summary

Summary

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

Overview

Overview

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)

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)

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)

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.

Features

Features

This package:

  • Saves 56 hours of development and testing of a such component
  • extends the functionalities provided by the UiPath Web Activities Pack and includes filtering, indexing, and conversion actions between JSON text and Datatable data items.
  • allows JSON objects to be manipulated directly without having to loop through explicitly which is time-consuming for large JSON objects.

Additional Information

Additional Information

Dependencies

External References (dlls): System.dll, System.Data.dll, System.Drawing.dll, System.Core.dll, System.Xml.dll, Newtonsoft.Json.dll Imported namespaces: System, System.Drawing, System.Data, System.Text, System.IO, System.Collections, System.Collections.Generic, System.Linq, Newtonsoft.Json, Newtonsoft.Json.Linq

Code Language

C#, Visual Basic

Runtime

Windows (.Net 5.0 or higher)

Publisher

Sitel Group

Visit publisher's page

Trusted Source

License & Privacy

License Agreement

Privacy Terms

Technical

Version

1.0.3

Updated

March 8, 2023

Works with

Studio: 21.10 - 22.10

Certification

Gold Certified

Support

Email: support.uipath@sykes.com

Mon-Fri 9 AM to 5 PM GMT; Response time: 1 working day (24 hours); Resolution time: 10 working days

Resources

Similar Listings