I want to retrieve values from below JObject (results from deserialize JSON activity)
The ones underlined in red are key value pairs. e.g. I want to get value of ‘first_name’ as tester
(From jo In myJObject("result").Values(Of JObject)
Where jo("sc_item_option.value").Value(Of String).Equals("tester")
Select x = jo("sc_item_option.item_option_new.name").Value(Of String)).First()
if possible maybe you can share some sample data json with us for cross checks
I need to pass key as “first_name” and value should be “tester”
Same for the key “last_name”, I am looking to get the value “test 30-Nov-2021”
I need to retrieve values of 10 keys here.
maybe you want to swap the filter logic, look for name, get the value. So just swap where and select keys
(From jo In myJObject("result").Values(Of JObject)
Where jo("sc_item_option.item_option_new.name").Value(Of String).Equals(YourFilterStringVar)
Select x = jo("sc_item_option.value").Value(Of String)).First()