Convert Json Key Value Pair

[ppr (Peter Preuss)]

@shanmugaraj27may
Welcome to the forum

as it is JSON we would process it preferred with JSON Api instead of Text approaches

For this structure:

@shanmugaraj27may

[{
“FieldName” : “city”,
“FieldValue” : “NewYork”
},
{
“FieldName” : “Zip Code”,
“FieldValue” : “1234”
}
]

Can doit with a oneliner (for String)

 "[" & JSonConvert.SerializeObject(JArray.Parse(strJSON).ToDictionary(Function (x) x("FieldName").Value(Of String), Function (x) x("FieldValue").Value(Of String)))& "]"

for JArray

JArray.Parse("[" & JSonConvert.SerializeObject(JArray.Parse(strJSON).ToDictionary(Function (x) x("FieldName").Value(Of String), Function (x) x("FieldValue").Value(Of String)))& "]")

But lets shift away from hard to maintain oneliners and lets do following:
Vars:

Flow:

With Parameters:

Find starter help here:
Flat_JArrayObjectsToSingleJObjectArray.xaml (7.2 KB)
data.json (114 Bytes)