How to extract Json values in for each loop

Hi All,

I have API response and i need to extract “Quote id” from it.
Can any one help me.

bulkQuoteBatchDetails .txt (5.2 KB)


As per structure you need to use this in for loop in argument

After deserializing …let output be jobj


Inside loop use currentItem("quoteId").ToString gives you the required details

Type argument will be jobject


Hi @thima

HTTP Request (output to apiResponse)
Deserialize JSON (Input: apiResponse, Result: apiResponse)

For Each (TypeArgument: Newtonsoft.Json.Linq.JToken, Values: apiResponse("bulkQuoteBatchDetails")(0)("quoteSummaries"))

   Assign (To: quoteId, Value: item("quoteId").ToString())

End For Each

hi @thima

Newtonsoft.Json.Linq.JObject.Parse(jObj)(“ArrayName”).Cast(Of Newtonsoft.Json.Linq.JObject).Select(Function(r) r(“Value Name”).ToString).toarray

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