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

ce60c479-dc81-4850-9295-78701497fba3.jpg

RPA Solution Architect

<p>Hello. Is there any timeline for at update of this package. After updating Studio to 2019.4.4 the package is uncompatible.</p>

First of all thanks for providing this solution.

I am not able to download the complete package.

After dowloading, it gives me a 0kb file.

https://connect.uipath.com/marketplace/components/convert-json-to-csv

it seems like the package i linked is a subset of this activity.

After converting JSON string to CSV, entire data comes in sigle row.

Please provide some suggestions to achieve this.

1. Make API call to download LinkedIn learning report

2. Convert received JSON file to CSV file

Nice Utility - Nice utility. saves a lot of time


Activity Review - Very useful activity considering the fact that there are lots of applications where Back end automation using REST API's are performed and the response are in nested json arrays .This set of activity will help getting the data in a go.


Very useful when de-serialising endpoint responses - Useful activity. Saves a lot of time else you need to know the format of JSON and put plenty of code to de-serialise it...


Very Nice work - Really very nice work. It will be useful ....


Very useful and time saving package. - The best part about this package is that it handles all nested complex JSONs &amp; converts them into desired output within no time. No longer there is need to write complex logic to deserialise the JSONs etc. It saves a lot of time and effort.


Very Helpful and ease the task.   - This package is very useful as there are a lot of requirements where in there is a need to convert JSON to CSV. Also in the scenarios where in one need to be more expressive about the structure of the data, XML is preferred over JSON, hence the conversion required. This package will really save a lot of time and efforts.


Fantastic plugin!! - One of the best plugin I have ever used.


 - Beautifully executed and does exactly what it says. Great work!


6e4be687-2d04-472c-bee1-948f3138ac8a.nupkg

The package contains 3 custom activities for conversion of JSON/JArray to other data formats:

These activities accept all types of complex and nested JSONs either in a text file (specified in the input property InputJsonFilePath) with valid JSON/ JArray in it or it accepts JSON/Jarray string directly (specified in the input property InputJsonString) and creates an output CSV file or XML file, at user's designated path (specified in the input property OutputCSV/XMLFilepath) , or generates a DataTable from the input Json.

Json to CSV: To view the data in tabular format, output CSV file can be opened using Excel. The first row in Excel will be the headers, generated from all the tag names in JSON file. In case of multi-level nested JSON, it retains the complete path of each element, separated by slash '/'. (as explained in image Explanation 1.)

Json To XML: This activity converts Json/Array in XML format without any data loss. In case of JArray, element tags are added for each array element and in case of non-array objects Json keys are converted to XML tags and Json values are converted to XML inner text. Output of this activity should be .xml file. (as explained in image Explanation 3)

Json To DataTable: It converts input Json/JArray to Datatable and provides the flexibility of directly applying all Data Table functions like filtering the JSON Data. In case of JArray, each Data row is converted to Excel Row Item and in case of non JArray structure, all the tags generate headers and in case of multi-level nested JSON, it retains the complete path of each element, separated by slash '/' so as to prevent any data loss. (as explained in image Explanation 2)

Time taken for this conversion is proportional to the level of nested data structure of JSON (between milliseconds to few seconds).

A pack of 3 activities which can handle any nested and complex Json / JArray and converts it into XML, CSV files and Data Table.

be18b789-cb0f-4845-a1f8-9edf3cdecec5.png

6783537b-130a-43b7-9aa1-1e636c6616b1.png

8ad7fa04-7273-43a4-a96f-0a15466f3c4e.png

61e3c5db-e031-4918-a063-a255e9055728.png

This is the first version of this package with 3 activities in it.

JSON / JArray Conversion Activities

JSON / JArray Conversion Activities

XML Conversion Activities…

PDF.co - Activities for PDF Documents…