May I know how can go get the keys of nested JSON key value pairs of a specific value?

[supermanPunch (Arpan)]

@Lee_Hong_Yan

{“a”:[“Math”],
“b”:,
“c”:[“Science”:[“Physics”]]
}

Hi @Lee_Hong_Yan ,

Could You Check the Json Data Provided. It seems to be an Invalid Json.

If the Input Data was Expected to be in the below Way :

{
	"a": ["Math"],
	"b": [],
	"c": [{
		"Science": ["Physics"]
	}]
}

Then, we could perform the Parsing and Extract the Required Data. Follow the Steps in the Below Post but use the Below Expression :

Json google vision

Hi @andreus91 , Give a Try on the below Steps : Use Deserialize Json Activity with TypeArgument as JsonObject and input as the Output from the API, Let the output be jObj Next, we could get all the description field values from the textAnnotations JsonArray using the following Expression : String.Join(",",jObj("responses")(0)("textAnnotations").cast(Of JObject).Select(Function(x)x("description").ToString)) This provide us all the description field values present in the textAnnotations …

jObj("c")(0)("Science")(0).ToString   //To Access First Element in Science

If Multiple Elements Found, We could Keep it in the below way :

jObj("c")(0)("Science").ToString

We might need to do String Operations to get the Output as required.

Let us know if there is any change in the Input data and also Check if the above method works