How to extract Json values in for each loop

Help Studio
, ,
1

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)

2

@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

3

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
4

hi @thima

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

5

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