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)
give a try on:
(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
retuns a list(ofString()) - List with string arrays
find starter help here:
JP_JOList_Get0_SpecPrp_Val2.xaml (5.8 KB)
This is working great. Thankyou.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.