This is my json, I want to read the values and save into excel. { “marketValues”:[ {“location”:“kakinada”,“species”:“shrimp”,“subSpecies”:“bolt shrimp”,“date”:“43799”,“count”:100,“rate”:116,“rateValue”:0}, {“location”:“kakinada”,“species”:“shrimp”,“subSpecies”:“bolt shrimp”,“date”:“43800”,“coun…

@sandeep_deshpande - So this is Json contain a Json array. So You have use this hierarchy only Let’s say I want **rate ** of the marketValues so these are the steps: Read the text. DEserialize the JSON using Deserialize Json Object activity and type argument will be Newtonsoft.Json.LinqJObject r…

How to read key_value from the json array

Help

pattyricarte (Patty Boy) January 17, 2020, 9:40am 2

Hi @sandeep_deshpande

You can check this out for your reference.

https://go.uipath.com/component/convert-json-to-csv

cheers

Happy learning

Huge Json file in to excel

Topic		Replies	Views
API out put to excel Studio excel , activities	6	935	November 16, 2020
Formula to read value from json Help studio	4	7311	January 24, 2018
Need help with reading stuff from JSON Help studio , question , json	11	1133	December 6, 2019
Deserialize JSON Array nested list to excel? Activities datatable , excel , activities , api , question	14	2309	November 26, 2021
JSON file Issue Activities activities , web , question	12	1206	May 17, 2022

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

How to read key_value from the json array

Related Topics