MarketplaceStudioActivityJSON / JArray Conversion Activities

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

JSON / JArray Conversion Activities

JSON / JArray Conversion Activities

by Internal Labs

9

Activity

Downloads

22.1k

Sivan Odeni
Posted 2 years ago

Hi,

There is an update regarding compactible version for windows projects?

I saw that you answered here 5 months ago that you would update the package.

I have a project that I converted from window legacy to window that use the Json to Data table activity.

Thanks,

Sivan

Navneet Panpaliya
Posted 2 years ago

Hello Rahul,

I tried this package.

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

Please provide some suggestions to achieve this.

Objective:

1. Make API call to download data as json

2. Convert received JSON string to CSV file

Please let me know how I can share sample input and output files.

Thank you!

Rahul Aggarwal
Posted 2 years ago ago

Hi Navneet, 

To achieve this you need to use the "Json To Data Table" activity and then convert the datatable to CSV format. 

Regarding the data coming in a single row, please verify if your input JSON string is in a valid JArray format. 

In case you are not able to resolve the issue, you can share your input file on rahulaggarwal2305@gmail.com 

I will have a look and will revert.

Thanks, 

Rahul Aggarwal

Oguz Teoman Zeki-Oguz
Posted 2 years ago

Hi, 

I would like to use it, but at the marketplace I can't download it because there is no compactible Version for Windows Projects :( Is there any hope that a version for Windows projects will exist?

regards,

Rahul Aggarwal
Posted 2 years ago ago

Hi Oguz,

Surely I will update the package as per the .NET version 6 and will upload it soon. 

Thanks for raising the issue.

Rahul

Yasser Mekled
Posted 3 years ago

Hi Rahul,

Thank you for this package, I use it in my "Windows-Legacy" projects, but the company asks for investigate upgrading to new .net v6.

Is there a plan to upgrade this package to dotNET v6? either to "Windows" or "Cross-Platform".

regards,

Rahul Aggarwal
Posted 2 years ago ago

Hi Yaseer,

Sure, I will update the package as per the .NET version 6 and will upload it soon.

Thanks for raising the issue.

Rahul

Rajesh Attada
Posted 5 years ago

Hi Rahul,

I tried this package.

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

Please provide some suggestions to achieve this.

Objective:

1. Make API call to download LinkedIn learning report

2. Convert received JSON file to CSV file

Rahul Aggarwal
Posted 4 years ago ago

Hi Rajesh,

Firstly I would like to thank you for trying out these activities and I am really sorry for such a long delay in the response. If your input Json is in Jarray format then you will be able to get data in Tabular format. I have shared some examples as well for the reference. Meanwhile could you please share the input Json file with me, so that I can analyse your json format.

Let me know your thoughts :) 

Regards,

Rahul

Alicia Jeffers
Posted 5 years ago

How do we install this?

Rahul Aggarwal
Posted 5 years ago ago

Hi Alicia,

  1. To install this package follow the steps-
  2. Go to Manage Packages menu.
  3. Select 'Go!' under 'All packages' on the left side of the window.
  4. Search for 'JsonDataConverter' in the search bar.
  5. Click on 'Install' and 'Save'.

Do let me know if you need any help.

Adam Hanson
Posted 5 years ago

Is this a duplicate of this activity?

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

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

Rahul Aggarwal
Posted 5 years ago ago

Hi Adam, initially only json to csv was published but later a complete package with other options was also published which includes this activity as well.

Santhosh Anantharaghavan
Posted 5 years ago

Hello ,

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.

Is there any other way to download this?

Please help.

Thanks for your support

Santhosh

Rahul Aggarwal
Posted 5 years ago ago

Hi Santhosh,

Thanks for the heads-up. Please try downloading it now. Do let me know if still you face any difficulty.

Jakob Borg Andersen
Posted 5 years ago

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

Rahul Aggarwal
Posted 5 years ago ago

Hi Jakob, Firstly, thank you for trying out these activities. This package is compatible with the all the versions including 19.4 & 19.10. Could you please share the details of the issue you are facing along with the screenshot. I will be happy to help.

You can share the details here or directly send me an email o at rahul.aggarwal@uipath.com