Read the data from Jsonarry to convert into datatable

Help Studio
, ,
1

Hi team,
the below format are Jsonarry

image
image1132×506 23.8 KB

str4jsonarry.txt (861 Bytes)

Extract the values from Jsonarray and expected out below

output :

The image shows a spreadsheet with data organized in six columns covering numeric values, with contents including numbers and rounded totals in the final column. (Captioned by AI)
The image shows a spreadsheet with data organized in six columns covering numeric values, with contents including numbers and rounded totals in the final column. (Captioned by AI)438×222 3.41 KB

Can any one help me

4

On of many options as a quick prototype in LINQ which can also be decomposed into essential activities:

Variables:

grafik
grafik541×108 12.6 KB

strJSON is your JSON as String

The image depicts a sequence of four assign activities in a UI workflow, each with specific variables being initialized or assigned values using data transformation and JSON operations. (Captioned by AI)
The image depicts a sequence of four assign activities in a UI workflow, each with specific variables being initialized or assigned values using data transformation and JSON operations. (Captioned by AI)481×457 36.4 KB

dtData = Newtonsoft.Json.JsonConvert.DeserializeObject(Of DataTable)(strJSON)

myLKDict =

(From d In dtData.AsEnumerable()
Let c4 = d("details").toString.Trim
Let se = System.Text.RegularExpressions.Regex.Match(c4,"(?<=line:).+(?=\.)").Value
Let arrValues = se.Trim().Split(","c)
Select t = Tuple.Create(d("name").toString.Trim, arrValues)).ToDictionary(Function (x) x.item1, Function (x) x.Item2)

arrRowJOs =

(From i In Enumerable.Range(0,myLKDict.First().Value.Length)
Let rp = myLKDict.Select( Function (kvp) New JProperty(kvp.Key, kvp.Value (i) ) )
Select jo = New JObject(rp)).toArray

dtResult = JArray.FromObject(arrRowJOs).ToObject(Of DataTable)

Visuals:

The image shows a JSON-like data serialization format being used to organize product information including case quantity, SSC, bottle size, units per case, and gross weight. (Captioned by AI)
The image shows a JSON-like data serialization format being used to organize product information including case quantity, SSC, bottle size, units per case, and gross weight. (Captioned by AI)808×496 126 KB

Ensure the also the following imports:

grafik
grafik309×174 17 KB

And:
grafik
grafik234×193 19.4 KB

For some trainings also have a look here:
[HowTo] LINQ (VB.Net) Learning Catalogue - Help / Something Else - UiPath Community Forum
[CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum

and feel free to add some cleanups e.g. ml String removal …

1 Like
5

Install the UiPath.WebAPI package, and use the Deserialize JSON activity. Set it to datatable.

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.