How to extract Json values in for each loop

[thima (Himabindu)]

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)

[Anil_G (Anil Gorthi)]

@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

[pravallikapaluri]

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

[sasi_poosarla (sasi p)]

hi @thima

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