Need to get Name and email id's from below json data please help me

Help Studio
, ,
1

{“page”:2,“per_page”:6,“total”:12,“total_pages”:2,“data”:[{“id”:7,“email”:“michael.lawson@reqres.in”,“first_name”:“Michael”,“last_name”:“Lawson”,“avatar”:“https://reqres.in/img/faces/7-image.jpg"},{“id”:8,“email”:“lindsay.ferguson@reqres.in”,“first_name”:“Lindsay”,“last_name”:“Ferguson”,“avatar”:“https://reqres.in/img/faces/8-image.jpg”},{“id”:9,“email”:“tobias.funke@reqres.in”,“first_name”:“Tobias”,“last_name”:“Funke”,“avatar”:“https://reqres.in/img/faces/9-image.jpg”},{“id”:10,“email”:“byron.fields@reqres.in”,“first_name”:“Byron”,“last_name”:“Fields”,“avatar”:“https://reqres.in/img/faces/10-image.jpg”},{“id”:11,“email”:“george.edwards@reqres.in”,“first_name”:“George”,“last_name”:“Edwards”,“avatar”:“https://reqres.in/img/faces/11-image.jpg”},{“id”:12,“email”:“rachel.howell@reqres.in”,“first_name”:“Rachel”,“last_name”:“Howell”,“avatar”:“https://reqres.in/img/faces/12-image.jpg”}],“support”:{“url”:“https://reqres.in/#support-heading”,“text”:"To keep ReqRes free, contributions towards server costs are appreciated!”}}

2

Hi @Siddeshwar_Revadi, welcome to the Community.

→ Use the Deserialize JSON activity to deserialize the JSON data into a JObject variable. Name it jsonObject. Provide the JSON data as input to the activity.
→ Add an Assign activity to create two lists: one for names and one for email IDs. Name them namesList and emailIdsList, respectively.
→ Then use the following expression to get the desired data:

namesList = jsonObject("data").Select(Function(x) x("first_name").ToString()).ToList()
emailIdsList = jsonObject("data").Select(Function(x) x("email").ToString()).ToList()

Hope this helps,
Best Regards.

3

@arjunshenoy

I am trying with for each loop by deserializing Json array activity giving an error as late binding can you help me with that logic