Need to read all the values from a JSON object

Help Activities
, ,
1

Hi All,

I need to read all the values from the attached JSON file. Currently I am able to read folder path & rename to from the JSON file using : "myJObject.Properties.Skip(3).Select(Function (x) x.Name & “-” & myJObject(x.Name)(“Rename to”).ToString).toArray "

I also want to get the Filetype and File Directory information in the same array. Could some one help me with this?

json.txt (5.0 KB)

2

@Sairam_RPA
give a try on:
grafik

(From x In myJObject.Properties.Skip(3).Select(Function (x) x.Name)
Let a = x
Let k = myJObject(x).Value(Of JObject).Properties.Select(Function (p) p.Name)
Let d = k.Select(Function (x2) myJObject(x)(x2).ToString).toArray
Let ra = d.Prepend(a).toArray
Select ra).toList

retuns a list(ofString()) - List with string arrays

grafik
grafik

find starter help here:
JP_JOList_Get0_SpecPrp_Val2.xaml (5.8 KB)

1 Like
3

This is working great. Thankyou. :slightly_smiling_face:

4

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