From json string get the first and last value - with in for each loop

[rahul_gola]

Hi Team,

I am trying to get the value from a json where, i have located the value needed, but not able to get the first and last occurrence,

workflow,

deserialize json = now from json object = for each item in jsonobject

item(“status”).toString - getting the value from status in jsonobject which is [inserted, replace]
if status contains inserted, then get the first occurrence and the last occurrence,

could somebody please help me here

regards,
Rahul

[Rahul_Unnikrishnan]

Hello @rahul_gola

Please refer the below post. It will help to give your issue. You can use index to get the required values

How to quickly get the value from a json

Use deserialize JSON and try to use this in the message box @fightblue jsonObject.Item(“data”).Item(“ret”) which will give you the array you have in the ret key. then use deserialize json array and then loop through each object inside and get the value as jsonarrayserialized.Item(“word”)

[Nithinkrishna]

Hey @rahul_gola

Please post the JSON string itself & show us.

This way would be better to suggest solutions.

Kindly.

Thanks
#nK