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.

Thanks
bulkQuoteBatchDetails .txt (5.2 KB)

@thima

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

After deserializing …let output be jobj

Jobj(0)("BulkQuoteBatchDetails")("quoteSummaries")

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

Type argument will be jobject

Cheers

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.