Get a value from an array within a collection

I am using Kommo and I just need to get email from this structure.
I have checked all the topics but I was not manage to figure it out.
Can anyone help me on that?
Many thanks.

Hi @Global_Investments_T
created a sample json structure:

you can use the following to get the email:

output:

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel

2 Likes

Unfortunately it does not work. I need to filter out the Email from the collections. But this does not work.
The JSON Structure is as follows.

[
{
“object”: [
{
“field_id”: 2345512,
“field_name”: “Database Name”,
“field_code”: null,
“field_type”: “text”,
“values”: [
{
“value”: “Gokhan Ucar_Test”
}
]
},
{
“field_id”: 2345514,
“field_name”: “Country”,
“field_code”: null,
“field_type”: “text”,
“values”: [
{
“value”: “Turkey”
}
]
},
{
“field_id”: 2252722,
“field_name”: “Email”,
“field_code”: “EMAIL”,
“field_type”: “multitext”,
“values”: [
{
“value”: “gokhanuc@gmail.com”,
“enum_id”: 1602250,
“enum_code”: “PRIV”
}
]
},
{
“field_id”: 2252720,
“field_name”: “Phone”,
“field_code”: “PHONE”,
“field_type”: “multitext”,
“values”: [
{
“value”: “+905337209541”,
“enum_id”: 1602244,
“enum_code”: “HOME”
}
]
}
]
}
]

Hi @Global_Investments_T

we have tried with the structure provided
work flow:
image

iterator:
image

text aggregator:

Output:

To get all the values as an array you can use array aggregator instead of text aggregator

3 Likes